Toggle Between Relative and Absolute Cell References in Excel With F4

BY STANLEY ZAROWIN

Q: My partner says there’s an F4 shortcut to creating absolute cell references in Excel formulas, but for the life of me I can’t make it work. What am I doing wrong?

 

A: Your partner is right, but while I can’t tell you what you’re doing wrong, I can tell you how to do it right.

 

When you type the cell reference in your formula, press F4. For example, in the formula =A6*B7, press F4 right after you type the 6 and the absolute reference $ will appear. Press F4 again after you type the 7—and voìla:

 

Wait, there’s more. If you continue to press F4 when your cursor is just to the right of A6, the formula will toggle between relative and absolute references through four options in this order: A6, $A$6, A$6, $A6.

 

NEWS

IRS sets start date for tax season

The IRS announced that tax season will start in late January and that it will issue refunds to taxpayers despite the partial shutdown of the federal government.

PODCAST

Why CPAs can’t wait on automation tools

What do accounting firms waiting on others to develop AI, automation, and data analytics tools have in common with a baseball fan sitting in a stadium filling with water at an exponential rate? The answer could determine your firm’s fate.