Enter Absolute Cell References in Excel on a MacBook Air
Question details
Learn the Mac keyboard shortcut for changing a cell reference in an Excel formula to absolute or mixed format.

- Product
- Microsoft Excel for Mac
- Device & OS
- macOS
- Scenario
- The user is editing a formula on a MacBook Air and needs to lock a row, column, or both in a cell reference.
- Observed behavior
- The desired result is to cycle a reference through A1, $A$1, A$1, and $A1 without typing dollar signs manually.
Open the formula in the cell or Formula Bar and place the insertion point on the reference you want to change. If your Mac is set to use F1–F12 as standard function keys, use F4 instead of Fn+F4.
Use Fn+F4 to cycle Excel cell reference types on a MacBook Air
Use this method while creating or editing a formula when you need to make a reference absolute or mixed.
Excel changes the active cell reference each time you press Fn+F4: A1, $A$1, A$1, and $A1. Command+F4 is not the Excel shortcut for reference locking and can trigger a macOS action instead.
Select the formula cell, then double-click it or click in the Formula Bar to enter edit mode.
Click a reference such as A1 in the formula, or move the text cursor into that reference.
Press Fn+F4 on the MacBook Air keyboard to change A1 to $A$1, which locks both the column and row.
Press Fn+F4 again to change the reference to A$1, then press it again for $A1, and once more to return to A1.
Press Return to apply the updated formula to the selected cell.

Lock Cell References Quickly in WPS Spreadsheets for Mac
WPS Spreadsheets lets you edit formulas and switch relative, absolute, and mixed references while working on a Mac. Use the familiar formula-editing workflow to lock the rows or columns needed for copied formulas.
- 1. Open the workbook in WPS Spreadsheets: Launch WPS Office on your Mac and open the Excel .xlsx or .xls workbook in WPS Spreadsheets.
- 2. Edit the formula cell: Select the cell containing the formula, then click the Formula Bar or double-click the cell to edit it.
- 3. Target the reference: Place the cursor on the reference, such as A1, that you want to lock.
- 4. Toggle the reference format: Press Fn+F4 to cycle among A1, $A$1, A$1, and $A1. If your function keys are configured as standard keys, press F4.
- 5. Apply the formula: Press Return to confirm the formula and retain the selected reference format.

Frequently Asked Questions
What does Fn+F4 do in an Excel formula on a Mac?
While you are editing a formula and the cursor is on a cell reference, Fn+F4 cycles that reference through A1, $A$1, A$1, and $A1.
Why does Command+F4 not make my Excel reference absolute?
Command+F4 is a macOS shortcut rather than Excel's reference-toggle command. Edit the formula and use Fn+F4, or F4 when standard function keys are enabled.
How do I lock only a row or only a column in Excel for Mac?
Use Fn+F4 repeatedly while the reference is active. Stop at A$1 to lock the row only, or at $A1 to lock the column only.
Can I type an absolute reference manually in Excel?
Yes. In the Formula Bar, type dollar signs before the parts you want to lock: $A$1 for both, A$1 for the row, or $A1 for the column.




