Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default How can I print multiple tabs on one page?

I have created a workbook that collects date on seven pages and places in on
one. unfortunately the data must be submitted with the final totals and
since this is done often, I am looking for a way to save paper. I would like
to print multiple tabs/pages on one sheet of paper. I understand the date
will be reduced and thats ok. Can this be done and how?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 213
Default How can I print multiple tabs on one page?

... I would like to print multiple tabs/pages on one sheet of
paper. I understand the date will be reduced and thats ok. Can this
be done and how?


Here's one way.

1. Create a new blank sheet to collect what you want to print.

2. Go to an existing sheet, select what's to be printed, and
Edit Copy

3. Go to the "printing" sheet and use
Shift Edit Paste picture link
That is, while holding down the shift key, click the Edit menu and
there's the "Paste picture link" command.

4. Repeat 2 & 3 for each range of cells to be included.

There are some disadvantages of this approach. For example, you don't get
all the sheet headers and footers. If that's a requirement, a different
approach is needed. For example, I have Adobe PDF writer and it supports
multiple pages per sheet.
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
Can I print a list of names of all the tabs in xls on one page? sg Excel Discussion (Misc queries) 0 January 31st 07 08:13 PM
format rows to print at top for multiple tabs ESS Joan Setting up and Configuration of Excel 1 June 2nd 06 05:33 PM
How do I print a one page spreadsheet multiple time, each with its own page number? lhsallwasser Excel Discussion (Misc queries) 4 August 17th 05 03:00 PM
Print multiple tabs on one page excelQ Excel Discussion (Misc queries) 2 July 7th 05 02:38 PM
set the print area print multiple tabs veng Excel Discussion (Misc queries) 5 February 12th 05 07:01 PM


All times are GMT +1. The time now is 10:13 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"