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

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

Hello Geeky, so today we are focusing on How to add Foot­ers and Head­ers in MS Excel. So please read this tutorial carefully so you may comprehend it in a better helpful way.

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

Do you want to know how to create a header in Excel? Or are you wondering how to insert the footer page 1 into the current worksheet? In this 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 look more stylish and professional, you can insert a header or footer on each page of your worksheet. Usually, headers and footers contain basic information about the worksheet such as page number, current date, workbook name, file path, etc. Microsoft Excel provides a handful of predefined headers and footers for you to choose from, and also allows you to create your own.

Below are processes and steps for inserting headers and footers in MS Excel.

From the Insert tab

  • Open Microsoft Excel.
  • Click 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 the Header & 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 & Footer Elements” settings to insert 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 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 the Header & Footer option.
  • Click the Header & Footer tab.
  • Click the sheet header or footer.
  • In the “Header & Footer Elements” section, click the Picture button.
  • Select the source to insert the image from, including: From a file, Bing Image Search, OneDrive.
  • Select and insert the image.
  • (Optional) Click the Format Picture button if you need to adjust the size, rotation, or scale.
  • Change the image settings as needed.
  • Click the OK button.

From 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 the Dialog Box 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 to use a predefined header.
  • (Optional) Use the Footer drop-down menu to select one of the available options to use a predefined footer.
  • Click the Custom Header button.
  • Click 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 the Format Text (A) button to style the header text.
  • (Optional) Click 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 the OK button.
  • Click the OK button again.

How to add header and footer to all sheets in Excel

  • Open Microsoft Excel.
  • Open the document you want to customize.
  • Add the header and footer as you usually would (see above steps).
  • Select the first sheet at the bottom of the document, hold on to the Ctrl key, and select the other sheets to which you want to apply the same header.
  • Click the header of the sheet and click away.
  • Select the first sheet at the bottom of the document, hold on to the Ctrl key, and select the other sheets to which you want to apply the same footer.
  • Click the footer of the sheet and click away.

Faq

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


In this guide, we told you about the How to add Foot­ers and Head­ers in MS Excel; please read all steps above so that you understand How to add Foot­ers and Head­ers in MS Excel in case if you need any assistance from us, then contact us.

How this tutorial or guide assisting you?


So in this guide, we discuss the How to add Foot­ers and Head­ers in MS Excel, which undoubtedly benefits you.




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 queries regards this article/tutorial you may ask us. Also, please share your love by sharing this article with your friends and family.

Trickbugs: Get the latest Trick and Tips
Logo
Enable registration in settings - general