How can I get a cell to automatically resize vertically with the amount of text in it ??

L

luke58

How can I get a cell (row) to automatically resize vertically with the
amount of text in it ??
 
G

Gord Dibben

Set to "warap text" and row autofit.

If it is not working for you, could be you have merged cells which autofit will
not handle.

Need VBA code or manually fit to size.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Increasing cell size (vertically) 1
Excel: Auto Resizing Cells Vertically 3
Vertical spacing when using <Alt><Enter> 1
Array macro question 4
JSON to CSV Conversion Gone Wrong: Got a Single Line of 991 Entrieswith Cells In Between. How Do I F 13
Visual Basic in Excel, Resize the Cell automatically 2
Spacing around text 1
Space round text in cells 0

Top