I have a spreadsheet where I'm tracking inventory on misc electronics that we keep in stock. I have set up a table that holds all the printers. When I scroll down I know that I can use Freeze Panes to freeze the top row (or any row/column), but I would like the table header to cover the sheet header.
Headers from table covering the headers of the sheet when scrolling down:
These examples are not from a workbook that I set up so I'm not sure how it's done, but I want to replicate it on workbooks that I have created.
In my file, I have a table that I created beginning in row 1. When I scroll down the table header does not cover the sheet header.