In this quick tip article we will show you how to freeze a row in Google Sheets.
Sometimes for usability it helps to freeze one or multiple rows at the top of your Google Sheet. When you have a lot of rows of data, where the user of the Google Sheet needs to scroll, it helps to freeze rows so it is clear what column contains what data.
Before we start you should be aware there is a small limitation. You can freeze the top row of the sheet or any number of rows from the top, but, you cannot specifically freeze one row in the Google Sheet other than the top row. So for example you can freeze row 1 or rows 1-20 but not row 4 individually. Most people will not find this too limiting as the usual use case is to freeze the top row in the Google Sheet.
Let’s start with freezing the top row in your Google Sheet.
Here I have an example Google Sheet with food sales data. When I scroll down the sheet the top row scrolls off the screen too, so when I am viewing data further down the worksheet it is harder for me to understand what column contains what data.
The top 3 rows will now be frozen and visible when you scroll further down the Google Sheet.
How to un-freeze rows in Google Sheets.
If you want to remove the rows you have chosen to freeze, simply go to the View menu at the top of your Google Sheet, then choose the “Freeze” menu option and then choose “No Rows”.
This will remove the “freeze” on all rows in the sheet.