Printing multiple worksheets from one workbook

G

Guest

I have a number of worrksheets in one workbook, I want to print them in the
order they appear on the screen, reading left to right. But it seems that
regardless of how I order the tabs on screen, if I select them all going left
to right they print in a specific order which isn't the one I need.

How can I control the order that work sheets are printed without having to
print each one individually?

I am using Microsoft Office Professional Plus 2007
 
G

Guest

One simple way would be to record a macro which has them print in the order
you want and then just execute the macro next time. Keep in mind the macro
would be static so if you added more sheets, you'd need to modify or
re-record the macro.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
All sheets in workbook have same rows to repeat at top 1
MULTIPLE PRINT AREA 3
combine multiple spreadsheets into one workbook 1
List of All Workbook's Worksheets 4
why do print range erase in Excel when import data from access 1
Set the print order of worksheets when printing entire workbook 2
summing the same cell in multiple workbooks 2

Top