Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Setting rows to autofit wrapping text in a cell
I have a spreadsheet with 5 columns and 6 rows. Each cell will contain text
of an indeterminate length. I would like the rows to autofit the text but even though I've selected that in format when I test a cell to see if the row will automatically increase in height to accommodate the text the row does not adjust and all of the text is not seen. Is there a way to fix this? Thanks -- John |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Setting rows to autofit wrapping text in a cell
A few things to look for.
The cells must be set to Wrap Text and rows set to Autofit. BUT.........if any cells are merged row autofit will not work and VBA must be employed. Also. if the number of characters in the cell exceeds 1024 you will not see characters past that point even with wrap text and row autofit. In the latter case, add an in-cell linefeed every 100 or so characters using Alt + Enter Gord Dibben MS Excel MVP On Thu, 7 Jan 2010 14:41:02 -0800, John wrote: I have a spreadsheet with 5 columns and 6 rows. Each cell will contain text of an indeterminate length. I would like the rows to autofit the text but even though I've selected that in format when I test a cell to see if the row will automatically increase in height to accommodate the text the row does not adjust and all of the text is not seen. Is there a way to fix this? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Wrapping text in cell. | Excel Discussion (Misc queries) | |||
Text Wrapping in a Cell | Excel Discussion (Misc queries) | |||
Text stops wrapping in cell. Tried AutoFit. | Excel Worksheet Functions | |||
Text not wrapping within a cell | Excel Discussion (Misc queries) | |||
Automatically set rows with cells with text wrapping to change hei | Excel Discussion (Misc queries) |