cell properties

[Guest]

I sometimes use merged cells to display concatenated info. After about 1100
characters, the cells won't display the remaining text no matter how heigh
the rows or wide the colums.

Question #1 Is there a way to set the cell limits for how many characters
can be displayes?

Question #2 In the above senario the merged cells that contain the
concatenate instructions will not automatically adjust the row heighth for
the content even thought the wrap text function is turned on. Is there a way
to do this?

 

[Gord Dibben]

A cell will accept 32767 characters but by default Excel will show only 1024 of
these characters in the cell.......you see them all in the formula bar.

Merging several cells into one does not change this.

You still have only one cell.

To see more chars in a cell, you must use an Alt + Enter linefeed every 80-100
characters or a smaller font size.

Merged cells will wrap text but not autofit. You need VBA event code to make
that happen.

My advice..........don't use merged cells. They cause no end of problems with
such as above and other operations like cut, copy, paste, sort, filter.

If you want the code for autofit see this thread.........

http://tinyurl.com/2oehen


Gord Dibben MS Excel MVP