If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Automatic Cell Fit
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 |
#2
|
|||
|
|||
Automatic Cell Fit
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?thre...%40tkmsftngp05 If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm Wendy Reeves wrote: 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 -- Dave Peterson |
Thread Tools | |
Display Modes | |
|
|