LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Stray Doug
 
Posts: n/a
Default Print order of worksheets

I have a workbook with 10 worksheets in it. I have the dragged those
worksheets and arranged them in the workbook in a certain order (the tabs
from left to right) that is easy to use. However, this is not the order I
want to print them in. What's even stranger is that it doesn't print the
pages in the order they are in the workbook... it seems almost random
(although the order is consistent from print to print). Perhaps it was the
order the worksheets were created in.

Anyway, my question is, is there any way to (a) define the print order of
the worksheets, and (b) at least have the worksheets print in the same order
(left-to-right) that they appear in the workbook?

Thanks in advance!
 
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
Print all charts in a workbook (multiple worksheets) aewsaws Charts and Charting in Excel 4 May 12th 23 03:45 AM
How to set print range for a number of worksheets tntvk Excel Discussion (Misc queries) 5 December 12th 05 05:00 PM
Print mult worksheets to Adobe John Day Excel Discussion (Misc queries) 2 May 25th 05 03:54 PM
Print multiple worksheets on one page in Excel? TCTeach Excel Discussion (Misc queries) 1 May 3rd 05 05:01 AM
What is the simplest way to print multiple worksheets? substring Charts and Charting in Excel 1 April 21st 05 11:49 PM


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