Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 1
Default auto row height a cell with wrap text enabled and a lot of charact

How do I auto row height cells that have been wrap text enabled to work
correctly?
Scenario is: from a word document I copy and paste the text into an excel
2007 spreadsheet. The cells are wrap formatted and the column width narrowed,
manually, to enable them to fit to A4 paper. Some cells can have as many as
900 characters.
Problem is: the cells auto row height adjusts to the number of characters
but it is cropped and missing some text when print view or printed? I have
tried various formats of the cell alignment but still no good!

Is there a solution as to how I get around this?
Reply
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
Auto fit row height and Word Wrap Kayla Dickson Excel Worksheet Functions 1 January 14th 09 11:28 PM
How to control row height and text wrap in non-merged cell ??? akm Excel Discussion (Misc queries) 2 November 16th 07 02:01 AM
XL2003: "Auto row height" with Wrap Text driving me nuts sebt Excel Discussion (Misc queries) 0 May 1st 07 03:50 PM
Auto Text Wrap in a Cell Scott Douglas Excel Discussion (Misc queries) 1 July 5th 06 07:22 PM
Can word wrap and merged cells auto row height properly in Excel wchernock Excel Discussion (Misc queries) 1 May 30th 06 03:04 PM


All times are GMT +1. The time now is 01:59 PM.

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"