Because Excel is not a word processor, you may not think if you can add header and footer to your print pages. But you can add and customize them almost you can do in Word. In this guide, we’re going to show you how to add header and footer in Excel.
Header and Footer in Excel
Headers and footers in Excel serve users to print their spreadsheets along with some metadata like page number, current date, workbook name, file path, etc. Also, you can add your company's logo and information to make the printed document more professional.
How to add header and footer in Excel
- Go to Insert > Header & Footer in Text group
- After clicking, Excel switches to Print Mode to show header section. You will see three (3) boxes which you can select any and type or insert information.
- To navigate between header and footer, use Go to Footer and Go to Header commands in the contextual Header & Footer tab in the Ribbon.
Header and Footer elements
After adding header and footer in Excel, you need to insert data into them. Of course, you can type anything you want to display. However, using static text only is kind of wasting the potential. Excel presents you predefined dynamic elements which will calculated automatically. For example, if you add Page Number element, Excel automatically number the pages incrementally. The numbers will be updated as you add ore remove pages. Another metadata is Current Date. You can print your document with current date value every time. Here are your options:
- Page Number
- Number of Pages: Total number of pages.
- Current Date
- Current Time
- File Path
- File Name
You can find all these options in the Ribbon:
Out final tip in for adding header and footer in Excel is the presets. Are you confused about which element to use? Then check out the presets Excel listed for you. Click on Header or Footer commands to see available presets. Excel lists them with the actual values.