Text wrap - row hight

Hi Lisa.

Thank you for the forum question.

I have been trying different options and it doesn't seem to be easy to do what you want. Autofit row hight doesn't work in Excel if you are working with merged cells.

I ended up changing the row hight myself for each row and of course this is not a good solution.

Have you tried to use you print option to scale the text to fit an A4?


Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Read more: https://www.stl-training.co.uk/post-34560-formula-shows-quarters.html #ixzz2wE8kbKnu

Hello Lisa,

Thank you for your post. An alternative I would suggest is to embed the Word document into Excel. To do this, you click the Insert tab in Excel. In the Text group, select Object. Select Create from File and browse for the relevant document. Double click this document and click OK.

The Word document is now embedded in Excel. When you double click the embedded document, you can scroll through and read it. In fact, all the Word functions become available. Also, you can resize the outer box of the embedded document to your liking

This is much easier and less fiddly than copying and pasting just the Word text.

I hope this meets your needs.

Kind regards
Marius Barnard
Microsoft Office Trainer