💻 Software
How to copy-paste absolute cell references temporarely as relative references in Excel?
Fresh5 days ago
Mar 15, 202637216 viewsConfidence Score0%
0%
Problem
In Excel (2007), when cells that contain absolute references (for example: ) are copied, the absolute reference remains the same. This is by design, and the reason of using absolute references. Problem -- However, sometimes I want copy a block of cells (that contain absolute and probably also relat…
Error Output
$A$3
Unverified for your environment
Select your OS to check compatibility.
1 Fix
Canonical Fix
Unverified Fix
New Fix – Awaiting Verification
Fix for: How to copy-paste absolute cell references temporarely as relative references in Excel?
Low Risk
you could always try writing a macro for that. excel has a really nice macro recording tool that you could use too, and then just run it as needed (provided you make some changes first of course to the program)
Awaiting Verification
Be the first to verify this fix
Sign in to verify this fix