How To Freeze Rows And Columns On Google Sheets

Whereas utilizing Sheets, it’s possible you’ll really feel the necessity to lock particular rows or columns whereas scrolling by means of the grid. Google Sheets has the function the place you possibly can lock rows and columns from the Freeze software. Utilizing this function, you possibly can freeze the highest and vary of rows/columns from the highest.

When you’re inquisitive about utilizing this function, this text is your information! Keep studying to study more about how one can freeze rows and columns in Google Sheets!

Why Freeze Rows and Columns?

Whereas scrolling by means of your sheets, you’ll have seen that the rows and columns to the left disappear as you scroll throughout the sheets. Equally, those on high disappear as you scroll down. This may be bothersome in case your heading is on the highest rows/columns.

While you freeze the rows/columns, Sheets locks the alignment, so the row/column is all the time on show once you scroll by means of the grid. You’ll be able to freeze particular rows/columns when you may have the knowledge you want to view each time you scroll by means of your sheet.

How to Freeze Rows and Columns on Google Sheets?

There are two methods you possibly can freeze rows and columns on Google Sheets. You would both use the Freeze software from this system or use your mouse to regulate the divider within the grid to pin the rows and columns.

Utilizing Freeze Instrument

Google Sheets has a devoted software to freeze your required alignment. Utilizing this software, you possibly can freeze both the highest alignment or a number of rows and columns from the highest to the chosen alignment. Confer with the next steps to make use of the Freeze software on Google Sheets to pin your alignment:

1. Open your paperwork from Google Sheets.
2. From the doc, choose View from the menubar.
   
3. Choose Freeze.
   
4. From the fly-out menu, to freeze rows, choose both:
   • 1 Row: Freezes the highest row.
   • 2 Rows: Freeze the highest two rows.
   • As much as row X: Freeze the rows from the highest to the row with the chosen cell.
     

5. When you want to freeze columns, choose both:
   • 1 column: Freezes the highest column.
   • 2 columns: Freezes the highest two columns.
   • As much as column X: Freezes the columns from the highest to the chosen cell.
     

Modify the Divider

Google Sheets has a gray divider resting on the top-right nook of the grid. You’ll be able to drag the slider proper below the alignment you want to freeze. Observe these steps to freeze your required dataset from the Google Sheets grid:

1. Open the doc with the alignment you wish to freeze.
2. Head to the top-left nook of the grid.
3. Place your cursor over the grey divider and look ahead to the icon to alter right into a hand.
   
4. Drag the slider and launch it below the row or column you want to freeze.
   

How to Unfreeze Rows and Columns?

Let’s assume you modified your thoughts about pinning the alignment. You’ll be able to unfreeze them simply from the Freeze software. Observe together with these steps to unfreeze your pinned rows and columns out of your Google Sheets grid:

1. Out of your doc, choose View from the menubar.
   
2. Choose Freeze.
   
3. From the fly-out menu, to unfreeze rows choose No Rows. To unpin columns, select No Columns.
   

How to Freeze Rows and Columns Concurrently?

While you freeze a specific alignment in Google Sheets, Google Sheets pins it on high. Because of this the frozen row or column will all the time be on show even once you scroll by means of the grid on Google Sheets

You’ll be able to freeze the rows and columns concurrently utilizing the Freeze software in Google Sheets. Confer with the next steps if you happen to want to freeze each the rows and columns from the Google Sheets grid:

1. From the Google Sheets doc, choose View from the menubar.
   
2. Choose Freeze.
   
3. Select an possibility relying on the variety of rows you want to freeze.
4. Repeat steps 1 and a couple of, then choose the variety of columns you wish to pin within the grid.