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.
Create Custom Apps with VBA! Discover how to extend the capabilities of Office 2013 (Word, Excel, PowerPoint, Outlook, and Access) with VBA programming, using it for writing macros, automating Office applications, and creating custom applications. Check out Mastering VBA for Office 2013 today!
Setting up a single footer line for your printouts is fairly easy. If you want to move part of the footer down a line so ...
Discover MoreChanging the look of default headers and footers for your Excel workbooks.
Discover MoreWhen preparing your worksheet for printing, you may want to add a header that appears at the top of each page that you ...
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