Header and Footer Dialog box Excel 13

Headers and Footers are text that are printed on the top margins and bottom margins of a spreadsheet. Headers and Footers can contain titles, dates, page numbers and even can contain graphics. We can specify a different Header or Footer for Odd and Even pages or even use a different Header or Footer for the first page.

As mentioned above Headers are printed on the top margin of the page and Footers are printed on the bottom margin of the page. Headers and Footers are the same for all of Microsoft applications.

There are many ways to create Headers and Footers in Excel 13. In the post described below, we will create Headers and Footers with the Header and Footer dialog box. All we have to do is to follow the steps below.

We must select the Page Layout tab and then from the area of the ribbon named Page Setup, we select the arrow, which is located at the bottom right corner of the Page Setup area as shown in the image below.

Page Layout - Page Setup

Once selected the Page Setup dialog box appears, where we must select the Header/Footer tab as shown in the image below.

On the top part of the Page Setup dialog box and on the Header/Footer tab, we have the Header area, and at the middle of the dialog box, we have the Footer area. If we had edited the Header area, we would have seen a preview of it on the top part of the dialog box. If we had edited the Footer area, we would have seen a preview of it on the bottom part of the dialog box.

Page Setup - Headers & Footer

If we select the drop down menu next to the Header command as shown in the image below, all the predefined Headings will appear, where we just select the predefined Header that we want.

Predefined Header

If we select the drop down menu next to the Footer command as shown in the image below, all the predefined Footers will appear, where we just select the predefined Footer that we want.

Predefined Footer

In order to create a custom Header, we must select the Custom Header button, which is located in the middle of the Page Setup dialog box. Once selected the Header dialog box appears, which is separated in three different sections. The Left Section the Center Section and the Right Section. All we have to do is to click on the section that we want to edit the Header.

Custom Header

We can also use the available buttons, which are the same for the Footer also, and they are the following:

  • Format Text: We can format the text that we have inserted in the Header or Footer.
  • Page Number: Inserts the Page Number.
  • Number Of Pages: Inserts the Number of Pages, where it updates automatically as we change the workbook.
  • Current Date: Inserts the Current Date.
  • Current Time: Insert the Current Time.
  • File Path: Inserts the name of the current file, along with the full path of the file.
  • File Name: Inserts the name of the current file.
  • Sheet Name: Inserts the name of the current Sheet.
  • Picture: Inserts a picture.
  • Format Picture: We can format the picture, either by changing the brightness, contrast or size.

Whatever changes we do, in order for them to take place we must select the OK button, which is located at the bottom right corner of the dialog box.

In order to create a custom Footer, we must select the Custom Footer button, which is located in the middle of the Page Setup dialog box and then we follow the same procedure as described for the Header.

Custom Footer

At the bottom of the Header/Footer tab, we have the following available commands described below, which we can activate or deactivate in order for them to take place.

Header And Footer 13

  • Different First Page: We can give the Header or Footer a different First Page compare to the rest of the document.
  • Different Odd & Even Pages: We can specify that the Odd Numbered Pages have a different Header/Footer from the Even Numbered Pages.
  • Scale With Document: We can specify that the Header/Footer should scale as we use the Shrink To Fit command on the document.
  • Align With Page Numbers: Aligns the side of the Header or Footer with the Page Margins.

In the next post I will describe how to create Header and Footers using the Page Layout View in Excel 13.

Below you can check out the video describing how to create Header and Footers using the Header/Footer dialog box in Excel 13.

 

About officesmart

MVP: Honored with the MVP (Most Valuable Professional) for OFFICE SYSTEM title for the years 2011, 2012, 2013, 2014 and 2015 by Microsoft, for my contribution and commitment to the technical communities worldwide. Microsoft Master Specialist: This certification provides skill-verification tools that not only help assess a person's skills in using Microsoft Office programs but also the ability to quickly complete on-the-job tasks across multiple programs in the Microsoft Office system

Posted on July 7, 2015, in Excel English 2013, Microsoft Office 2013 English and tagged , , , , , , , , , , , , , , , , , , , , , , , , . Bookmark the permalink. Comments Off on Header and Footer Dialog box Excel 13.

Comments are closed.