Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
when I wrap text in excel it disappears? autofit does not work
When I wrap text in excel it disappears. Row autofit and column autofit do
not work. the wording is in the it is just not visable. help! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
when I wrap text in excel it disappears? autofit does not work
Did you try doing a manual row expansion? Sometimes the autofit doesn't work
for wrapped text. I haven't bothered to identify under which particular circumstances. "Gareth" wrote: When I wrap text in excel it disappears. Row autofit and column autofit do not work. the wording is in the it is just not visable. help! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
when I wrap text in excel it disappears? autofit does not work
Autofit does not work on wrapped text in "merged" cells.
You can resize manually or via Macro. Jim Rech has written code for this. http://groups.google.com/groups?thre...%40tkmsftngp05 Also revised code for special cases. http://snipurl.com/dfsm The best cure is DON"T USE MERGED CELLS. They cause no end of problems with copying, pasting, sorting, filtering. Gord Dibben Excel MVP On Wed, 7 Dec 2005 07:16:05 -0800, "blackmot" wrote: Did you try doing a manual row expansion? Sometimes the autofit doesn't work for wrapped text. I haven't bothered to identify under which particular circumstances. "Gareth" wrote: When I wrap text in excel it disappears. Row autofit and column autofit do not work. the wording is in the it is just not visable. help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I use word wrap in a merged cell in excel 2000? | Excel Discussion (Misc queries) | |||
cell won't wrap text | Excel Discussion (Misc queries) | |||
Wrap text ceases to function in Excel if cell exceeds 9 lines | Excel Worksheet Functions | |||
Autofitting a row | Excel Discussion (Misc queries) | |||
How do I "Wrap Text" & "Autofit" within Merged Cells in Excel? | Excel Worksheet Functions |