There are multiple ways by which you can free rows in Google Sheets at top. Here are they.

Freeze Rows in Google Sheets Using Shortcut

You can simply freeze rows in Google Sheets with a few clicks using your mouse. You just need to select the rows you want to freeze and follow the steps below. There you have it. First, two rows are now Frozen, allowing an easy view of column heads during scrolling down.

Freeze/Lock Rows Using Google Sheets Menu Option

Instead of dragging and dropping to lock rows in Google Sheets, you can use the Freeze function from the Google Sheets menu. As you can see, the Google Sheets lock row functionality is neat and straightforward to execute.

Unfreeze Rows in Google Sheets Using Shortcut

What if you wish to Unfreeze the rows you did freeze to the top at a later point in time? What is Frozen can be Unfrozen in Google Sheets. Let’s see how to unfreeze locked rows in Google Sheets using mouse shortcut.

Unfreeze Rows Using Google Sheets Menu Option

Like you can freeze rows in Google Sheets, the menu also has the option to unfreeze single row or multiple rows in the spreadsheet. Unfreezing of Rows is complete, and it is an effortless feature that makes the Google Sheets freeze row procedure easily reversible on demand. As discussed here, you can freeze multiple rows in Google Sheets in simple and quick ways. This feature makes viewing large datasets in your spreadsheet rather convenient. It also lets you Freeze and Unfreeze the Columns of spreadsheet data. This aspect makes scrolling and analyzing data horizontally less complicated. Notify me of follow-up comments by email. Notify me of new posts by email.

Δ

How to Freeze Multiple Rows at Top in Google Sheets - 33How to Freeze Multiple Rows at Top in Google Sheets - 66How to Freeze Multiple Rows at Top in Google Sheets - 39How to Freeze Multiple Rows at Top in Google Sheets - 93How to Freeze Multiple Rows at Top in Google Sheets - 50How to Freeze Multiple Rows at Top in Google Sheets - 3How to Freeze Multiple Rows at Top in Google Sheets - 2How to Freeze Multiple Rows at Top in Google Sheets - 65How to Freeze Multiple Rows at Top in Google Sheets - 45How to Freeze Multiple Rows at Top in Google Sheets - 66