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.....

 

[Shakynom]

Help pLZZZZZZZZ

 

[My Aswer Is This]

I looked at this question earlier but did not understand if there was a question here.
And you said:

i have this excel sheet in which the upper columns are freeze

Upper columns ??
Excel has upper rows but how can a column be upper.​

 

[Shakynom]

Sorry if i was not able to deliver my Question clearly, the question is the columns heading A,B,C,D hide when i scroll down, and the title which are freezes take their place. Or if i click any cell on the sheet the freeze cell take place of A,B,C,D. you can see the both different pics, i need to know how this happen?

 

[My Aswer Is This]

If I understand your saying you want to always see the Table Headers.
But you also want to see the column letters like A B C D E..
So are you saying you always want to see Row(1)?

 

[My Aswer Is This]

Now that I look at your images I see what you mean.
You want to see the column letters like A B C

How are you freezing the Table top Row?
Are you using a Vba script?

If so show me the script.

 

[Fluff]

What your images show is standard for a structured table.
If you want to keep the column labels visible at all times, select A1 & then on the view tab select Freeze Panes > Freeze top row.

 

[My Aswer Is This]

What your images show is standard for a structured table.
If you want to keep the column labels visible at all times, select A1 & then on the view tab select Freeze Panes > Freeze top row.

I have never had a filter cause the column letters like A B C to disappear like is shown in the one image. Not sure how you define structured Table

 

[Fluff]

It happens if the data is in a structured table, not when you add an autofilter to a normal range.

 

[My Aswer Is This]

It happens if the data is in a structured table, not when you add an autofilter to a normal range.

It does not do that when I have a filter in a Excel Table Range