Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5
Default 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   Report Post  
Posted to microsoft.public.excel.misc
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!


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I get cell data in multiple Excel files into one summary fi 78degreesinHI Excel Worksheet Functions 4 August 29th 06 02:05 AM
How do I remove unwanted banner pages in excel workbook print Johan Excel Discussion (Misc queries) 1 January 31st 06 03:37 PM
How do I remove multiple hyperlinks in the same cell (Excel)? Hyper Charts and Charting in Excel 0 January 16th 06 06:24 PM
Excel printing problem - won't print cell under a "fill effect" bo dmotika Excel Discussion (Misc queries) 0 May 26th 05 04:38 PM
Splitting multiple cell contents containing values at end Syns Excel Worksheet Functions 2 May 24th 05 04:24 PM


All times are GMT +1. The time now is 08:16 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"