To add a Header and Footer in the Excel spreadsheet, follow these steps-Open Microsoft Excel on your computer. Switch to the Insert tab. Click the Header & Footer option in the Text section.