A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » Excel Discussion (Misc queries)
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Can you print multiple worksheets double sided?



 
 
Thread Tools Display Modes
  #1  
Old October 12th 06, 04:22 PM posted to microsoft.public.excel.misc
Publisher Lyn
external usenet poster
 
Posts: 1
Default Can you print multiple worksheets double sided?

We publish an annual publication of detailed tables. Each section of the book
is created in a single Excel workbook - each page of the book is one Excel
sheet. We have tried selecting all sheets and formatting the printer to print
double sided, but each sheet still prints on a separate page. Also, when
trying to number the pages, you can select all sheets, select the first
number, but the same number shows up on all sheets. Is this a limitation of
Excel?
Ads
  #2  
Old December 6th 06, 10:31 AM posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default Can you print multiple worksheets double sided?


Publisher Lyn wrote:
> We publish an annual publication of detailed tables. Each section of the book
> is created in a single Excel workbook - each page of the book is one Excel
> sheet. We have tried selecting all sheets and formatting the printer to print
> double sided, but each sheet still prints on a separate page. Also, when
> trying to number the pages, you can select all sheets, select the first
> number, but the same number shows up on all sheets. Is this a limitation of
> Excel?


I think... what you need to do is set the print area on each sheet of
the work book so that you have one page on each sheet, do this for each
sheet. Then... this is the annoying part and the only way I have
managed to make this work. Click on each sheet then click File>Print.
Go into the properties and click double sided as I'm sure you have
already done... then instead if clicking ok to start printing click
close. Then repeat this process for each individual sheet by tabbing
accross to each one clicking print and then changing the property. Once
you have done this for all sheets go back to the first sheet, click
print then select entire workbook and then press ok. I believe this
should then print each sheet back to back accross the entire workbook.
At least I have got it to do this anyway after much faffing around!

  #3  
Old December 6th 06, 10:32 AM posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default Can you print multiple worksheets double sided?


Publisher Lyn wrote:
> We publish an annual publication of detailed tables. Each section of the book
> is created in a single Excel workbook - each page of the book is one Excel
> sheet. We have tried selecting all sheets and formatting the printer to print
> double sided, but each sheet still prints on a separate page. Also, when
> trying to number the pages, you can select all sheets, select the first
> number, but the same number shows up on all sheets. Is this a limitation of
> Excel?


I think... what you need to do is set the print area on each sheet of
the work book so that you have one page on each sheet, do this for each
sheet. Then... this is the annoying part and the only way I have
managed to make this work. Click on each sheet then click File>Print.
Go into the properties and click double sided as I'm sure you have
already done... then instead if clicking ok to start printing click
close. Then repeat this process for each individual sheet by tabbing
accross to each one clicking print and then changing the property. Once
you have done this for all sheets go back to the first sheet, click
print then select entire workbook and then press ok. I believe this
should then print each sheet back to back accross the entire workbook.
At least I have got it to do this anyway after much faffing around!

  #4  
Old December 6th 06, 10:34 AM posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default Can you print multiple worksheets double sided?


Publisher Lyn wrote:
> We publish an annual publication of detailed tables. Each section of the book
> is created in a single Excel workbook - each page of the book is one Excel
> sheet. We have tried selecting all sheets and formatting the printer to print
> double sided, but each sheet still prints on a separate page. Also, when
> trying to number the pages, you can select all sheets, select the first
> number, but the same number shows up on all sheets. Is this a limitation of
> Excel?


I think... what you need to do is set the print area on each sheet of
the work book so that you have one page on each sheet, do this for each
sheet. Then... this is the annoying part and the only way I have
managed to make this work. Click on each sheet then click File>Print.
Go into the properties and click double sided as I'm sure you have
already done... then instead if clicking ok to start printing click
close. Then repeat this process for each individual sheet by tabbing
accross to each one clicking print and then changing the property. Once
you have done this for all sheets go back to the first sheet, click
print then select entire workbook and then press ok. I believe this
should then print each sheet back to back accross the entire workbook.
At least I have got it to do this anyway after much faffing around!

  #5  
Old December 7th 06, 12:22 AM posted to microsoft.public.excel.misc
MyVeryOwnSelf
external usenet poster
 
Posts: 213
Default Can you print multiple worksheets double sided?

> We publish an annual publication of detailed tables. Each section of
> the book is created in a single Excel workbook - each page of the book
> is one Excel sheet. We have tried selecting all sheets and formatting
> the printer to print double sided, but each sheet still prints on a
> separate page. Also, when trying to number the pages, you can select
> all sheets, select the first number, but the same number shows up on
> all sheets. Is this a limitation of Excel?



For the page numbering part, you might try this after selecting all sheets:
File > Page setup > Page
and put "Auto" (without quotes) in the "First page number" field.

Then print the "Entire workbook" at once.

For the double-sided part, I’ve done it this way. It’s not elegant,
admittedly.

Print the workbook to the “Microsoft Office Document Image Writer.” This
opens several “Microsoft Office Document Imaging” windows.

Next, combine the worksheets into a single document. To do this, notice
that each of the “Imaging” windows has a left pane with thumbnails of the
page(s). Using right-click, “Copy” one or more thumbnails from the left
pane of one window and “Paste” it into the left pane of another. (Drag-and-
drop works.) Repeating this, the entire document can be merged into a
single window. Finally, print from that window.

If you do this sort of thing a lot, you might want to look at
http://fineprint.com/products/fineprint/index.html
for third-party software that (among many other features) can combine
several print jobs into one, with fewer steps than using Image Writer.
  #6  
Old April 21st 08, 11:02 PM posted to microsoft.public.excel.misc
rviviana
external usenet poster
 
Posts: 1
Default Can you print multiple worksheets double sided?

I am trying to pick the print area to be the same on all sheets and I am
trying to avoid going into each sheet because I have 50 sheets. There has to
be a way to save time.
Rosemary

" wrote:

>
> Publisher Lyn wrote:
> > We publish an annual publication of detailed tables. Each section of the book
> > is created in a single Excel workbook - each page of the book is one Excel
> > sheet. We have tried selecting all sheets and formatting the printer to print
> > double sided, but each sheet still prints on a separate page. Also, when
> > trying to number the pages, you can select all sheets, select the first
> > number, but the same number shows up on all sheets. Is this a limitation of
> > Excel?

>
> I think... what you need to do is set the print area on each sheet of
> the work book so that you have one page on each sheet, do this for each
> sheet. Then... this is the annoying part and the only way I have
> managed to make this work. Click on each sheet then click File>Print.
> Go into the properties and click double sided as I'm sure you have
> already done... then instead if clicking ok to start printing click
> close. Then repeat this process for each individual sheet by tabbing
> accross to each one clicking print and then changing the property. Once
> you have done this for all sheets go back to the first sheet, click
> print then select entire workbook and then press ok. I believe this
> should then print each sheet back to back accross the entire workbook.
> At least I have got it to do this anyway after much faffing around!
>
>

  #7  
Old April 22nd 08, 04:39 PM posted to microsoft.public.excel.misc
Gord Dibben
external usenet poster
 
Posts: 22,909
Default Can you print multiple worksheets double sided?

Using VBA code you can set the same print range and rows to repeat at top on
each sheet in grouped sheets.

For anyone interested in the code see this google search result with Dave
Peterson and myself posting. The print area code is from Bob Flanagan.

http://snipurl.com/106kz


Gord Dibben MS Excel MVP



On Mon, 21 Apr 2008 15:02:12 -0700, rviviana
> wrote:

>I am trying to pick the print area to be the same on all sheets and I am
>trying to avoid going into each sheet because I have 50 sheets. There has to
>be a way to save time.
>Rosemary


  #8  
Old December 15th 09, 04:30 AM posted to microsoft.public.excel.misc
Queenie Chong
external usenet poster
 
Posts: 2
Default Can you print multiple worksheets double sided?

I'm also finding any long-term solution for this problem.
You may use this method to print as one file on the printing dialogue:

1. Select "Page(s) From __ to __"
2. Select "Active sheet(s)"
3. Press "OK"

"Publisher Lyn" wrote:

> We publish an annual publication of detailed tables. Each section of the book
> is created in a single Excel workbook - each page of the book is one Excel
> sheet. We have tried selecting all sheets and formatting the printer to print
> double sided, but each sheet still prints on a separate page. Also, when
> trying to number the pages, you can select all sheets, select the first
> number, but the same number shows up on all sheets. Is this a limitation of
> Excel?

  #9  
Old January 5th 10, 10:42 PM posted to microsoft.public.excel.misc
Barb[_3_]
external usenet poster
 
Posts: 1
Default Can you print multiple worksheets double sided?

Here is how to get multiple worksheets in one workbook printed with
true double sided printing (to prevent each worksheet from starting a
new page):
* Open each worksheet that you are going to print individually
* Go to the File / Page Setup menu and click on the Print... button
(you are not going to print at this time, but you need to set each
of the worksheets to the double sided option)
* When the print window comes up, click on the Properties... button
* Under the 2 sided print, change the drop down menu to 2 sided
printing
* Click on the OK button
* This takes you back to the print window - DO NOT click on the OK
button (it will print the sheet) - instead click on the Close button

You have now reset that individual worksheet to double sided printing.
You need to do that for every other individual worksheet that you
intend to print from the workbook.

Then when you are ready to print, click on the first tab of the
worksheet you want to print.
Then hold down the control key (Ctrl) and click on each other
worksheet tab that you want to print
(they will all change from gray to white as you select them to show
you which ones you have picked)
Then go to the File / Print menu, make sure that under "Print What"
the button for Active Sheets is selected.
Then go to the Properties... button and make sure that it is set for
double sided printing.
Then print a copy.

Hopefully you will now have a true double sided copy of the multiple
worksheets in your Excel workbook without each tab starting a new
page.

One note of caution...
When you have multiple worksheets selected in this manner, if you make
changes to the page setup (margins, etc.) the changes will be applied
to every once of the worksheets that are in the selected group. It is
easy to forget that they are all selected and to change what you think
is just the worksheet that is showing, and mistakenly change all of
the others. Also, if you save with multiple worksheets selected, when
you open the workbook again, they will still be selected. Learned
this one the hard way... :-(

Barb
  #10  
Old August 3rd 12, 06:45 PM posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Can you print multiple worksheets double sided?

On Thursday, October 12, 2006 11:22:01 AM UTC-4, Publisher Lyn wrote:
> We publish an annual publication of detailed tables. Each section of the book
> is created in a single Excel workbook - each page of the book is one Excel
> sheet. We have tried selecting all sheets and formatting the printer to print
> double sided, but each sheet still prints on a separate page. Also, when
> trying to number the pages, you can select all sheets, select the first
> number, but the same number shows up on all sheets. Is this a limitation of
> Excel?


The easiest way I have found to print multiple tabs from Excel is to save the entire workbook as a PDF. Be sure all of your tabs are selected. Once it is a PDF - print normally.
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Functions across multiple worksheets starlight Excel Worksheet Functions 0 August 10th 05 05:10 PM
Printing Multiple Worksheets Linda Excel Discussion (Misc queries) 1 August 8th 05 05:12 PM
Print all charts in a workbook (multiple worksheets) aewsaws Charts and Charting in Excel 3 December 31st 04 10:31 AM
Multiple Worksheets and Print Merge function pfe Excel Discussion (Misc queries) 2 December 2nd 04 11:23 PM
Enable Double sided printing contiuously when printing multiple s. Lee Excel Discussion (Misc queries) 1 November 27th 04 01:58 AM


All times are GMT +1. The time now is 02:50 PM.


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