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'm using a simple Euclidian distance formula sqrt((a-b)^2 + (c-d)^2) and I have more than 60,000 data in my each excel sheet. Instead of dragging mouse (which is very inconvenient for this large number of data) how can I define the range of records? For example my formula looks like -

=SQRT((H2-J2)^2+(I2-K2)^2)

And also, to popolate the result in 60000 rows, where should I write the formula?

share|improve this question

migrated from stackoverflow.com Dec 11 '12 at 8:15

This question came from our site for professional and enthusiast programmers.

    
You can use copy paste instead of dragging. –  Bryan Glazer Dec 11 '12 at 0:01
    
Not sure what are you talking about.. I assume i have to copy the formula but where should I paste? –  Pow Dec 11 '12 at 0:06
12  
Enter the first formula and select that cell, then double-click the little box in the bottom-right corner of that cell. That will fill down the formula as far as there is something in the cell to the left of the formula cell. –  Tim Williams Dec 11 '12 at 0:20
    
Excellent! Thanks Tim! –  Pow Dec 11 '12 at 0:29

1 Answer 1

For the sake of an answer (as such). To avoid the issue that double-clicking only fills down as far as one row short of the first empty cell in the column immediately to the left:

  1. Home > Editing - Find & Select, Go To, enter B60000 as Reference, OK.
  2. Enter something ('z' will do).
  3. Return to topmost cell containing the desired formula, copy it, select the cell immediately below it, Ctrl+Shift+Down and Paste.
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.