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.

How to Eliminate the Lines in Excel. Your first view of an Excel spreadsheet is typically a gray column header and a gray row header, with some faintly dotted blue lines throughout the rest of the ...

You use Microsoft Excel 's built-in function to freeze specific rows and columns (often row or column headers), so when you’re scrolling through, these cells remain stationary on the page.