What is the switch key between absolute reference and relative reference?

The switching key between absolute reference and relative reference is "F4". After pressing, it will switch from relative reference to absolute reference. Absolute address refers to an address scheme in communications, computers and data processing systems; the jump command of a relative address is short and fast in execution, but its scope is limited.

The operating environment of this tutorial: Windows 7 system, Microsoft Office Excel 2010 version, Dell G3 computer.

The shortcut key for absolute reference in EXCEL is F4. After pressing it, it will be converted into an absolute reference. The F4 key can be converted into absolute address, relative address, and mixed address.

1. Absolute address. Refers to an addressing scheme used in communications, computers, and data processing systems. This address directly identifies a memory location without the use of associated media, such as a base station address or associated addresses.

2. Relative address. The relative address jump command is short and fast in execution, but its scope is limited.

3. Mixed address. Use relative address references in formulas. The reference address (value) changes with the position during formula copying.

Extended information:

Other shortcut keys for EXCEL are introduced as follows:

1. [F1] Activate Excel help function.

2. [F2] puts the current cell into editing state.

3. [F3] Paste the name.

4. [F5] displays the "Location" dialog box.

Related learning recommendations:excel tutorial

The above is the detailed content of What is the switch key between absolute reference and relative reference?. For more information, please follow other related articles on the PHP Chinese website!