Excel shortcuts

How to create an absolute reference in Excel for Mac

If you're using Microsoft Excel on a Mac, you might be wondering how to create an absolute reference. An absolute reference is a cell reference that doesn't change when you copy or move a formula. This can be useful if you want to reference a specific cell in a formula, and you don't want the reference to change if you copy the formula to another cell.

Here's how to create an absolute reference in Excel for Mac:

  1. Open the Excel document that you want to work with.
  2. Click on the cell that you want to make an absolute reference.
  3. Type the equal sign (=) to start the formula.
  4. Click on the cell that you want to reference. This will insert a cell reference into the formula.
  5. Press the Fn + F4 keys to make the reference absolute. The cell reference will change from a relative reference (e.g. A1) to an absolute reference (e.g. $A$1).
  6. Type the rest of the formula, then press Enter to complete it.

That's all there is to it! Now you know how to create an absolute reference in Excel for Mac.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.