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:
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.
Program Successfully in Excel! John Walkenbach's name is synonymous with excellence in deciphering complex technical topics. With this comprehensive guide, "Mr. Spreadsheet" shows how to maximize your Excel experience using professional spreadsheet application development tips from his own personal bookshelf. Check out Excel 2013 Power Programming with VBA today!
When you have a worksheet that includes a long list of names, you may want the first and last names on each page to ...
Discover MorePlace an ampersand into the text of a page header or footer, and you might be surprised to see it missing in your ...
Discover MoreWhen preparing a worksheet for printing, you may want to include in the header or footer the last date the workbook was ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
2017-04-12 10:16:00
Elmer Deming
I followed the steps above, however, it's populating all data from one sheet to the other. I just want to duplicate the header from one sheet to another.
2016-12-21 06:18:11
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?
2016-05-16 09:19:26
Shailesh
thank you very much... it save lots of time
2016-03-31 07:37:03
Need to know how can i put a header on top of all sheet...
2016-01-13 16:50:44
Margot
A really great service - thanks so much.
2015-09-11 14:11:35
Trista
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.
Got a version of Excel that uses the menu interface (Excel 97, Excel 2000, Excel 2002, or Excel 2003)? This site is for you! If you use a later version of Excel, visit our ExcelTips site focusing on the ribbon interface.
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2021 Sharon Parq Associates, Inc.
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: 
Comments