Changing The Page Setup For Multiple Worksheets In A Workbook

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?

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.

Thanks!

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 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 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 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 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 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!

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?

Cheers

Rob

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?

Thanks

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!

Matt

I have a report that I need to number them consequitively:
worksheet 1 Page 1
Worksheet 2 Page 2
Worksheet 3 page 3 to page 4
Worksheet 6 page 5 to 7

I there a way to renumber worksheets within the workbook ? Thanks.

I am trying to print multiple worksheets (specifically, a 19-worksheet workbook) and I want each worksheet to contain the next sequential page number (i.e. worksheet #7 will read "Page 7 of 19" in the right-hand footer; each worksheet is only one printed page).

The only way I know to do this is to input "Page &[Page] of 19" in the footer and change the "First Page Number" on each worksheet. I have tried this twice now (and saved after both times), but Excel does not keep the First Page Number that I assign to each worksheet.

For example, worksheet 7 reads "Page 1 of 19" because Excel has not retained the First Page Number of 7 that I set for that worksheet. I have tried a few times, but do not know why Excel is not saving this information. Any ideas?

I have created a page of hyperlinks to other worksheets in a workbook.
On just one of them, when I click the hyperlink cell, it sends me to
the right page but the entire page is highlighted. When I try to
re-setup the hyperlink, I can set the worksheet again OK but the
specific cell for the cursor to be in when I get there is greyed-out
on the hyperlink setup dialog box. None of the others did this. It has
been a while since I did the others. Am I forgetting something???