Columns freezing Options

[Shakynom]

i have this excel sheet in which the upper columns are freeze in a way when i click any cell it shows the freezes cells. or if the range of freeze columns is select and i scrool down it remain on top even it take place of A,B,C,D.....

 

[Fluff]

It's got nothing to do with filters, if the data is in a proper table (with or without filters) the table header will move into the column labels when you scroll down.
As far as I know, that has always been the case & you cannot stop it, short of freezing the top row.

 

[My Aswer Is This]

It's got nothing to do with filters, if the data is in a proper table (with or without filters) the table header will move into the column labels when you scroll down.
As far as I know, that has always been the case & you cannot stop it, short of freezing the top row.
View attachment 3081

View attachment 3083

I'm using Excel 2013 and the column letters like A B C never disappear as I scroll down. When using a Excel Table

 

[Fluff]

In that case my memory must be playing tricks on me. I thought tables had always done that, but obviously not.