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)

❤️ Is this article helpful?

Buy me a coffee ☕ or support my work via PayPal to keep this space 🖖 and ad-free.

Do send some 💖 to @d_luaz or share this article.

✨ By Desmond Lua

A dream boy who enjoys making apps, travelling and making youtube videos. Follow me on @d_luaz

👶 Apps I built

Travelopy - discover travel places in Malaysia, Singapore, Taiwan, Japan.