Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I have an Excel sheet with one of the columns having around 25000 entries.

Now, I create a new sheet – say Sheet2 – and I have a simple formula like this in the first column of Sheet2.

I went to the first row and entered

=Sheet1!C2

Now I dragged this down to the entire 25000 rows to copy the entire column from the first sheet here through this formula. Is there a better way to do it?

I tried double clicking on the + sign at the bottom right of the cell but that did not seem to work for me.

share|improve this question
    
Sometimes a task is more suited to a DBMS + SQL, is this one of them? –  RedGrittyBrick Oct 11 '11 at 9:36

1 Answer 1

up vote 2 down vote accepted

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 Sheet2!A1 has the formula =Sheet1!C2

  1. With Sheet2 active, type A25000 into the Name Box and then press Enter. This will select cell A25000.

    enter image description here

  2. Press Ctrl + Shift + Up ↑. This selects cells A1 to A25000.

  3. Press Ctrl + D. This extends the formula in A1 down to A25000.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.