💻 Software
Is is possible to get Excel to insert an absolute reference when clicking on cells to build a formula?
Fresh5 days ago
Mar 15, 202618177 viewsConfidence Score0%
0%
Problem
If you build a formula by clicking on a cell to insert its address into the formula, is there a way of making this reference absolute rather than relative? I've been using Excel for many years but never come across a way of doing this. I've tried the obvious SHIFT+ click, CTRL+click and ALT+click.
Unverified for your environment
Select your OS to check compatibility.
1 Fix
Canonical Fix
Unverified Fix
New Fix – Awaiting Verification
Fix for: Is is possible to get Excel to insert an absolute reference when clicking on cells to build a formula?
Low Risk
Click the cell and then hit F4. As you keep hitting F4, it will cycle through various level of absolute. Example: Click the cell A1, type '=', then click the cell B1. Hit F4. The reference to B1 becomes $B$1. Hit F4 again. The reference becomes B$1.…
Awaiting Verification
Be the first to verify this fix
Sign in to verify this fix