- Excel Shortcut: Toggle absolute and relative references | Exceljet!
- Was this information helpful?.
- All replies.
- Worksheets and Workbooks?
- Continue with the financial modelling course extract on Excel keyboard shortcuts?
Yes, you've got the idea. Excel remembers the case when you first type a name and converts all references to the same case, but the names are case insensitive.
Because of this and because Excel puts functions in all caps, it's helpful to put your named cells in TitleCaps. Ars Legatus Legionis et Subscriptor.
Google Sheets (Mac) keyboard shortcuts
Press F4 after you type the cell reference. Ars Praefectus et Subscriptor.
The F4 key in Excel for Windows is normally a shortcut key to Repeat the last command. In Excel for Mac the F4 key is assigned to the Paste command, which is driving me crazy so I decided to do something about it.
Shortcut key to switch between relative, absolute and mixed references
The Excel F4 button will now work with the Redo command, which is similar to how Excel for Windows is setup. Note: You have to make this change to each version of Excel for Mac.
Unfortunately this does not work as repeat in Excel This is almost always what you want. If you copy a cell that has a named reference in its formula, the copied formula contains a reference to the original name.
If you have any questions or suggestions, please feel free to ask OfficeToolTips team. Shortcut key to switch between relative, absolute and mixed references Excel You can enter nonrelative references absolute or mixed manually by inserting dollar signs in the appropriate positions, or you can use a handy shortcut - F4 key.