How to freeze multiple rows in Google Sheets
You can watch a video tutorial here.
![](https://spreadcheaters.com/wp-content/uploads/Final-Image-How-to-freeze-multiple-rows-in-Google-Sheets.png)
Freezing is commonly used when scrolling through large amounts of data on a worksheet. You can freeze multiple rows either to compare rows in distant sections of the worksheet or to keep header rows in place while scrolling down.
Step 1 – Navigate to the Freeze menu
![](https://spreadcheaters.com/wp-content/uploads/Step-1-–-How-to-freeze-multiple-rows-in-Google-Sheets.png)
– Place the cursor in the row up to which the rows are to be locked
– Go to View > Freeze
– Select Up to row 5
Step 2 – Check the result
![](https://spreadcheaters.com/wp-content/uploads/Step-2-–-How-to-freeze-multiple-rows-in-Google-Sheets.png)
– Scroll down to check that the column header stays in place