167k views
5 votes
What happens by default when you copy a formula from one cell to another cell?

1 Answer

4 votes
By default, all cell references are relative references. When copiedacross multiple cells, they change based on the relative position of rows and columns. For example, if you copy the formula =A1+B1 from row 1 to row 2, the formula will become =A2+B2.
User Lisbet
by
6.3k points