💻 Software
Extending formulas to a large number of rows in a column
Fresh5 days ago
Mar 15, 202620508 viewsConfidence Score0%
0%
Problem
I have an Excel sheet with one of the columns having around 25000 entries. Now, I create a new sheet – say – and I have a simple formula like this in the first column of . I went to the first row and entered Now I dragged this down to the entire 25000 rows to copy the entire column from the first s…
Error Output
=Sheet1!C2
Unverified for your environment
Select your OS to check compatibility.
1 Fix
Canonical Fix
Unverified Fix
New Fix – Awaiting Verification
Fix for: Extending formulas to a large number of rows in a column
Low Risk
If I understood you correctly, you're trying to copy a formula 25,000 rows down. You can use the Name box to do this quickly. Assuming has the formula With Sheet2 active, type into the Name Box and then press Enter. This will select cell . Press Ctr…
Awaiting Verification
Be the first to verify this fix
Sign in to verify this fix