Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I get cell data in multiple Excel files into one summary fi | Excel Worksheet Functions | |||
How do I remove unwanted banner pages in excel workbook print | Excel Discussion (Misc queries) | |||
How do I remove multiple hyperlinks in the same cell (Excel)? | Charts and Charting in Excel | |||
Excel printing problem - won't print cell under a "fill effect" bo | Excel Discussion (Misc queries) | |||
Splitting multiple cell contents containing values at end | Excel Worksheet Functions |