Printing Footers on Grouped Worksheets

E

ExcelNovice

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

Wonky printout when I print entire workbook 0
How do I make a single header/footer common across all worksheets? 2
Need VBA Macro to Loop through pages and print counter in footer of each page 9
worksheet skipped in page numbering 0
page setup 2
Insert Page Numbers on Worksheet in Excel 2007 6
print worksheet group in color 0
Header and Footer margins 1

Top