Whilst editing a formula, press F4 to toggle the reference type of the cell reference your cursor currently touches. Reference types are:
- Relative (e.g. A1)
- Absolute (e.g. $A$1)
- Row Absolute (e.g. A$1)
- Column Absolute (e.g. $A1)
Excel shortcut: F4
Use F4 to switch between relative and absolute references.
Whilst editing a formula, press F4 to toggle the reference type of the cell reference your cursor currently touches. Reference types are:
Whilst editing a formula, press F4 to toggle the reference type of the cell reference your cursor currently touches. Reference types are:
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment