Email:      Pass:    Pass?
Close Window   
Free Ebook
Get Your Free Excel
Our Top 15 Excel Tutorials
Instant Access!

Subscribe for Free Excel tips & more!

Free Excel Forum

Changing The Page Setup For Multiple Worksheets In A Workbook

Forum Register
Search Excel Forum Posts, Tutorials, Macros, Tips, and More

I am trying to change the page set up setiings to fit to 1 page for 56
worksheets within a workbook. Is there an easy way to do this? Can I buy a
program add in to do this for me?

View Answers     

Similar Excel Tutorials

Scale Data for Printing in Excel - Fit more onto a Printed Page
This tip shows you how to fit more Excel data onto a page for printing. This does not change the size, shape, or lo ...
Set a Photo/Image as an Excel Worksheet Background
One of the really cool formatting features of Excel is that you can actually set a picture from your computer as t ...
Loop through All Worksheets in Excel using VBA and Macros
Ill show you how to loop through all of the worksheets in a workbook in Excel using VBA and Macros. This only take ...
How to use Vlookup Across Multiple Worksheets in Excel
This tutorial shows you how to use the Vlookup function across multiple worksheets within Excel.  This means that y ...

Helpful Excel Macros

Print Preview Screen Display for The Current or Selected Worksheets in Excel
- This free Excel macro allows you to display the print preview screen or window for the current or selected worksheets in
Print Specific Pages in Excel
- This free Excel macro allows you to print a pre-specified selection of pages from Excel. This means you can print 2 pag
Complete Guide to Printing in Excel Macros - PrintOut Method in Excel
- This free Excel macro illustrates all of the possible parameters and arguments that you can include in the PrintOut Meth
Combine Multiple Workbooks into One
- This macro for Microsoft Excel allows you to combine multiple workbooks and worksheets into one new workbook and workshe
Basic Web Query in Excel - Import Data from the Web into Excel
- Import data from the web into Excel with this macro. This is a basic web query macro that will import data from any web

Similar Topics

Hello -

My question is a relatively simple one, though the answer has eluded
me thus far. I know how to perform changes to Page Setup on a
worksheet-by-worksheet basis (File -> Page Setup) but I have to think
there's a way to do this across an entire workbook in one move. Does
anyone know of one?

On a more general basis, what I am trying to accomplish (through
whatever means neccesary) is set the entire workbook to print one page
per worksheet. Again, I would think this would be easy to do rather
than go page by page (a tedious time waster when the workbook has 60+
worksheets) so any help is greatly appreciated.

Thanks -


Is there a macro I can write that will just change the footers on my worksheets and leave everything else intact? I need to change the footers on all the worksheets in my workbook, so that they all look the same (file name, worksheet name, and date). But if I make all the worksheets active, and then just modify the first worksheet, all of the other "page setup" information is also copied to the other open worksheets. Some of the worksheets need to be portrait, others landscape, some print on one page vs multiple pages, etc.

I have over a hundred worksheets in my workbook. I have to change each worksheet to 69%, legal size, change all margins to 0 and set to landscape. Is there a formula or something that you can use so that you can set up all worksheets at once to save that page set up?

Hi All,

I have a workbook, which has numerous worksheets. On each worksheet is a screen print, not excel data but a CTRL+print Screen of another system. All are the same size. I want to print the whole workbook, each worksheet on one page, but at the moment the only way I know how to do this is to go into each worksheet and go File>Page Setup>Fit to 1 page tall by 1 page wide etc... is there a way to apply this change to the whole workbook, without going through each worksheet one by one??


I'm working with a user who has about 32 worksheets in an excel workbook. She
doesn't want the first page numbered and wants the next three pages to be
"index" numbered, followed by the "body" to start at page 1. Every time I
select multiple worksheets and go to File -> Page Setup -> Headers & Footers,
and I create a footer for page number, it's showing up as page 33, 32, and 31
(in that order). I'm confused. Can anyone help me with this task?
Sarah M.

If I have 10 worksheets in my file and I select all of them and then do a print preview, I can see each page - one at a time. If while in print preview I select the Setup... button, I can change the page setup parameters for just the page I'm viewing at that moment. Is there any way to make a mass change so ALL worksheets in a file get the same Page setup options?

Is there a way to add page numbers to all worksheets in a workbook without changing all of the other page setup formats?

I have a workbook with many worksheets (about 30). Some of the worksheets are formatted to print on two pages, others are only 1 page long. I want to number all of the pages. I am selecting all worksheets and through the page setup screen, I am checking off on the page # footer.

Instead of numbering all of the pages sequentially, Excel is numbering them 1,2,1,1,2,1,2,1,1 etc. instead of 1,2,3,4,5,6,7,8 etc. Can you help?

Using Excell 2011, I have developed a workbook with several worksheets.
For printing purposes, the worksheets have different respective page setup orientations (landscape or portrait) and scaling (%).
When I save and close my workbook, then open it again later, the setup page for each worksheet systematically reverts to what seems to be a default value (scaling of 100%).
What would be the way to safe different pages settings in a workbook?
Thanks a lot

I've been doing a lot of searching to find out how to achieve the sequential numbering across multible worksheets, untill I finally found a post with a solution to the issue, which is to select the sheets one wants to print, and then in the page setup, adding "Page &[Page] of &[Pages]" (I'm not a 100% sure if that what they're called in english, as I'm using a Danish version) and then look at the print preview.
The outputs on the footers a
Page 1 of 5 (sheet 1)
Page 1 of 5 (sheet 2)
Page 2 of 5 (sheet 2)
Page 1 of 5 (sheet 3)
Page 1 of 5 (sheet 4)
Also, when attempting to offset the page-count in the page setup for a single sheet I get e.g.:
Page 2 of 3
Page 3 of 3
Page 4 of 3

Does anyone else have these problems?
Am I doing something wrong? And are there any workarounds or VBA solutions to these issues?

Hi All,
I have a single workbook containing 3 worksheets, each worksheet contains approx 5 to 10 pages but this varies.

Worksheet 1 contains barter invoices
Worksheet 2 contains quotes
Worksheet 3 contians contracts

I need to print all 3 of the above to one pdf file but with page numbers assigned to just the final worksheet.

If I try adding a footer with page numbers to the final worksheet only I achieve half the goal in so much as there are no page numbers on worksheets 1 and 2 but the page numbers on worksheet 3 read

Page 21 of 30
Page 22 of 30

When I need them to read

Page 1 of 10
Page 2 of 10

And if I switch worksheet 3 with worksheet one I still end up with...

Page 1 of 30
Page 2 of 30

Any ideas on how I can get the page numbering to focus on one worksheet only whilst printing multiple worksheets?

Greetings all,
I am trying to add the values of one cell from three different worksheets (all in the same workbook) and display it in a cell on the first worksheet. Here is my formula:

=SUM(('[Page1]Page 1'!F35)+('[Page2]Page 2'!F43)+('[Page3]Page 3'!F33))

I want to add the values of:
Cell F35 on Page 1 (Page 1 is worksheet 1)
Cell F43 on Page 2 (page 2 is worksheet 2)
Cell F33 on Page 3 (page 3 is worksheet 3)

Now this worked fine when I initially made the formula. But when I go back and change values in the worksheets, I expect to see the total change in this cell and it does not. It's like it's not auto updating, sort of like it calculated it one time (when I made the formula) but is now static and doesn't refresh when values are changed.
Any help would be greatly appreciated.
Thank you

Hi everyone,

when I try to do "page set-up" after selecting multiple worksheets, the all page settings apply to all worksheets selected. For example, all the worksheets get the same header and footer

I only want to change one factor of the page settings (for example, just scaling) for mutiple worksheets at once, how should I do it?

Some of my excel files have more than 20 worksheets and I really want to know how to do this.


This may be a simple question, I was sent a work book with 20+ worksheets (tabs), it appears that each sheet is formatted different (landscape / portiait) I need to print each page, so is there a way I can formatt all tabs within the workbook at one time. I eed each page to be setup as landscape?

I have an excel sheet with about 10 worksheets. For every report report make, I will have different number of worksheets. So, I have to change the page number manually everytime for those worksheets in which page numbers don't match. I delete those worksheets I don't need. However, my worksheets are in sequential order from left to right. I don't need page numbers for first two worksheets. So the third worksheet will be page number 1.

Is there any way that Excel can automatically do it for me. Please help.

I need to insert a header on each worksheet in my workbook with out changing the page layouts. I know you can group the worksheets together, then under page setup insert a header, but that conforms each worksheet to the same page layout, i.e. portrait or landscape. My workbook has both portrait and landscape worksheets, how can I place a header on each worksheet without changing the page layouts?

I am working on an excel workbook for a program at our school. I need to set page breaks between different sets of data in my workbook. I manually set all my horizontal page breaks fine, but my vertical page breaks are giving me trouble. The program imposed a vertical page break on my workbook that cuts off 2 columns and puts them on a separate page, but there is plenty of room on the page I want them to be on (at least 1/2 of the page is blank). I have tried to move and delete this page break, but neither works. Any suggestions?

I want to have one master page in a workbook & have it update multiple pages if I make changes to the master page. How can I do that?

My purpose is that I use the page over & over in separate worksheets but hide different columns to print reports for various reasons but I only want to update one page.

I am trying to prepare multiple worksheets in a large workbook for printing. I select all the worksheets, then edit the headers and footers through the page layout. Many of the worksheets look fine, but some still have the wrong date, or others have old header information in them. How can I clear all headers and footers without going into page layout for each individual page?

I have an Excel 2010 file with many worksheets--some of which are one page in length and others which are multiple pages in length (each worksheet is only one page in width). I have used Page Layout --> Page Setup --> Header/Footer --> Custom Footer in order to create the same footer on each page with consecutive page numbers ("&[Page]").

When I select all worksheets and go to Print Preview (there should be 42 total pages), the first 40 pages print consecutively (1-40), as they should, but the final two worsheets in my file print with page numbers #1 and #2. In other words, my pages are numbered 1, 2, 3, ... 40, 1, 2.

All of the settings in the Customer Footer appear to be identical, so I don't understand why the last two pages are not printing as 41 and 42. Any idea what might causing this?

Thank you!!

I have a workbook (happy to e-mail it if needed) that prints 8 different worksheets with the click of one button. I have recently installed a new printer and would like to make one of the worksheets print to a different print tray. Is this possible? My thoughts were that it may be possible through a page setup. Thanks in advance!

Hi there.

I have a bit of a question that I am hoping someone can provide an answer to...

I currently have an excel macro in place that I use to print off a monthly report. However that report consists of multiple Worksheets and Workbooks. It prints say 5 worksheets from workbook [a] and then 2 worksheets from workbook [b] and then a few more from workbook [a] and so on. In total it has 49 sheets that must be printed.

I have now been asked to apply page numbers to the report.

I have tried the basic way: print it all out, then put it back in the printer and double print the page numbers on it. However, simple in theory, but not when all the paper gets munched up by the printer. DOH!

So I'm wondering if there is some code I could put into my macro that will get it to print a page number onto the page and a consectutive page number on the next printout.

If anyone has a solution to this, I would be VERY grateful!

Our time sheets are kept individually on separate worksheets. These are combined for the total company to create the workbook. This continues throughout the year.

Problem: I need to be able to print the workbook with each page showing its page number and the total pages of the workbook. Example: Page 5 of 120. Because worksheets are added throughout the year, the solution must allow for those changes without the need to count total worksheets.

Is this possible and how is it done?


Hi all,
Apologies if there is another thread on this topic, but a quick search did not provide any results.
Here is my problem:
I have a workbook with multiple worksheets Each of these worksheets have different sets of data and graphs on them I have set up automatic publish to web page on several worksheets when saving the workbook I created the workbook in Excel 2003 and everything was working fine After upgrading to Excel 2007 I have noticed that when saving, any worksheets that do not have focus will not publish any of the graphs on that page. NOTE: The data is published fine. Is this a known problem that there is an easy fix to?



I'm working on a template that would allow for a "setup" page to display the name of each worksheet in the workbook. Besides the setup page, there would be a worksheet that serves as the template with the intention that it might be copied several other times and renamed each time. I don't want to burden the user with renaming the worksheet then returning to the setup page to add the new worksheet name to a list (used for sheet references in other formulas elsewhere in the workbook). Is the a simple formula I just haven't stumbled across that will allow for returning a worksheets name to a cell? I have the feeling it wouldn't be too difficult to build a macro for this either. I assume the trick in the macro would be to define a loop by the number of worksheets in a workbook, so does that mean there is another means of identifying a worksheet numerically (in a caption or property)?

Thanks for any advice or solutions in advance!