How can header cells in Excel be "pinned" or "frozen"?
Rise to the top 3% as a developer or hire one of them at Toptal: https://topt.al/25cXVn
--------------------------------------------------
Music by Eric Matyas
https://www.soundimage.org
Track title: Puzzling Curiosities
--
Chapters
00:00 How Can Header Cells In Excel Be &Quot;Pinned&Quot; Or &Quot;Frozen&Quot;?
00:16 Accepted Answer Score 16
00:36 Answer 2 Score 1
00:44 Answer 3 Score 1
01:05 Thank you
--
Full question
https://superuser.com/questions/228751/h...
--
Content licensed under CC BY-SA
https://meta.stackexchange.com/help/lice...
--
Tags
#microsoftexcel
#avk47
ACCEPTED ANSWER
Score 16
If this is Excel 2007, you are looking for "Freeze Pane" under the View tab. If you want to know how to use it, open Excel help and look for freeze. The first result should be a detailed explanation on how to use the feature.
ANSWER 2
Score 1
Another way to do this, is there's a bar in the upper right corner that you can drag down for a horizontal split. I don't have a copy of Excel so I can't show you the effect, but here's the little bar:
There's also a little bar on the bottom of the screen that you can drag for a vertical split.
ANSWER 3
Score 1
Here's mate for bahamat's answer: there's a corresponding vertical bar at the bottom right corner of the screen that works the same way for isolating columns.
A bar can also appear to the left of the horizontal scrollbar as well, but this one doesn't do splitting. Instead, it is used for resizing the horizontal scrollbar:
