Expanding Merged Cells

  • Thread starter Thread starter Marc Helberg
  • Start date Start date
M

Marc Helberg

Can merged cells be expanded when the text exceeds the
size of the cell? I know this is possible with single
cells.

Regards,

Marc
 
Marc

Merged cells will allow "wrap text" from Format>Cells>Alignment but..........

Excel has a problem auto-fitting merged cells.

You can resize manually or via Macro. Jim Rech has written
code for this.

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

Note also a recent adaptation of this code by Greg Wilson.

http://makeashorterlink.com/?P37D24B15

The best cure is DON"T USE MERGED CELLS. They cause no end of problems with
copying, pasting, sorting, filtering.

Gord Dibben Excel MVP
 
Gord:

Thanks for the info, looks like I'll stay away from merged
cells!

Marc
-----Original Message-----
Marc

Merged cells will allow "wrap text" from
Click to expand...
Format>Cells>Alignment but..........
 
Back
Top