Microsoft Excel makes adding headers and footers a snap. We will show you how.
How to Add Headers and Footers in Microsoft Excel
Follow the below steps to add headers and footers in Microsoft Excel:
Open Microsoft Excel. Go to the Insert tab and click on the Header & Footer icon in the Text group. Doing so will add the header margin divided into the left, middle, and right sections. In the Design tab, you can enter custom information, or select presets such as Page Number, Number of Pages, Current Date, and many more. To let the changes take effect, click anywhere on the Excel sheet. Go to Insert > Header & Footer > Go to Footer. Fill out the three sections of the footer margin using the custom data or any available presets. For changes to take effect, click anywhere on the worksheet.
The steps above will add a header and footer to the Excel sheet. The header and footer are only displayed when viewing the page layout. To return to the original view, go to View > Normal. You can switch between these two views at any time.
It’s utterly important to password-protect your Excel documents when sharing them with others. If you don’t know how to do that, check out our article on how to password-protect an Excel file in a few minutes.
Add Headers and Footers With Ease in Microsoft Excel
You can add a header and footer to an Excel worksheet with a few clicks. You can also customize them to your liking. The presets you use in the header and footer are dynamic, so changes will automatically be reflected in the margins whenever you make changes in the worksheet.
Whenever you accidentally close an Excel workbook, you should know that you can quickly restore it. So don’t get upset when this happens.
