How to Freeze 3 Rows in Google Sheets (2 Quick Ways)

Suppose you are working on a dataset where you need to input data every day and the dataset is getting larger every day. In this case, it is a matter of time that if you scroll down the dataset then the header row will be lost. Once the dataset is larger, it will be difficult to operate and very time-consuming as well. But if you freeze your rows then the rows will be locked and if you scroll down the data will remain there. In this article, we will learn how to freeze 3 rows in google sheets.

The overview of how to freeze 3 rows in google sheets

Here is the overview of this article, you will learn better once you go through the total article.

A Sample of Practice Spreadsheet

You may copy the spreadsheet below and practice by yourself.

2 Simple Ways to Freeze 3 Rows in Google Sheets

The below dataset contains Department, Total Employee, and Working Hour. That means this dataset represents the total employees of every department and their working hours This table is a schedule table. If you want to meet anyone then you can go through this table and you know the working hour of that employee.

The dataset of how to freeze 3 rows in google sheets

1. Using Menu Bar

Now, we will freeze 3 rows so that the top row always remains visible after scrolling using the following dataset that represents the working hour of different teams in a company. Say, we need to freeze the top so that it always stays at that place and the dataset is easy to operate.

📌 Steps:

  • First, select three rows from the dataset. Put the cursor at the very top left side of the dataset.
  • Then click on the cell number as the third cell number is three. So select 3.

selecting cell

  •  Select the row number then google sheets will select the entire row as shown before.
  • Afterward, select View >> Freeze >> Up to row 3 to freeze the rows till 3.

frezzing from menu bar

  • we can also execute this same process using the keyboard shortcut. As this process is convenient and time-saving at the same time.
  • To do this, press ALT + V, and the View pane will pop up.

Keyboard shortcut

  • Now the View pane will pop up now select freeze as shown before.
  • Finally, the data is frozen and the final output is below.

The output of how to freeze 3 rows in google sheets

2. Dragging Mouse

We can also use the mouse to execute freeze rows. This simple way will save you time. This process is quite simple. There is a Row Pane in every google sheet. The row pane is a line in the most top left side shown in the picture.

Showing row pane

📌 Steps:

  • Select the Row Pane and drag it down to the 3rd row as below to freeze 3 rows.

Dragging down the row pane

  • Lastly, the final output is below.

Another output

Read More: How to Freeze Panes in Google Sheets (3 Simple Ways)

Things to Remember

  • If you merge the rows already then you cannot freeze just one row. First, you have to unmerge the row then you can freeze the row.
  • Also, you can not lock merged and unmerged cells together. You need to unmerge the cells if you want to lock the cell.


In this article, we explained how to freeze 3 rows in google sheets step by step. Hopefully, this procedure will help you apply this method to your dataset. Please let us know in the comment section if you have any further queries or suggestions. You may also visit our OfficeWheel blog to explore more Google Sheets-related articles.

Related Article



This is Afrina Nafisa. Currently working as a Technical Writer at OFFICEWHEEL.COM. I have done my graduation from Ahsanullah University of Science and Technology. As I am eager to learn more and more currently my motive is to make myself better every day with my work so that I can make better content for all the readers.

We will be happy to hear your thoughts

Leave a reply