Constructing headers and footers in Microsoft Excel 2019

Headers and footers reside at the top (header) or at the bottom(footer) of worksheets in Excel. The content of headers and footersusually consists of page numbers, worksheet or workbook titles, authornames, the creation date of the workbook, the date the workbook wasupdated, or text a user enters to describe the workbook.

Headers and footers do not display in Normal view. Normal view is the default view of the Excelenvironment and is what you see when you open a workbook inExcel. Headers and footers are displayed in Page Layout view and on Preview pages(visible in Backstage view after clicking on the File tab, and choosing Print). Once in the Header and Footer dialog box, you can chooseto add predefined headers or footers, or input text of your choice.There are numerous methods to insert headers and footers into aworkbook. We will learn about some of these methods, as follows:

  1. Open the workbook to which you would like to add headers and orfooters. We will continue using the same workbook as the precedingexample.
  2. Select the Page Layout tabto access the Page Setupgroup.
  3. Click on the PageSetup dialog box launcher, located to the right ofthe Page Setup group, asillustrated in the following screenshot:
ms office 430
  1. Alternatively, locate the Textgroup using the Insert tab, and thenselect the Header & Footericon.


Click on File | Print from thedrop-down menu, locate the Settingsheading, and click on Page Setup.


Click on the View tab to change theview of the workbook to Page Layout,and then click to access the Header orFooter section of theworksheet. Notice the Header &Footer tools provided on the ribbon. The worksheet displays inPage Layout view when selecting theInsert | Header & Footer option. At the top of the worksheet, youwill see three separate areas (rectangles) above the worksheet—this isthe Header area. 

  1. Click to select one of the rectangles to input text to the left,center, or right of the Headerarea. The same applies to the Footerarea. Scroll down to the bottom of the first page of the worksheet usingthe mouse, or alternatively, click on the Goto Footer icon along the ribbon.
  2. The Header & Footer Toolscontextual menu is visible and includes a Design tab where you will format, type,and/or select predefined layouts. The Header and Footer drop-down options to the left of theribbon offer predefined headers and footers to format the documentquickly. Header and footer elements are also available along the ribbon,should you wish to insert page numbers, dates, the worksheet name, sheetname, or document location. You can also use this ribbon to navigatebetween Header and Footer areas or set further options,as illustrated in the followingscreenshot:
ms office 11
  1. Once the header is inserted using the header elements or predefinedheader styles, the user can view the result by clicking off the Header area onto the worksheet.
  2. To edit the header, simply click on the Header area to change information.
  3. Once you have clicked into the Header or Footer area, the Header & Footer Design tab will appear,reflecting the header and footer elements along the ribbon.
  4. To format header and footer text, use the relevant format icons onthe Home tab (remember to select textbefore making any changes).
  5. Please note that you will only have access to certain basic iconsfor formatting—some icons will appear grayed out (not available) when inthis view.
  6. To apply Different First Page orDifferent Odd & Even Pages headersor footers, select the relevant icon option from the Design tab, as illustrated in thefollowing screenshot:
ms office 336
  1. To apply the same header and/or footer to the workbook or a selectednumber of worksheets, make sure that they are selected (grouped) beforeyou insert a header or footer.
  2. To remove a header or footer from a worksheet, click in the relevantHeader or Footer area and delete the item displayed,or select None from the Header or Footer icon on the Header & Footer group of the Design tab.
Note that if you click into the Headeror Footer area of a worksheet, theworksheet views will be grayed out and you would need to click on theworksheet data to gain access to change the view, as illustrated in thefollowing screenshot:

ms office 724

Leave a Comment