How To Anchor Cells In Google Sheets

In this tutorial, you will learn how to anchor cells in Google Sheets.

How To Anchor Cells In Google Sheets

If you work with large datasets in Google Sheets, you’ll have experienced the frustration of scrolling down in your spreadsheet and then not remembering which column is which after the headers scroll out of view:

Fortunately, Google Sheets allows you to freeze or anchor rows so they remain in view even when you scroll, making it much easier to interpret your data

Freezing Rows Using the Menu

To prevent a row or rows at the top of your spreadsheet from scrolling, follow these steps:

Step 1

Select the last row you want to freeze. The selected row and all rows before it will be frozen

Step 2

Open the View menu and hover over the Freeze submenu, then select the Up to Current Row option

Step 3

The selected row and any rows before it will now be frozen and will not scroll when you scroll through your spreadsheet.

You can see which lines are frozen because a light grey line separates the frozen rows from the unfrozen rows:

Freezing Rows By Dragging

There is also a shortcut for freezing rows in Google Sheets:

Step 1

In the upper left corner of the spreadsheet where the column letters meet the row numbers, there is a small, empty box.

Find the heavy grey line that forms the boundary between this box and the row 1 label:

Step 2

Click and drag this heavy grey line down and you’ll see a grey line appear spanning across the columns of your spreadsheet.

All rows above this line will be frozen and all rows below will continue to scroll. Drag the line to where you want it and release to freeze the rows:

Unfreezing Rows

If you want to unfreeze rows, follow these steps:

Step 1

Open the View menu and hover over the Freeze submenu, then select the Up to Current Row option

Step 2

You can also use the dragging method described above to drag the grey divider line back up to the top of the spreadsheet:

 

Freezing Columns

In addition to freezing rows at the top of your spreadsheet, you can also freeze columns on the left side of your spreadsheet.

Then when you scroll to the right, those columns will remain pinned to the size and in view.

To freeze columns:

Step 1

Select the last column you want to freeze. All columns to the left of this column will be frozen

Step 2

Open the View menu and hover over the Freeze submenu, then select the Up to Current Column option

You can also use the dragging method described above to freeze columns by dragging the heavy grey line on the left side of the column A label to the right

Summary

Example Spreadsheet: Make a copy of the example spreadsheet

In this tutorial, I covered how to anchor cells in Google Sheets. Want more? Check out all the Google Sheets Tutorials.