Insert Page Number. Insert Number of Pages. Insert Date. Insert Time. ... After you complete the steps, the footer and header will no longer be in the Excel sheet. From the Page Layouts tab.

If you want to add a header or footer to all sheets, select every sheet by right-clicking one of the sheet tabs at the bottom of the Excel screen and clicking "Select All Sheets" in the pop-up menu.