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.

If none of them meets your needs, click on either Custom Header or Custom Footer , which brings up this screen: . By placing your cursor in any of the boxes ( Left section, Center section, Right ...

Yes, in Excel it’s called Freezing Panes, which can be applied to columns or rows (or both), and it’s super-simple. We’ll also show you how to split screens, a similar feature.