Page 306 - Excel 2013 All-in-One For Dummies

288 Headers and Footers
Check out the results in Figure 5-11, which is the first page of the report in Page Layout view. Here you can see the header and footer as they will print. You can also see how choosing Page 1 of ? works in the footer: On the first page, you see the centered footer: Page 1 of 6; on the second page, you would see the centered footer Page 2 of 6.
If, after selecting a ready-made header or footer, you decide that you no longer need either the header or footer printed in your report, click the header or footer in Page Layout view and then choose the (none) option at the top of the Header button’s or Footer button’s drop-down menu. (The Design tab on the Header & Footer Tools contextual tab automatically appears and is selected on the Ribbon the moment you click the header or footer in Page Layout view.)
Creating a custom header or footer
Most of the time, the stock headers and footers available on the Header but- ton’s and Footer button’s drop-down menus are sufficient for your report printing needs. Every once in a while, however, you may want to insert infor- mation not available in these list boxes or in an arrangement Excel doesn’t offer in the ready-made headers and footers.
For those times, you need to use the command buttons that appear in the Header & Footer Elements group of the Design tab on the Header & Footer Tools contextual tab. These command buttons enable you to blend your own information with that generated by Excel into different sections of the custom header or footer you’re creating.
The command buttons in the Header & Footer Elements group include the following:
✦ Page Number: Click this button to insert the &[Page] code that puts in the current page number.
✦ Number of Pages: Click this button to insert the &[Pages] code that puts in the total number of pages.
✦ Current Date: Click this button to insert the &[Date] code that puts in the current date.
✦ Current Time: Click this button to insert the &[Time] code that puts in the current time.
✦ File Path: Click this button to insert the &[Path]&[File] code that puts in the directory path along with the name of the workbook file.
✦ File Name: Click this button to insert the &[File] code that puts in the name of the workbook file.