Windows Mac
F4 ⌘T

About This Shortcut 

While editing a formula, this shortcut toggles cell references from relative to absolute, to partially absolute, back to relative again:

A1 --> $A$1 --> A$1-- > $A1-- > A1

This is much faster and easier than typing the $ character manually.

To convert an existing formula, enter cell edit mode, place the cursor in or next to the reference you'd like to convert, then use the shortcut.

Note: In earlier versions of Excel on the Mac, this shortcut is exclusively Command + T. In Mac Excel 365, fn + F4 also works, inline with the Windows version of Excel.

Related videos

Excel What are Dynamic Array formulas?

What are Dynamic Array formulas?

In this video, I'll explain the basic idea of dynamic array formulas. Dynamic Array formulas are the biggest change to the Excel formula engine in years. Maybe the biggest change ever. This is because Dynamic Arrays make it easy to work with many values at the same time. For many users, this will be …
Excel How to use SUMIFS with an Excel Table

How to use SUMIFS with an Excel Table

In this video, we'll look at how to use the SUMIFS function with an Excel Table. On this worksheet, I have two identical sets of order data. I'm going to walk through the process of constructing a summary of sales by item for both sets of data. With the data on the left, I'll use standard formulas …
Excel How to build a 100% stacked chart with percentages

How to build a 100% stacked chart with percentages

In a previous video, we built a 100% stacked column chart, and added data labels to show actual amounts in an abbreviated custom number format. The result is a chart that shows a proportional breakdown of each quarter by region. Looking at the chart, you might wonder how to show the actual …
Excel How to generate random values

How to generate random values

In this video we'll look at a few ways to generate random values with the RANDBETWEEN function. The RANDBETWEEN function is a simple function you can use to generate random numbers. For example, I can enter RANDBETWEEN with a bottom value of 1 and a top value of 100. When I press Enter, I get a …
Excel How to find missing values with COUNTIF

How to find missing values with COUNTIF

In this video we'll take a look at how to use the COUNTIF function to solve a common problem: how to find values in one list that appear in another list. Or, how to find values in a list that don't appear in another list. Let's take a look. In this worksheet, on the left, I have a list of 20 names. …
Excel Shortcuts for formulas

Shortcuts for formulas

In this video, we'll look at shortcuts for working with formulas. Even basic formulas require absolute and relative references, so one of the most useful formula shortcuts is the toggle for references. For example, to complete this multiplication table, we need to multiply the left column by the top …
Excel How to create a mixed reference

How to create a mixed reference

So what's a mixed reference? A mixed reference is a reference that's part relative and part absolute. Let's take a look. So, we've looked at both relative and absolute references, and also at a situation where we needed to use both at the same time. These are sometimes called "mixed references." A …
Excel How to make an exact copy of a formula

How to make an exact copy of a formula

When you copy and paste formulas, Excel will change all relative references to reflect the new location of the formula. Usually, this is exactly what you want. However, there are times when you'll want to copy a formula exactly so that cell references don't change. Let's take a look at a few ways to …
Excel How to use HLOOKUP

How to use HLOOKUP

In this video, we'll look at how to use the HLOOKUP function. HLOOKUP works just like VLOOKUP, but instead of getting the value of an item from a certain column in a table, HLOOKUP gets a value from a certain row in a table. Let's take a look. Here's the VLOOKUP commission example we've looked at …
Excel What's an absolute reference?

What's an absolute reference?

An absolute reference is a cell reference that intentionally won't change when a formula is copied. There are many situations where absolute references are helpful. Probably the most common case is where you want to use a value in a specific cell in multiple calculations. This might be an hourly …

Support Exceljet

Many websites (including Exceljet) have lost over half their traffic in the past year because of the crushing impact of AI on web searches. Exceljet is still at it, publishing free content each week. If you find Exceljet helpful, you can support the site and go ad-free with the Exceljet Lifetime Pass. One payment, no subscription, and ads are gone forever. Plus, you get our Excel Shortcuts video course as a thank you.

Get the Lifetime Pass

Dave Bruns Profile Picture

AuthorMicrosoft Most Valuable Professional Award

Dave Bruns

Hi - I'm Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.