Check to Show Headings Add or remove a check mark next to "View" to reveal or hide, respectively, the Excel headings on the spreadsheet.

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.

Can Excel show column headers on every screen? Yes, in Excel it’s called Freezing Panes, which can be applied to columns or rows (or both), and it’s super-simple.