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.. On the backstage ...

Open an Excel Worksheet and click "Insert." Click the "Text" button followed by "Header & Footer." Excel switches to layout view and displays three empty header columns at the top of the worksheet.

Another way to make large Excel tables like the one in the example above easier to read is by freezing the row and column headers. In the View tab on the ribbon, click "Freeze Panes," and choose ...

4. The Create Table dialog opens with the table range pre-selected. If this is wrong, enter (or point) to the correct range; however, if correct, check the box that says My Table Has Headers, then ...