You need to add page numbers, file names, or dates to your printed Excel sheets. Headers and footers are the standard way to include this information. Excel’s Page Layout view provides a direct method for editing them. This article explains how to insert and customize headers and footers using that view.
Key Takeaways: Adding Headers and Footers in Page Layout View
- View > Page Layout: Switches the workbook to a view where headers and footers are directly visible and editable on the sheet.
- Click in the header or footer area: Activates the Header & Footer Tools contextual tab and allows you to type custom text or insert codes.
- Header & Footer Tools > Design tab: Provides buttons to insert automatic elements like page numbers, current date, and file path into the selected header or footer section.
Understanding Headers, Footers, and Page Layout View
Headers and footers are reserved areas at the top and bottom of each printed page. They are not visible in the standard Normal view where you typically work with data. The Page Layout view simulates the printed page on your screen. This view shows margins, page breaks, and the actual header and footer areas. You can click directly into these areas to edit them, seeing a live preview of your changes. Before you start, ensure your data is ready for printing, as this view is designed for final page setup.
Steps to Insert and Modify Headers and Footers
Follow these steps to add or change headers and footers using the Page Layout view interface.
- Switch to Page Layout View
Open your workbook in Excel. Go to the View tab on the ribbon. In the Workbook Views group, click the Page Layout button. Your worksheet will change to show a page-by-page view. - Click to Edit the Header or Footer
Scroll to the top of the first page to see the header area, which is marked by the text “Click to add header”. Click inside the left, center, or right section of this area. The Header & Footer Tools Design tab will appear on the ribbon. - Add Custom Text or Automatic Elements
You can simply type text, like a report title. To insert automatic data, use the commands in the Header & Footer Elements group on the Design tab. For example, click Page Number to add a code that will show the correct number on each page. Click Current Date to insert the date the file is printed. - Navigate to the Footer
Scroll down to the bottom of the page to the footer area, marked “Click to add footer”. Click inside one of its three sections. You can add different elements here, such as the file path using the File Path button or the sheet name with the Sheet Name button. - Format Text and Close the View
Use the standard font formatting options on the Home tab to change the style of your header or footer text. When finished, you can return to Normal view by clicking View > Normal, or stay in Page Layout view to check other pages.
Common Mistakes and Limitations to Avoid
Editing headers and footers has specific constraints. Knowing these prevents formatting errors.
Header or Footer Text Appears Cut Off When Printed
This usually happens when the header or footer text is too large or the margin is too small. The header and footer exist within the top and bottom margin areas. Go to Page Layout > Margins and select Custom Margins. In the Page Setup dialog, increase the Top or Bottom margin value on the Margins tab to provide more space for your text.
Different Headers Not Appearing on First or Odd/Even Pages
By default, a header you create applies to all pages. To create a different first page header, check the Different First Page box on the Header & Footer Tools Design tab. To create different headers for odd and even pages, check the Different Odd & Even Pages box. You must then click into the designated areas for each page type to set the unique text.
Page Number Code Shows as &[Page] Instead of a Number
In Page Layout view, you see the field code, like &[Page], not the actual number. This is normal. To see the real page numbers, preview the printout by pressing Ctrl+P to open the print preview pane. The preview will show the calculated page numbers.
Page Layout View vs. Page Setup Dialog: Key Differences
| Item | Page Layout View | Page Setup Dialog |
|---|---|---|
| Access Method | View > Page Layout | Page Layout > Page Setup launcher |
| Editing Interface | Direct click-and-type on the sheet | Separate dialog box with text boxes |
| Visual Preview | Live, in-context preview on the worksheet | No live preview; only a small sample in the dialog |
| Best For | Quick edits and visual formatting | Precise control and applying settings to multiple sheets |
| Element Insertion | Uses ribbon buttons on the Design tab | Uses icon buttons above the text boxes |
You can now add professional headers and footers to your Excel printouts. Use the Page Layout view for a visual editing experience. For more control, explore the Header/Footer tab in the Page Setup dialog. Try using the Insert > Header & Footer command, which also switches you to Page Layout view but focuses the cursor directly in the header.