Google Sheets Lock/Freeze Part of Cell Formula Reference When Copy Cells or Rows

May 26, 2019
Prevent Rows or Columns Reference Change

Assume you are referring to =A1.

  • When you copy the cell to next row, it will automatically refering to next row as =A2.
  • When you copy yhe cell to next column, it will automatically refering to next column as =B1

Lock Column or Row or Both.

  • To make sure it always refer to =A1, use =$A$1.
  • To lock row only, use =A$1. Copy to next row will refer to =A$1 (same), copy to next column will refer to =B$1 (next column)
  • To lock column only, use =$A1. Copy to next row will reger to =$A2 (next row), copy to next column will refer to =$A1 (same)
This work is licensed under a
Creative Commons Attribution-NonCommercial 4.0 International License.