2

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.

Example: Headers enter image description here

Headers from table covering the headers of the sheet when scrolling down: enter image description here

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. enter image description here

Improve this question

1 Answer 1

Reset to default
1

For me, in Excel 2016, the default behaviour is what you want. If I do not freeze panes, then any time I scroll down past the table header, the headers overlay the column letters as shown in your second picture. If I scroll down past the bottom of the table, then the headers disappear again.

Table before scrolling down:

enter image description here

Table after scrolling down 3 rows:

enter image description here

If I do freeze panes, the above behaviour does not happen and is not restored when I unfreeze panes (I have to recreate to table to restore the bahaviour).

Improve this answer
7
  • Mine does not work this way, I made an update to show this.
    – Mike
    Oct 27, 2017 at 14:44
  • 1
    @mike Did you ever freeze panes on that worksheet? I find that if I freeze panes and then unfreeze them, I have to convert the table to a range and then convert back to a table in order to restore the behaviour.
    – Blackwood
    Oct 27, 2017 at 14:47
  • I don't remember if I have used Freeze panes on this one or not. I did try your trick of converting to a range and then back to a table. Still did not make any change.
    – Mike
    Oct 27, 2017 at 14:48
  • I do have my table starting in row 1 does that make a difference?
    – Mike
    Oct 27, 2017 at 14:49
  • 1
    That could be, I'm using the same as you, just installed last week. I've not seen this behavior in previous versions, but like it and wanted to use it. I saw it in someone else's file (the pictures above) and couldn't figure out how to make it work.
    – Mike
    Oct 27, 2017 at 14:53

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .