Mac Excel $ dollar sign shortcut
When formulas, functions, etc. are copied and reused, the problem often occurs that the reference cells are misaligned. This happens because the reference cell is not locked. Using the Mac-specific shortcut keys we will show you, you can copy and paste formulas and functions to another location without shifting the reference cell. Since the keyboards for Windows and Mac input are different, Mac users who wish to lock the reference cell should refer to the following instructions.
Shortcut to fix reference cells on Mac
F4 or command + T
Make reference cells absolute references
This is a Mac shortcut key to make referenced cells absolute references.
Total Time: 1 minute
Select a cell
Select the cell where you want to enter the formula.
Enter the cell to be referenced
Enter = and the cell to be referenced. Here, enter A4 as an example.
Make cells absolute references
Press F4. Add a dollar sign to the referenced cell. This dollar sign represents an absolute reference to a cell.
Enter more reference cells
+ (plus), then enter the cell to be referenced. Here, enter A5 as an example.
Make the cell an absolute reference
Press F4 to add a dollar sign to the reference cell.
Press command + return to confirm, then press command + C to copy the cell.
I could make absolute reference to it
Press → (Right Arrow key) to select the cell in which to paste the copied formula, then press return to paste. By making it an absolute reference, the reference cell does not change even if the formula is pasted elsewhere.