Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 273
Default Bottom of cells are truncated when printed after using auto row he

How can I prevent the bottom line of text cell from being trucated during
printing after using auto row height. I have tried changing word wrap and
other cell alignments. I am running Excel 2003, but have had this problem
with previous versions. It would be great if I could add a space at the
bottom of the cell when printed.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default Bottom of cells are truncated when printed after using auto row he

How much text is in the cells?

If over 1024 characters, Excel will truncate after approximately 1024.

To get more, Alt + ENTER every 80-100 characters.

If less than 1024 characters just add and Alt + ENTER after last character.

This gives a linefeed and should produce the space.


Gord Dibben MS Excel MVP

On Fri, 7 Dec 2007 09:49:01 -0800, Gary wrote:

How can I prevent the bottom line of text cell from being trucated during
printing after using auto row height. I have tried changing word wrap and
other cell alignments. I am running Excel 2003, but have had this problem
with previous versions. It would be great if I could add a space at the
bottom of the cell when printed.


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
How can I display totals on the bottom of a printed page in Excel. ECC Partner Excel Discussion (Misc queries) 1 June 25th 07 08:01 PM
Auto generating a printed date Tbone New Users to Excel 2 February 17th 06 10:14 PM
Last letter in Excel cell is truncated when printed. Jeff Larkin Excel Discussion (Misc queries) 1 October 17th 05 07:25 PM
How do I remove the auto border from my printed pages in Excel GE Excel Discussion (Misc queries) 1 August 12th 05 01:37 AM
Textbox's truncated once printed (Excel 2000) Robert Pemberton Excel Discussion (Misc queries) 2 January 14th 05 02:19 AM


All times are GMT +1. The time now is 04:37 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"