Formt column

[Guest]

I am trying to set up and excel sheet. I need to divide several row
separately by one number and I am having a hard time.

I know if I have the number in i.e, d5 and my column is c, then I will need
to do the formula as this: c?/d$5. Is this correct and if so, how do I make
this formula enter into the entire "c" column without having to type it over
and over?

 

[Fred Smith]

1. Put the formula you want in the top cell in column c. For example, in c5,
put =d5/3, or whatever formula you need.

2. Put your mouse on the small black square at the bottom right of the
highlighted box. It's call the "fill handle". Drag it down as far as you
need. Excel will create the formulas for you. For example, in c6, it will
put =d6/3, etc.

3. If you really want row 5 to stay constant (ie, not change), that's what
the $ sign does. If your formula is =d$5/3, then the row (5) will not change
as you drag the formula down.