Forum Discussion
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 bottom to see different tabs, it stays in place. How do I do that? Thanks
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
5 Replies
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?
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
Thank you HansVogelaar . This look like this might work out for me! I will give it a go.
That is not possible, sorry.
HansVogelaar - try this - https://www.extendoffice.com/documents/excel/2695-excel-lock-freeze-worksheet-tab.html
The preferred always visible tab will not always sit as your first tab; rather, it "trails you around as you work through multiple tabs, but it is always visible. It's good enough for me.
Perhaps my response is for JessicaOxford
