Keep top row pinned to top?

Question

How do I keep the top row, my column labels, pinned to the top of my spreadsheet?

subodh_tiwari_sktneer · Answer

ks0010&nbsp;To do that, go to the View Tab --&gt; Freeze Panes --&gt; Expand it and choose Freeze Top Row.

ks0010 · Answer

Thanks!

subodh_tiwari_sktneer · Answer

ks0010&nbsp;You're welcome!You may now mark your question as Solved by accepting the post which resolved it as a Best Answer/Response.

erol sinan zorlu · Answer

Subodh_Tiwari_sktneer&nbsp;&nbsp;you can also use "Insert"--&gt; "Table" to the desired range so that the headers will be shown as column names

subodh_tiwari_sktneer · Answer

erol sinan zorlu&nbsp;Do you mean, converting a range into an Excel Table freezes the header row and remains visible when you scroll down the page? Did you try that?

Forum Discussion

Keep top row pinned to top?

7 Replies

Resources