Excel® 2013 On Demand

Adding Headers and Footers

Adding a header or footer to a workbook is a convenient way to make your printout easier for readers to follow. Using the Design tab under Header & Footer Tools, you can add predefined header or footer information—such as a page number and worksheet title—at the top and bottom of each page or section of a worksheet or workbook. If a predefined header or footer doesn’t work, you can insert individual elements such as your computer system’s date and time, the name of the workbook and sheet, a picture, or other custom information. When you insert elements in a header or footer, Excel inserts an ampersand followed by brackets with the name of the element, such as &[Page] for Page Number. Excel changes the code to the actual ...