How to add Foot­ers and Head­ers in MS Excel

200

This tip is about the how to add Foot­ers and Head­ers in MS Excel. So read this free guide, How to add Foot­ers and Head­ers in MS Excel. If you have query related to same article you may contact us.

How to add Foot­ers and Head­ers in MS Excel – Guide

Do you want to know how to to create a header in Excel? Or are you wondering how to insert footer page 1 into the current sheet? In that tutorial you will learn how to quickly insert one of the predefined headers and footers and how to create a custom header and footer with your own text and graphics.

To make your printed Excel documents more elegant and professional, you can insert a header or footer on each page of your spreadsheet. Headers and footers typically contain basic information about the spreadsheet, such as page number, current date, workbook name, file path, and so on. Microsoft Excel provides a handful of predefined headers and footers to choose from and also lets you create your own.

Below are the processes and steps to insert headers and footers into MS Excel.

On the Insert tab

Open Microsoft Excel.

Click on the Blank Document option in the “Home” section. (Or open the document you want to customize.)

Click the Insert tab.

In the “Text” settings, click on the Header and footer option.

Click the left, middle or right cells at the top to edit the custom header.

Click the left, middle or right cells at the bottom to edit the custom footer.

(Optional) Use the “Header and Footer Elements” settings to enter predefined elements including: Page Number, Number of Pages, Current Date, Current Time, File Path, File Name, Sheet Name.

Use image for header or footer in Excel

Open Microsoft Excel.

Click on the Blank Document option in the “Home” section. (Or open the document you want to customize.)

Click the Insert tab.

In the “Text” settings, click on the Header and footer option.

Click the Header and Footer tab.

Click on the page header or footer.

In the “Header and Footer Elements” section, click on the image button.

Select the source from which to insert the image, including: From a file, Bing Image Search, OneDrive.

Select and insert the image.

(Optional) Click Format Image button if you need to adjust the size, rotation or scale.

Change image settings as needed.

Click on OK button.

On the Page Layout tab

Open Microsoft Excel.

Open the document you want to customize.

Click the Page Layout tab.

In the “Page Setup” settings, click on the Dialog Launcher button on the right side.

Click the Header / Footer tab.

(Optional) Use the Header drop-down menu to select one of the available options for using a predefined header.

(Optional) Use the Footer drop-down menu to select one of the available options for using a predefined footer.

Click on the custom header button.

Click on the custom footer button.

Select one of the sections (left, center or right) to show the header or footer.

Compose a line of text for the header or footer.

Select the text and click Format Text (A) button to set the style of the header text.

(Optional) Click on one of the available buttons to insert a predefined header including: Insert Page Number, Insert Number of Pages, Insert Date, Insert Time, Insert File Path, Insert File Name, Insert Sheet Name, Insert Picture.

Click on OK button.

Click on OK button again.

How to add header and footer to all Excel spreadsheets

Open Microsoft Excel.

Open the document you want to customize.

Add header and footer as usual (see steps above).

Select the first sheet at the bottom of the document, hold the Ctrl key and select the other sheets you want to apply the same header to.

Click on the sheet header and click away.

Select the first sheet at the bottom of the document, hold the Ctrl key and select the other sheets you want to apply the same footer to.

Click on the sheet footer and click away.

Final note

I hope you like the guide How to add Foot­ers and Head­ers in MS Excel. In case if you have any query regards this article you may ask us. Also, please share your love by sharing this article with your friends.