Row Height-expand if text wraps in a cell

P

Penny Miller

I have a worksheet that has a comments column that is formatted to wrap text
if needed for each cell. My problem is I need the row to automatically
adjust to the height of what ever is entered in that cell.

Using Excel 2007
 
B

Bassman62

Penny,

Make sure the Rows have been formatted to "Autofit Row Height". Select rows
then on the Home tab, Format...
Hope this helps.

Dave
 
S

Selah West

I have tried the "Autofit Row Height" and it is not working. Am I supposed
to be selecting a certain area for this to work? The "Autofit Column Height"
works but not for rows...any tips?
 
G

Gord Dibben

Selah

Do you have any merged cells in your range?

These disable the Row Autofit when set to wrap text.

Either get rid of them or you will have to use VBA event code.


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

Top