Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #11   Report Post  
Old August 3rd 12, 06:47 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2012
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?


Save the workbook as a PDF then print as Double sided from the PDF document.

  #12   Report Post  
Old June 5th 13, 08:16 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2013
Posts: 1
Default Can you print multiple worksheets double sided?

The best way to print double side is just export the workbook to pdf and this will make it easy to print double side.
Step by step instructions
1- Open the workbook
2- Select all sheets.(go to first sheet then press shift and while holding shift go to last sheet and click on it. this results in selection of all sheet)
3- File Menu and save as file .pdf
4- Once this created open pdf and print it as you like.

Regards
  #13   Report Post  
Old January 31st 15, 12:25 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2015
Posts: 1
Default Can you print multiple worksheets double sided?

Thank you so much for your assistance
  #14   Report Post  
Old April 8th 17, 04:27 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2017
Posts: 1
Default Can you print multiple worksheets double sided?

On Tuesday, January 5, 2010 at 4:42:39 PM UTC-6, Barb wrote:
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


excellent! thanks
  #15   Report Post  
Old April 8th 17, 05:09 PM
Banned
 
First recorded activity by ExcelBanter: Apr 2017
Posts: 20
Default

Quote:
Originally Posted by Publisher Lyn View Post
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?
Cảm ơn bạn vì b*i viết rất bổ *ch v* thú vị


  #16   Report Post  
Old April 9th 17, 01:08 AM
Banned
 
First recorded activity by ExcelBanter: Apr 2017
Posts: 20
Default

Quote:
Originally Posted by Publisher Lyn View Post
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?
Cảm ơn bạn vì b*i viết rất bổ *ch v* thú vị
  #17   Report Post  
Old April 9th 17, 03:09 AM
Banned
 
First recorded activity by ExcelBanter: Apr 2017
Posts: 20
Default

Quote:
Originally Posted by Publisher Lyn View Post
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?
Cảm ơn bạn vì b*i viết rất bổ *ch v* thú vị


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
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 11:31 AM
Multiple Worksheets and Print Merge function pfe Excel Discussion (Misc queries) 2 December 3rd 04 12:23 AM
Enable Double sided printing contiuously when printing multiple s. Lee Excel Discussion (Misc queries) 1 November 27th 04 02:58 AM


All times are GMT +1. The time now is 02:54 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017