Merged cells limitations

G

Greg Davison

I've acquired a spreadsheet that is an application form.
Certain sections are merged cells to create a large text
box. When entering text within the merged cells, only a
certain amount is displayed in the merged cells and only a
certain amount will print although the cell contents
displays the entire text. How can I get it to display all
of the text?
 
D

Dave Peterson

Left to its own devices, xl will show about 1000 characters in the cell.

But you can sprinkle a few alt-enters to force new lines within the cell and see
more.

(Remember that with merged cells, you'll have to adjust the rowheight
manually--autofit doesn't work.)
 
Top