Have you ever tried to drag the header columns in an Excel spreadsheet to make them fit the text? I have and just when I think I’ve got it right, a quick glimpse down the line of columns usually ...

You can insert or add Header and Footer in Excel spreadsheet using this tutorial. Insert page number, current date and time, etc.

The header for both the row and column on the spreadsheet will hide, showing cells instead. The other option to hide the row and column headers in Excel is to click the File tab.

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.