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.

 

Where to find December’s flipbook issue

The Journal of Accountancy is now completely digital. 

 

 

 

SPONSORED REPORT

Get Clients Ready for Tax Season

This comprehensive report looks at the changes to the child tax credit, earned income tax credit, and child and dependent care credit caused by the expiration of provisions in the American Rescue Plan Act; the ability e-file more returns in the Form 1040 series; automobile mileage deductions; the alternative minimum tax; gift tax exemptions; strategies for accelerating or postponing income and deductions; and retirement and estate planning.