print excel spreadsheet splitting cell contents on multiple pages

V

vrm7620

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
 
E

EGNX Flyer

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

vrm7620

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top