In this article we will show you how to freeze cells in google sheets using either the drag bar or the menu feature. Spreadsheet users commonly freeze cells to keep cells visible when scrolling and to prevent cells from being edited.
This method involves moving the drag bar to freeze the topmost rows or the leftmost columns.
You can find a pair of drag bars on the upper-left corner of the sheet. Its color changes to blue when you move the cursor over it. You can use it to either freeze a row or a column: the horizontal drag bar is for freezing rows while the vertical drag bar is for freezing columns.
For our example we will move the cursor to the horizontal drag bar.
Click the drag bar, then drag it either downward (if you want to freeze top rows) or drag it to the right (if you want to freeze leftmost columns). Note that the drag bars are limited in the directions you can drag them to: horizontal drag bars can only be moved up and down while vertical drag bars can only be moved left and right.
You now know how to freeze cells in Google Sheets.
This method involves using the Freeze option under View option in the main menu.
You can use the following options to freeze the cells:
For this step, we select Up to row 1.
The output will look like as follows:
No, not with these methods. if you try Method 2 while selecting cells in the middle of the sheet, Google Sheets will still freeze starting on the first row or column, as you can see in the screencap below. However, you can check out our tutorial to lock cells in Google Sheets to learn how to any cells or ranges in your spreadsheet.
We hope this article has helped you and given you a better understanding of how to freeze cells in Google Sheets. You might also like our articles on how to lock a column in Google Sheets and how to use the Google Sheets INDIRECT function.
On a side note, we also recommend reading our guide on how to have Google Sheets send an email when a cell value changes.
