Keep top row pinned to top?

Copper Contributor

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

7 Replies

@ks0010 

To do that, go to the View Tab --> Freeze Panes --> Expand it and choose Freeze Top Row.

Freeze Top Row.jpg

Thanks!

@ks0010 

You're welcome!

You may now mark your question as Solved by accepting the post which resolved it as a Best Answer/Response.

@Subodh_Tiwari_sktneer 

 

you can also use "Insert"--> "Table" to the desired range so that the headers will be shown as column names

@erol sinan zorlu 

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?

@Subodh_Tiwari_sktneer 

 

yes, if you click on any cell in the table the headers will be visible as column names. see the attached file.

@erol sinan zorlu 

I see now what you were talking about.

Yes, that can also be an approach provided user is willing to convert the data into an Excel Table.