How to Lock a Column or Row in Google Sheets

How to Lock a Column or Row in Google Sheets

When you lock (or freeze) a column or row in Google Sheets, it will stay visible while scrolling through your spreadsheet. This can be helpful if you want to always see a specific row or column, no matter how much you scroll.

How to lock a column in Google Sheets

  1. Click on the column header to select the column.

    Column Header
    Select the column header.

  2. Click on View in the top menu, then select Freeze option. From the sub-menu, choose to freeze one or more columns according to your requirements. If you only want to freeze a single column, you can select the 1 column option.

    Freeze Column
    Go to View > Freeze and select the number of columns you want to freeze.

  3. The column(s) you chose will now be frozen in place. You’ll be able to scroll through your data without the columns moving.

    Frozen Column
    The selected columns remain at the same place when you scroll.

How to Lock a Row in Google Sheets

  1. Click on the row you want to lock.

    Row Header
    Select the row header.

  2. Click on View on the top-menu, then select Freeze. From the sub-menu, if you only want to freeze a single row, you can select 1 row.
    Freeze Rows
    From the View menu, select Freeze, then the number of rows to freeze.

    The rows you selected will be frozen, and you’ll be able to scroll through your data without them moving.

    Frozen Rows
    The selected rows are locked in the same place.

Phoebe is an HR assistant in her day job, but is also a web blogger that loves writing guides and sharing her experiences. When she is not out with her friends, she enjoys traveling or binge-watching Netflix. She graduated with a BA in Communication and Media Studies from the University of Utah, and is a chief editor at TechObservatory.

Leave a Comment