ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   print excel spreadsheet splitting cell contents on multiple pages (https://www.excelbanter.com/excel-discussion-misc-queries/116416-print-excel-spreadsheet-splitting-cell-contents-multiple-pages.html)

vrm7620

print excel spreadsheet splitting cell contents on multiple pages
 
How does one print an Excel spreadsheet splitting the contents of a long cell
over multiple pages, i.e. one particular cell on the spreadsheet is lenghthy
and rather than keep all the text in that cell on one page, I need it to
print the contents of the cell over two pages without physically splitting
the cell itself

EGNX Flyer

print excel spreadsheet splitting cell contents on multiple pages
 
have you tried the 'Scale To Fit' function on Page Setup? Here you can
set the entire worksheet, or the desired print area (i.e. those cells
required for the worksheets contents ) to fit 1, 2, or more pages width
and/or height.

Go to: 'File' 'Page Setup' 'Page' 'Scaling'

hope this helps!


vrm7620

print excel spreadsheet splitting cell contents on multiple pa
 
I already tried that method. The problem is I have multiple pages worth of
long cells and Scale to Fit will not split the cell contents. I still end up
with ragged page ends which is what I am trying to avoid.

"EGNX Flyer" wrote:

have you tried the 'Scale To Fit' function on Page Setup? Here you can
set the entire worksheet, or the desired print area (i.e. those cells
required for the worksheets contents ) to fit 1, 2, or more pages width
and/or height.

Go to: 'File' 'Page Setup' 'Page' 'Scaling'

hope this helps!




All times are GMT +1. The time now is 11:18 AM.

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