# 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.

##### Post Metadata
- Posted at: about 6 years ago
- Author title: Sales Assistant at Iowa Public Radio



## Comments
### Comment 1

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 :) 

##### Comment Metadata
- Posted at: over 4 years ago
- Author title: IT Manager




## Related Product
[Microsoft Excel](https://www.g2.com/products/microsoft-excel/reviews)

## Related Category
[Spreadsheets](https://www.g2.com/categories/spreadsheets)

## Related discussions
- [How well does Trello scale into a larger team?](https://www.g2.com/discussions/1-how-well-does-trello-scale-into-a-larger-team)
  - Posted at: about 13 years ago
  - Comments: 6
- [Can we please add a new section](https://www.g2.com/discussions/2-can-we-please-add-a-new-section)
  - Posted at: about 13 years ago
  - Comments: 0
- [Quantifiable benefits from implementing your CRM](https://www.g2.com/discussions/quantifiable-benefits-from-implementing-your-crm)
  - Posted at: about 13 years ago
  - Comments: 4