| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I size merged cells to fit the needed rows of text?
I've got data that can contain a long text string for one field. I currently
merge 6 cells across and set the rowheight to 6 times the normal row height, and enable text wrapping. Sometimes this is too much space, other times it's not enough. Fonts unfortunately don't space characters uniformly, so I can't do it based on text length. Is there a way to do this based on how many breaks Excel puts in when wrapping text, or another method? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| merged cells into one text cell, size varies dependant on text dat | Excel Discussion (Misc queries) | |||
| identically size merged cells for sorting rows | Excel Discussion (Misc queries) | |||
| How can I Excel to re-size when wrapping text in merged cells | Excel Discussion (Misc queries) | |||
| Rows with merged cells are not adjusting even w/ Wrap Text and au. | Excel Discussion (Misc queries) | |||
| Help needed with merged cells | Excel Programming | |||
Threaded Mode
