ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Printing Entire Contents of Cell (https://www.excelbanter.com/excel-discussion-misc-queries/43271-printing-entire-contents-cell.html)

waterdawg

Printing Entire Contents of Cell
 

A couple columns in a spreadsheet have lengthy text with the cell
formatting set to wrap. Not all of the text displays when viewing the
screen, but when clicking on the cell to edit, the contents are there.
The real probem is that when printing, the contents of some of these
cells are truncated. How do I get the entire contents to print?


--
waterdawg
------------------------------------------------------------------------
waterdawg's Profile: http://www.excelforum.com/member.php...o&userid=26835
View this thread: http://www.excelforum.com/showthread...hreadid=400845


Dave Peterson

Try adding alt-enters every 80-100 characters.

You may have to adjust the rowheight manually, though.

waterdawg wrote:

A couple columns in a spreadsheet have lengthy text with the cell
formatting set to wrap. Not all of the text displays when viewing the
screen, but when clicking on the cell to edit, the contents are there.
The real probem is that when printing, the contents of some of these
cells are truncated. How do I get the entire contents to print?

--
waterdawg
------------------------------------------------------------------------
waterdawg's Profile: http://www.excelforum.com/member.php...o&userid=26835
View this thread: http://www.excelforum.com/showthread...hreadid=400845


--

Dave Peterson


All times are GMT +1. The time now is 12:39 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com