Excel Table Header

[Graemea]

Hi,

In my version of Office 365 when I create a table in Excel (Ctrl + T) and then scroll down the page the headers are not "locked" as they're supposed to be with a table and so Freeze Panes is required.

Do I need to change one of the settings so that the table headers are always visible when scrolling down the table?

Thanks

 

[Fluff]

Do you have more than one table on the same sheet?

 

[Graemea]

No, one table per sheet

 

[Fluff]

In that case I don't know, I've only ever seen that if there is more than one table.
As far as I know there is no setting to change that behaviour.

 

[Graemea]

Thanks for replying!

 

[Fluff]

You're welcome, sorry I couldn't have been of more help.

 

[DJunqueira]

I think you are confounding the header of the table with the header that apear in the columns line, a normal table is not supposed to have the header frozen.

 

[ISY]

Hi

Note: to view the headers you must select a cell in the table otherwise you will see the column headers!