Click the worksheet where you want to add or change headers or footers. On the Insert tab, in the Text group, click Header & Footer. Excel displays the worksheet in Page Layout view. To add or edit a header or footer, click the left, center, or right header or footer text box at the top or the bottom of the worksheet page (under Header, or. Oct 08, · Click the worksheet on which you want to add a footer. Clicking the worksheet's tab at the bottom of Excel will bring that worksheet into view. If you want to apply the footer to all sheets in the workbook, right-click any of the worksheet tabs, then click Select All Sheets from the menu. To select more than one (but not all) worksheets, hold.
Learn More