💻 Software
Excel: autofill formulas in lists
Fresh6 days ago
Mar 15, 2026921 viewsConfidence Score0%
0%
Problem
I have a rather huge Excel sheet where the first 20 columns contain input data, further 15 columns contain formulas which use the input data for calculations. I frequently remove the entire input data set and replace it with a new one, the input data volume varies and ranges anywhere from 4.000 to …
Unverified for your environment
Select your OS to check compatibility.
1 Fix
Canonical Fix
Unverified Fix
New Fix – Awaiting Verification
Fix for: Excel: autofill formulas in lists
Low Risk
To add rows, you can just select the last cell in each formula column and double-click the bottom right hand corner, just like you were going to drag, but double-click instead. This will fill the formulas down to match the values to the left. Before…
Awaiting Verification
Be the first to verify this fix
Sign in to verify this fix