Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .