Printing Footers on Grouped Worksheets

G

Guest

I have 15 worksheets which I would like to print with the worksheet tab in
the bottom right hand corner. I Grouped all the worksheets and then clicked
print entire workbook and clicked on Footers and click on worksheet tab.

The worksheet tab only appears as a footer only in the first worksheet even
though the sheets are grouped.

Can anyone help me?
 
B

Bob Umlas

Once they're in group mode, visit Page Setup & put in the footer you want --
it'll be applies to them all.
Bob Umlas
Excel MVP
 

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

Insert Page Numbers on Worksheet in Excel 2007 6
Warning that can be created when more than 1 worksheet is selected 3
How do I make a single header/footer common across all worksheets? 1
Grouped worksheets do not show up 2
Print worksheet 2 on back of worksheet 1, etc.... 1
SUBTOTAL 2 WORKSHEETS 6
Duplex Printing of Workbook with multiple worksheets 2
Partial printing of entire worksheet (1st or 2nd pages only) 4

Top