in format cells, number tab, change to "general".

"Gord Dibben" wrote:

Select your rows.

FormatRowAutofit.

Also make sure the rows are set for Wrap Text.


Gord Dibben MS Excel MVP

On Tue, 7 Nov 2006 08:46:02 -0800, kimdnw
wrote:

Working in spreadsheets with established columns. However, as data is added
and subtracted, text repeatedly becomes hidden when rows shift. Can I cause
the cells to "auto fit" text to the row without changing column width?