Forum Discussion

Copper Contributor

Sep 17, 2019

Keep top row pinned to top?

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

Subodh_Tiwari_sktneer

Silver Contributor

Sep 18, 2019

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

ks0010
Copper Contributor
Sep 18, 2019
Thanks!
- Subodh_Tiwari_sktneer
  Silver Contributor
  Sep 18, 2019
  ks0010
  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
    Iron Contributor
    Sep 18, 2019
    Subodh_Tiwari_sktneer
    
    you can also use "Insert"--> "Table" to the desired range so that the headers will be shown as column names

Resources