By Marlo Anderson – The Tech Ranch
Scrolling through the volunteer list and forgot which column is the phone number? Press Alt › W › F › R and your headings stay put.
The Shortcut
- Alt › W › F › R: freeze the top row
- Press the keys one after another
- Alt › W › F › F: unfreeze
- Excel on Windows
Bonus Tip: Freeze the First Column
Press Alt › W › F › C so the names in column A stay on screen while you scroll sideways.
More Keyboard Shortcuts, Explained
This is part of my Keyboard Shortcuts Explained series: quick, plain-English tips that make everyday computer work faster. Watch the whole series on YouTube and subscribe to The Tech Ranch so you don’t miss the next one.
Found this helpful? Give the video a thumbs up on YouTube. Got a shortcut you can’t live without? Tell me in the YouTube comments and it might show up in a future video.
