Welcome to the TechVin, today in this article, You are going to learn How to Freeze a Row in Google Sheets step by step. It is too easy to freeze a row in Google Sheets in comparison to the excel. You are going to learn How to freeze or unfreeze the rows and columns in google sheets. If you want to freeze a row in spreadsheets of google sheets then just read this article carefully to know How to Freeze a Row in Google Sheet.
Google Sheets provides all the tools and features for free of cost but you have to use it online. You can also use it Offline if you have saved your spreadsheet or file to make available offline. If you don’t know how to save it offline for work then we have described it in the last of the article. Firstly you have to learn How to freeze a row in Google Sheets. We have described all the ways to freeze the rows and columns in google sheets. You have to just learn those ways and increase the skill of google sheets.
Table of Contents
How to Freeze a Row in Google Sheets
Firstly, we are going to learn How to freeze a row in google sheets step by step. It is much easy to freeze a row in google sheets. If you don’t have data to practice this process of freezing then you can download the spreadsheet. If you want to download then you have to click on the below text to download it.
Click to Download ⇒ The TechVin Spreadsheets
Now let’s start the process
- Firstly you have to open the Google sheets on your desktop. You can click on Open Google Sheets to directly open the google sheet on your PC.
- Now you have to open the spreadsheet in which you want to freeze a row. If you don’t have a spreadsheet then download our’s sheet and do move on the next step.
- In the sheet, you have to click on the view tab in the upper menu bar.
- A drop-down menu will open in which you have to click on the freeze option. It is first in the dropdown menu.
- The second dropdown menu will open in which you have to click on the option of 1 row and it is second in the list.
- Now you can see that the first row of your sheet is now frozen.
You can scroll down your sheet to check it.
How to Unfreeze a Row in Google Sheets
If you want to unfreeze a row in google sheets then you the steps are almost the same. There is a difference in only the last step. So let’s see How can you unfreeze a row in google sheets.
- In the spreadsheet, You have to click on the view tab of the menu bar.
- In the dropdown menu, you have to click on the option of the freeze.
- After that, you have to click on No rows, the first option in the second dropdown menu.
- Now your row is unfrozen.
Use Shortcut to Freeze Rows in Google Sheets
There is a shortcut also available in google sheet to freeze rows and columns. You have to just follow these easy steps to learn how to freeze rows in google sheets using shortcuts.
- Firstly you have to open the google sheets on your PC.
- Now you have to open the spreadsheet in which you want to freeze the rows and columns.
- In the spreadsheet, you have to move your cursor in the top left corner. You have to move your cursor on the grey box which is available on the upper side of the serial number. A hand ‘✋‘ icon replaces the + icon when reaching the line.
- When this hand icon ‘✋‘ comes then you have to left-click on your mouse and drag it to the row which you want to freeze.
- If you want to freeze the column then you have to put your cursor on the midline of this grey box and latter A. After that you have to drag it to the column which you want to freeze.
Once you have complete these easy steps then you can freeze rows and column in google sheets.
How to Freeze Multiple Rows in Google Sheets
If you have a sheet in which you have two or more rows as a title or heading. In this condition, You have to freeze the multiple rows in google sheets. So if you want to learn this process then follow these easy steps to freezing the multiple rows.
- Firstly you have to open the google sheets on your PC.
- In the google sheets, you have to open the spreadsheet in which you want to freeze multiple rows. You can also use our sheet to practice it.
- You have to click on the cell which you want to freeze all the rows which are above from this cell. Like if you want to freeze the first two rows then you have to click on the cell of the third row.
- Now you have to click on the view tab in the menu bar.
- A dropdown menu will open in which you have to click on the option of the freeze.
- The second dropdown menu will open.
- If you want to freeze only two rows then click on 2 rows.
- If you want to freeze more rows then click on up to the current row.
- Now, this process is complete of freezing the multiple rows.
You can also freeze multiple rows using the shortcut which we have described in this article.
How to Simultaneously Freeze Rows and Columns
If you have a sheet in which you have headings and titles in rows and columns both then you need to freeze rows and columns simultaneously. If you want to freeze rows and columns simultaneously then you have to follow this easy process.
There is no direct way to freeze row and column simultaneously in google sheets. You have to freeze one by one both row and column. You can use any upper way to freeze row and column both.
Firstly you have to freeze the row and then column. If you will use the shortcut then this work of only 10 seconds or less.
Important information
All the upper ways show How to Freeze a row in Google sheets and not only one row. After reading this article, you can freeze as many rows and columns you want. If you have read the complete article then you can freeze any cell row which you want to freeze. And we hope that you read all the ways to rows and columns. You have to just understand the process. Now you can start your work on your spreadsheet. But before that please read these last words if you have time.
Any more difficulties remain which we didn’t describe in this article then you can comment in the below comment section. We will try to reply you as soon as possible and will help you to solve your difficulty.
You can also search for your problems in the search box which is available on our website. If you have regular work on google sheet and google docs then you can read the articles on our website. We have free tutorials on Google Docs, Google Sheets, and MS Office. You have to just click on the MS Office in the menu bar on our website. When you click, after that you can explore lots of tutorials. Read those articles and increase your skill and knowledge.
You can also follow us on social media to get the latest updates on new tutorials. You have to just click on the social media icons which are available on our website.
Thanks for reading, We hope that you have learned How to Freeze a Row in Google Sheets Easily and fastly. You need to just learn and practice the ways that we have defined in this article.
Leave a Reply