In this article we will show you how to freeze multiple rows in google sheets. This allows you to keep rows visible while scrolling so you can easily understand a large data set.
We can freeze multiple rows by applying freeze up to the desired row. We can do this by using the menu method or by utilizing the drag to freeze feature in Google Sheets.
Click here to access our sample spreadsheet and follow along with the tutorial.
In the dataset highlight any cell in the desired row. This is the row we will freeze up to which will freeze multiple rows at the same time. In this example we want to lock all rows up to row 7 so we will select a cell in this row.
From the top toolbar select View followed by Freeze to display the freeze options. Here you will see Up to row (row number). In this example it will state Up to row 7.
You can now scroll and see that the multiple rows up to row 7 are now frozen in place.
The grey line above the label of row 1 is the freeze line. When you hover over this line the cursor turns to a hand icon.
Click and drag the grey line underneath the label of the target row and release to apply the freeze. In this example we will drag the freeze line down to Row 7.
Scroll the page and you will now see the freeze has been applied to every row up to the target row.
