What types of addresses are there in EXCEL? What's the difference?

Addresses include: relative address, absolute address and mixed address. Difference: In formulas, relative addresses are used, and the reference addresses change with the position during the formula copying process; absolute addresses are used, and the reference addresses remain unchanged during the formula copying process; mixed addresses are used, and those in the form of $A1 and $A2 are "vertical changes." The row number remains unchanged horizontally", and those in the form of B$1 and B$2 are "the column number remains unchanged vertically when changing horizontally".

In Excel, there are three types of cell addresses, namely relative addresses, absolute addresses and mixed addresses.

1. Relative address: A1,A2,B1,B2,...

Features:

Use relative address reference in the formula, During the formula copying process, the reference address (value) changes with the position; for example, if "=A1" in C1 is copied to C2, the formula will automatically become "=A2". If copied to D1, the formula will become "=B1", reflecting Relative references are used in formula copying - horizontal copying changes column numbers, and vertical copying changes row numbers.

2. Absolute address: $A$1,$A$2,$B$1,$B$2,...

Features:

Use absolute address references in formulas, and the reference addresses (values) remain unchanged during formula copying. For example, if "=$A$1" in C1 is copied to any position, it will be "=$A$1".

3. Mixed addresses: $A1,$A2,B$1,B$2,...

Features:

is used in formulas Mixed reference, $A1 and $A2 only have line numbers when copying formulas vertically. For example, when "=$A1" in C1 is copied to C2, the formula changes to "=$A2", but when copied to D1, it is still "=$A1" , that is to say, a mixed reference in the form of $A1 and $A2 "changes the line number vertically and remains unchanged horizontally". B$1 and B$2 are just the opposite. In the formula copy, "the column number changes horizontally but does not change vertically".

Being familiar with the characteristics of copying various references in formulas will effectively improve the accuracy of formula editing.

Related learning recommendations:excel basic tutorial

The above is the detailed content of What types of addresses are there in EXCEL? What's the difference?. For more information, please follow other related articles on the PHP Chinese website!