Row Height

[Anita]

Can anyone tell me an easy way to set the row height when
using the merge across cells feature and text wrap. e.g. I
am merging 6 cells and then typing 3 lines of text
(wrapped). But I have to set the row height manually as
any type of autofit does not work. My document is a
combination of text and tables and charts, so I would love
an easy way to set the row height so all text is visible.

Any ideas?

Thx.

 

[Sierra]

Why not high light the row that the merged cell is in.
Then, FORMAT, ROW, HEIGHT.

Hope this helps

MM Sierra

 

[Dave Peterson]

Jim Rech wrote a macro called AutoFitMergedCellRowHeight that you may like:
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