Automatic Cell Fit

  • Thread starter Thread starter Wendy Reeves
  • Start date Start date
W

Wendy Reeves

Hello Everyone:

I have created a spreadsheet in Excel, and have set cells
to wrap text automatically. The problem is that the cells
do not expand vertically to accomodate larger amounts of
text. Is there a way to do this?

Thanks,

Wendy
 
If you've set the rowheight manually, then excel will respect that and not
automatically adjust the rowheight when you add/delete text.

But if you Format|row|autofit, excel will adjust whenever necessary.

That said, excel won't automatically fix rows that have merged cells.

If you have merged cells, you may want to use Jim Rech's macro:

http://groups.google.com/groups?threadm=e1$1uzL1BHA.1784@tkmsftngp05

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
 
Back
Top