Loading
Excel.Tips.Net ExcelTips (Menu Interface)

Putting Headers and Footers On Multiple Worksheets

Please Note: This article is written for users of the following Microsoft Excel versions: 97, 2000, 2002, and 2003. If you are using a later version (Excel 2007 or later), this tip may not work for you. For a version of this tip written specifically for later versions of Excel, click here: Putting Headers and Footers on Multiple Worksheets.

One of the typical last touches to a worksheet before printing is to place headers or footers. This is very easy to do if you have only a worksheet or two in which to place the headers and footers. What if you have quite a few worksheets in the same workbook, and you want them all to have the same header and footer.

Actually this isn't too hard to do, either. All you need to do is work with a group of worksheets as a single unit. Just follow these general steps:

  1. Decide which worksheets you want to have the same headers or footers.
  2. Select the first worksheet in the series (click the tab for that worksheet).
  3. Hold down the Shift key as you click on the tab for the last worksheet in the series. A range of worksheets should now be selected. Excel also adds the word [Group] to the title bar to indicate you have a group of worksheets selected.
  4. Set your header or footer as you normally would (as outlined in other issues of ExcelTips). Your changes are automatically made on all the sheet in the selected range.
  5. When done, select a single worksheet by clicking on its tab. (Click on the tab of a worksheet other than the first in the range.)

That's it; you've now set the headers or footers of all the sheets to be identical.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2600) applies to Microsoft Excel 97, 2000, 2002, and 2003. You can find a version of this tip for the ribbon interface of Excel (Excel 2007 and later) here: Putting Headers and Footers on Multiple Worksheets.

Related Tips:

Professional Development Guidance! Four world-class developers offer start-to-finish guidance for building powerful, robust, and secure applications with Excel. The authors show how to consistently make the right design decisions and make the most of Excel's powerful features. Check out Professional Excel Development today!

 

Leave your own comment:

*Name:
Email:
  Notify me about new comments ONLY FOR THIS TIP
Notify me about new comments ANYWHERE ON THIS SITE
Hide my email address
*Text:
*What is 5+3 (To prevent automated submissions and spam.)
 
 
           Commenting Terms

Comments for this tip:

John Rolfe-Dickinson    21 Dec 2016, 06:18
I've used this technique to set up a template document comprising 3 separate tabs.This worked fine but part of the text in the Headers and footers will be changed as the template is used for a specific document.
When I use the template to make a specific document the amendments in the headers and footers only change per tab, not through the whole workbook.
Is there a way to resolve this?
Shailesh    16 May 2016, 09:19
thank you very much... it save lots of time
 
Niju Ajay    31 Mar 2016, 07:37
Need to know how can i put a header on top of all sheet...
Margot    13 Jan 2016, 16:50
A really great service - thanks so much.
Trista    11 Sep 2015, 14:11
Each time I change the header on worksheet #1 I would like the header to change on worksheet #4 to reflect the same changes without having to go into it and make the changes manually. Is there a way to do that? I have other cells using a formula to copy info from worksheet #1 but I don't know how to do it with a header. Thank you.
 
 

Our Company

Sharon Parq Associates, Inc.

About Tips.Net

Contact Us

 

Advertise with Us

Our Privacy Policy

Our Sites

Tips.Net

Beauty and Style

Cars

Cleaning

Cooking

DriveTips (Google Drive)

ExcelTips (Excel 97–2003)

ExcelTips (Excel 2007–2016)

Gardening

Health

Home Improvement

Money and Finances

Organizing

Pests and Bugs

Pets and Animals

WindowsTips (Microsoft Windows)

WordTips (Word 97–2003)

WordTips (Word 2007–2016)

Our Products

Helpful E-books

Newsletter Archives

 

Excel Products

Word Products

Our Authors

Author Index

Write for Tips.Net

Copyright © 2017 Sharon Parq Associates, Inc.