Forum Discussion
JessicaOxford
Nov 21, 2024Copper Contributor
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...
- 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
HansVogelaar
Nov 21, 2024MVP
That is not possible, sorry.
SoniaChu
Dec 30, 2024Copper Contributor
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