Cell Formatting

[abacon1960]

When working in a cell when using WRAP TEXT, is there some way to tell or have the text automatically resize the cell row heights so I do not have to resize the Row Heights every time?

 

[Yongle]

You are having problems because you have previously manually changed row height
- NEVER resize row manually if you want it to resize automatically

Test on a new worksheet
- add WrapText to a few cells and insert text - row height is ALWAYS auto-adjusted
- next resize one of the rows manually - it no longer auto-adjusts

 

[DanteAmor]

Run this macro to put the rows in auto fit mode. After the rows will be adjusted automatically.

Sub macro()
Cells.EntireRow.AutoFit
End Sub

INSERT A MODULE
Press Alt-F11 to open the VBA editor. From the menu select Insert > Module. On the sheet that opens, paste the code previous.
Close the editor (press Alt-Q). From Excel, press Alt-F8 to open the macro selector, and select "Macro" and press Run.

 

[pedro-egoli]

DanteAmor, If its possible how do I make sure this macro is in every excel 2003 sheet I open