How to Create a Custom Header or Footer in Excel 2013
1 of 6
Put your worksheet into Page Layout view by clicking the Page Layout View button on the status bar, or by choosing View→Page Layout View on the Ribbon, or by pressing Alt+WP.
In Page Layout view, the text Click to Add Header appears centered in the top margin of the first page, and the text Click to Add Footer appears centered in the bottom margin.
