View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
vrm7620 vrm7620 is offline
external usenet poster
 
Posts: 2
Default 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!