Applying formula to Column based on rows.

[anastasiarae]

I am making a product information spreadsheet for a business I am starting. I haven't worked with excel for a couple years so I feel that I have forgotten everything! My formulas are simple. I will give you one as an example, it starts at H2 and continues down. Down the column it appears like this:
=F2-E2
=F3-E3
=F4-E4
=F5-E5

Pretty simple, but I've been trying to figure out how to just type it once and apply it without the formula being stuck on the row that I typed. It is a very long spreadsheet and I could be working on the formulas alone for days if I have to type the formula in every cell! Please give me some tips/advice or direct me to a thread that discusses this. Thanks!

 

[Mr Stanford]

Double click the little box on the right hand of the selector box, or hold the bottom of the box and drag it down the columns.

You would need to select the first cell then drag/double click to get the correct formulas.