Make Excel Row Visible Even When You Scroll Up and Down


Say you have a tall Excel sheet whose number of rows exceed the amount your screen can show at once. It’s a scrollable sheet you have, and the kind of sheet where the first row is a header:

So far so good, but when you scroll down, the header row disappears:

So, how to make it sticky, to be visible at the top when scrolling down? It’s simple: just navigate to View Freeze panesFreeze Top Row. After that, the sheet will have the functionality we wanted. Like this:

Share Your Thoughts

Have something to say about this post? Then say it by filling the form below!