Introducing G2.ai, the future of software buying.Try now
  1. Home
  2. ...
  3. Spreadsheets Software
  4. Microsoft Excel
  5. Microsoft Excel Discussions
  6. What is the best way to pin rows in a data set? How do I lock a given cell into place?
Nicole B.
NB
Sales Assistant at Iowa Public Radio
Expand/Collapse Social Share Options

What is the best way to pin rows in a data set? How do I lock a given cell into place?

When I try to pin rows in a table, I can't seem to lock the cells. In other words, I want to be able to freeze or pin a given row at the top of the interface so that it doesn't fall out of view when I scroll down the length of the data set.
1 comment
Looks like you’re not logged in.
Users need to be logged in to answer questions
Log In
JS
IT Manager
0
If I recall correctly: go to the “View” tab. In there you should find “Freeze Panes” those options are how you can lock rows in place while scrolling around a spreadsheet :)
deleteedit
Looks like you’re not logged in.
Users need to be logged in to write comments
Log In
Reply
Already have Microsoft Excel?

About Microsoft Excel

Discover More