Office for Mac Issues

Enter Absolute Cell References in Excel on a MacBook Air

Steve KSteve K Nov 12, 2026 869 views

Question details

Learn the Mac keyboard shortcut for changing a cell reference in an Excel formula to absolute or mixed format.

How to Enter an Absolute Cell Reference in Excel on a MacBook Air
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.
Before you start

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.

Solution 1Recommended

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.

1
Start editing the formula

Select the formula cell, then double-click it or click in the Formula Bar to enter edit mode.

2
Select the cell reference

Click a reference such as A1 in the formula, or move the text cursor into that reference.

3
Press Fn+F4

Press Fn+F4 on the MacBook Air keyboard to change A1 to $A$1, which locks both the column and row.

4
Continue cycling if needed

Press Fn+F4 again to change the reference to A$1, then press it again for $A1, and once more to return to A1.

5
Confirm the formula

Press Return to apply the updated formula to the selected cell.

Use Fn+F4 to cycle Excel cell reference types on a MacBook Air
Reference types: $A$1 locks the column and row, A$1 locks only the row, $A1 locks only the column, and A1 remains fully relative.
Work with formulas in WPS Spreadsheets

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. 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. 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. 3. Target the reference: Place the cursor on the reference, such as A1, that you want to lock.
  4. 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. 5. Apply the formula: Press Return to confirm the formula and retain the selected reference format.
Use Fn+F4 or F4 while editing a formula to cycle reference types.Create formulas with absolute and mixed references for repeated calculations.Open, edit, and save Microsoft Excel .xlsx and .xls files.Use a familiar spreadsheet interface for seamless migration from Excel.
QA img-9

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.