Cell Formatting

abacon1960

New Member
Joined
Jul 28, 2014
Messages
49
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

Well-known Member
Joined
Mar 11, 2015
Messages
4,717
Office Version
365
Platform
Windows
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

Well-known Member
Joined
Dec 3, 2018
Messages
8,971
Office Version
2007
Platform
Windows
Run this macro to put the rows in auto fit mode. After the rows will be adjusted automatically.

Code:
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

Well-known Member
Joined
Apr 25, 2004
Messages
1,116
DanteAmor, If its possible how do I make sure this macro is in every excel 2003 sheet I open
 

Forum statistics

Threads
1,082,587
Messages
5,366,485
Members
400,894
Latest member
frog9000

Some videos you may like

This Week's Hot Topics

Top