Learn How to Toggle Absolute and Relative References With Shortcut in Microsoft Excel

Toggle Absolute and Relative References With Shortcut in Microsoft Excel

Here we will show you how to toggle absolute and relative references in Microsoft Excel. Like many other programs Microsoft Excel also uses similar key combinations while using shortcuts.

You can use the key combinations given below to toggle absolute and relative references using the shortcut. When you edit a formula, this shortcut is used to toggle cell references from relative to absolute, to partially absolute, back to relative again as stated below:

B1 --> $B$1 --> B$1-- > $B1-- > B1

This way you perform the operation faster and easier than typing $ characters manually.

It should be noted that, enter cell edit mode to convert the existing formula, place the cursor "in or next" to the reference you'd like to convert, then use the shortcut. For Mac users, you can use fn + F4 to perform this operation. So, here we go:

How to Toggle Absolute and Relative References With Shortcut in Microsoft Excel?

It is used to toggle absolute and relative references in Microsoft Excel. When you edit a formula, this shortcut is used to toggle cell references from relative to absolute, to partially absolute, back to relative again as stated below:

B1 --> $B$1 --> B$1-- > $B1-- > B1

This way you perform the operation faster and easier than typing $ characters manually.

It should be noted that, enter cell edit mode to convert the existing formula, place the cursor "in or next" to the reference you'd like to convert, then use the shortcut. For Mac users, you can use fn + F4 to perform this operation. This way you can easily toggle absolute and relative references using this shortcut.

Check out the list of all other articles:

• Learn How to Get nth Match in Microsoft Excel
• Learn How to Find Missing Values in Microsoft Excel
• Learn How to Get nth Smallest Value With Criteria in Microsoft Excel
• Learn How to Sort by Text Length in Microsoft Excel
• Learn How to Sort by Two Columns in Microsoft Excel
• Learn How to Sort by Random in Microsoft Excel
• Learn How to Sort by One Column in Microsoft Excel
• Learn How to Sort by Custom List in Microsoft Excel