How To Freeze Row In Google Sheets

To freeze a row in Google Sheets, you need to select the row you want to freeze, go to the “View” menu, choose “Freeze” and then click on “1 row” option.

Google Sheets is a powerful and versatile tool that allows users to collaborate on spreadsheets in real-time. Whether you’re managing business data, organizing personal finances, or analyzing sales figures, Google Sheets offers a wide range of features to make your work more efficient. One such feature that can greatly enhance your spreadsheet experience is the ability to freeze rows. In this blog post, we will explore the various ways to freeze rows in Google Sheets, from freezing a single row to freezing multiple rows, and how this can be a game-changer when working with large sets of data. So let’s dive in and discover how to effectively freeze rows in Google Sheets.

How To Freeze Row In Google Sheets: Step-by-Step


Step 1: Open Google Sheets

Once you’re in your web browser, navigate to for accessing Google Sheets. Locate and open the desired sheet where you intend to freeze a specific row.

Next Step

Step 2: Select Sheet

To choose and open the spreadsheet that contains the row you want to freeze, locate the file in your computer’s file explorer or cloud storage, and double-click on it to open it in your spreadsheet software.

Next Step

Step 3: Select the rows

Click on the number of the row you want to freeze. Once selected, the row will be highlighted, allowing you to keep it fixed while scrolling through the rest of the spreadsheet.

Next Step

Step 4: Go to “View”

Once you’ve selected the row, navigate to the menu bar at the top of the page and click on ‘View’ to access additional options and settings.

Next Step

Step 5: Select Freeze

Under the ‘View’ tab, locate the ‘Freeze’ option, which will trigger the opening of a side menu.

Next Step

Step 6: Freeze the row

From the side menu, choose the number of rows you want to freeze, like ‘No rows’, ‘1 row’, or ‘Up to current row (2, 3, 4, etc.)’. Simply select the option that best fits your needs, such as ‘1 row’ to freeze the first row.


In conclusion, learning how to freeze rows in Google Sheets can greatly enhance your experience when working with large spreadsheets. It allows you to keep important information visible at all times, even when scrolling through a long document. Whether it’s the header row, a key formula, or any other data you need to reference frequently, freezing rows ensures easy access and improved productivity. With just a few simple steps, you can make your spreadsheet navigation more efficient and save precious time. Take advantage of this powerful feature in Google Sheets and make your data management a breeze.

Table of Contents