LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 211
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2007 high cpu usage, format cell, wrap text Michael S. Wall Excel Discussion (Misc queries) 9 October 16th 09 07:34 PM
2007 Excel: text in cell becomes hidden when formatted to wrap tex Ross Excel Discussion (Misc queries) 0 June 6th 08 11:46 PM
Wrap text in header section Excel 2007 Ted M H Excel Discussion (Misc queries) 2 November 10th 07 06:36 PM
Wrap Text in 2007 vs 2003 Chris E. Excel Discussion (Misc queries) 1 September 18th 07 03:59 PM
Microsoft Query sometimes adds trailing spaces to fields No Name Excel Discussion (Misc queries) 1 June 4th 07 03:17 PM


All times are GMT +1. The time now is 05:47 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"