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 |
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! |
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