Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 Adds Spaces when Wrap Text is Used
Hello,
I have an excel 2007 workbook with over 4000 rows of information. In certain rows I use the Wrap Text feature since the entry in the cell is extremely long. To view the entire entry I double click the row so that I can auto fit the information, however, when i do that I get a lot of space at the top of that cell. When I copy and paste that same text in a new workbook and use the Wrap Text feature it does not do that. I clear the format from the cell and entire row but I still get the added space when I wrap text. I have to manually adjust the Height so that I dont see extra space at the top of the cell. I also played with the Vertical Alighment of the cell and if I choose top, bottom, or center I still end up with a significant amount of space in the cell. Has anyone experience this? is there a fix for this? It does not seem to happen in new workbooks. Any Help/Suggestions would be greatly appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 high cpu usage, format cell, wrap text | Excel Discussion (Misc queries) | |||
2007 Excel: text in cell becomes hidden when formatted to wrap tex | Excel Discussion (Misc queries) | |||
Wrap text in header section Excel 2007 | Excel Discussion (Misc queries) | |||
Wrap Text in 2007 vs 2003 | Excel Discussion (Misc queries) | |||
Microsoft Query sometimes adds trailing spaces to fields | Excel Discussion (Misc queries) |