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)