Creating the same footer for several Excel worksheets

Let's say you have a workbook with twelve worksheets that you use to track information for each month of the year.  You want the same footer to be printed on each worksheet.  Do you need to set up the footer separately for each of the twelve sheets?  No.  First group the worksheets and then create the footer.

To group worksheets:

• Click on the first worksheet tab
• Press Shift
• Click on the last worksheet tab

To create the footer (2003):

• File menu, Page Setup
• Header/Footer tab
• Enter footer fields, as needed
• Click on OK

To create the footer (2007):

• Insert tab, Text group, Header & Footer
• Enter footer fields, as needed
• Click in the worksheet when finished

To ungroup the worksheets:

• Right-click on one of the grouped worksheet tabs
• Select Ungroup Sheets

Make sure you remember to ungroup the worksheets; otherwise any changes you make to a worksheet will be applied to all the grouped sheets.  Not a good thing!

Any questions, please let me know.

Interested in Microsoft Excel Training in Vancouver?