Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text wrap in merged cells
I have a series of cells that are merged; when I type text into these line
items, the text wraps, but the cell will not expand to show the wrap. I have clicked on the row reformat button, which does nothing. Can't these cells expand if merged? It would seem ridiculous that this would not be available. Thanks, |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text wrap in merged cells
The general advice on merge is either "don't" or "caveat emptor". It is not
one of Excel finer features! You must manually adjust the row height when using merge cells: (1) you can pull the row separator down or (2) right click the row indicator and in the Row Height... dialog type a number about twice the value of non-merged rows (for two lines of text) best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "LC" wrote in message ... I have a series of cells that are merged; when I type text into these line items, the text wraps, but the cell will not expand to show the wrap. I have clicked on the row reformat button, which does nothing. Can't these cells expand if merged? It would seem ridiculous that this would not be available. Thanks, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Wrap text in merged cells VBA | Excel Discussion (Misc queries) | |||
Merged cells/wrap text | Excel Discussion (Misc queries) | |||
merged cells and wrap text | Excel Discussion (Misc queries) | |||
Wrap text in merged cells | Excel Worksheet Functions | |||
text wrap w/ merged cells | Excel Discussion (Misc queries) |