Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Chris N
 
Posts: n/a
Default Print multiple pages per Sheet in Excel 2003

I have a spreadsheet with 12 rows that goes for many columns ( with formulas).
Is there a way to print this where three pages are on each piece of paper?
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

How about inserting a new worksheet, then copying and pasting (as values) to
that new sheet. Then print that "helper" worksheet.

If you have to do this lots, this may be worth the trouble.

Insert a new sheet.
select a nice range on the original sheet
Edit|copy
go to the new worksheet
shift-edit|Paste picture link

Repeat so that you have pictures of the ranges so it prints the way you want.
Then print this helper worksheet.

The nice thing about the picture link is you can change the cells in the
original worksheet and the pictures will be updated.



Chris N wrote:

I have a spreadsheet with 12 rows that goes for many columns ( with formulas).
Is there a way to print this where three pages are on each piece of paper?


--

Dave Peterson
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
Getting Excel Data from One Sheet to Another.... Robin Excel Discussion (Misc queries) 2 April 21st 05 01:15 PM
Excel 2003 Referencing multiple workbooks via single variable BBohannon Excel Worksheet Functions 0 April 20th 05 08:32 PM
Print multiple excel charts within one sheet to fit to a page lik. lal Excel Discussion (Misc queries) 1 February 18th 05 09:47 PM
How do I print grayscale font in Excel 2003? NKT Excel Discussion (Misc queries) 0 January 26th 05 04:51 PM
sharing/using/saving Excel 2002 files in Excel 2003 maze2009 Excel Discussion (Misc queries) 0 January 20th 05 07:27 PM


All times are GMT +1. The time now is 11:28 AM.

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"