Excel Hack

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

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 a cell

Select the cell where you want to enter the formula.

Enter the cell to be referenced

Enter the cell to be referenced

Enter = and the cell to be referenced. Here, enter A4 as an example.

Make cells absolute references

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

Enter more reference cells

+ (plus), then enter the cell to be referenced. Here, enter A5 as an example.

Make the cell an absolute reference

Make the cell an absolute reference

Press F4 to add a dollar sign to the reference cell.

Copy formula

Copy formula

Press command + return to confirm, then press command + C to copy the cell.

I could make absolute reference to it

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.

Comments

Please send us your comments on this article.

0 comments
Inline Feedbacks
View all comments