What are the ways to reference cell addresses in excel 2010?

What are the ways to reference cell addresses in excel 2010?

The ways to reference cell addresses in excel 2010 are:

1. A1 is a relative reference: when you drag the reference down, it will become Quote A2, A3, A4.

2. $A1 is an absolute reference column and a mixed reference: when you want to ensure that only the A1 cell is referenced when pulling down and copying, A1 must add the $ symbol. A$1.

3. A$1 is an absolute reference row and a mixed reference: when you want to ensure that only the A1 cell is referenced when copying from the right, A1 must add the $ symbol. into $A1.

4. $A$1 is an absolute reference to rows and columns. It is an absolute reference: when you want to ensure that only cell A1 is referenced when copying in pull-down and right-click, A1 Just add the $ sign to become $A$1.

Recommended tutorial: "excel basic tutorial"

The above is the detailed content of What are the ways to reference cell addresses in excel 2010?. For more information, please follow other related articles on the PHP Chinese website!