Not all text showing in cell

[silvertabb]

Hi
Is there a way to do auto fit (cell height and not width) in excel? Some of the cells in my table don't show the entire text content. I have too many cells to manually fix the cell height. I am looking for a quick fix. I high-lighted the column containing the cells with problems and tried ROW-AUTO FIT and that did not work.

Your help will be appreciated.

thanks

 

[Andrew Poulsom]

Have you set the cells' alignment to Wrap Text?

 

[silvertabb]

Yes

 

[Andrew Poulsom]

If so, what you did worked for me.

 

[silvertabb]

Even I tried FORMAT->ROW->Autofit on individual cell with no luck.

 

[shg]

How much text (how many characters) are in the cells?

Excel has limits on both row height and the amount of text you can display.

 

[Andrew Poulsom]

It's not a merged cell is it? If so row autofit won't work:

http://support.microsoft.com/kb/212010

 

[silvertabb]

copying and pasting the entire table into a new file fixed the problem.