Forum Discussion

Copper Contributor

Nov 21, 2024

Solved

How to freeze Excel tab at the start.

Hi, I've seen this before but can't for the life fo me remember how its done. I have an excel file that has multiple tabs and I want to freeze the first tab in place, so that when I scroll at the bot...

excel

HansVogelaar
Nov 21, 2024
It is possible - in a sense - using VBA code. It will only work in the desktop version of Excel for Windows and MacOS, and you'll have to allow macros. See Freezing Worksheet Tabs

JessicaOxford

Copper Contributor

Nov 21, 2024

Thanks HansVogelaar but I'm pretty sure it is. I remember using this feature in my last place of work but that was with .xls files. It was super handy because we worked in really large multi-tabs files. It was like a Freeze pane type thing but instead of in the worksheet, it was for the tabs.

Does that mean this feature is not available in .xlsx format? Was it lost in an upgrade?

HansVogelaar

MVP

Nov 21, 2024

It is possible - in a sense - using VBA code. It will only work in the desktop version of Excel for Windows and MacOS, and you'll have to allow macros. See Freezing Worksheet Tabs

JessicaOxford
Copper Contributor
Nov 21, 2024
Thank you HansVogelaar . This look like this might work out for me! I will give it a go.