MrExcel Publishing
Your One Stop for Excel Tips & Solutions


Posted by Anne Dickinson on February 12, 2001 10:59 AM

Is there a way to format all of the pages in a given Excel workbook with the same footer? I have an excel workbook with 15 worksheets and I want them all to have the same footer. For instance, I want to have the name and tab in the bottom left hand corner, the page number in the center and the date and time in the bottom right hand corner), but I don't want to have to do Page Set-Up for each of the individual worksheets.

Any ideas?

Posted by Loren on February 12, 2001 11:15 AM

1.create the footer you want on one sheet.
2. making sure you are on the original sheet, select
all the sheets, by R clicking the tab and "select all"
3. use file-page -setup, ok. It will copy your footer
to all sheets. You are done