Is there a way to make a static variable in a division formula in Excel 2007

I am trying divide multiple cell by the same cell, but when I go to drag down my autofill box, it changes the 2nd value (which I want to remain static).

For example, I want
...all the way to B30

When I copy the first two cell and try to drag it down (so it populates the rest), it changes the C33 value as well. Is there a way to make it so it stays static?

2nd part of the question is when I do a sort, it changes the C33 part again, thus messing up the division again. So if there is a way to have it stay static (I would want the first variable to change becuase it would be on a new line once sorted)?
Who is Participating?
jppintoConnect With a Mentor Commented:
just change the C33 on your formula to $C$33

You can use absolute addressing instead of relative addressing

if you copy C33, column and row info will shift, by putting $ signs in front of column, row or both, you fix that dimension.

In your case, you would use

and could copy it wherever you want. The B1 part would shift, but C33 is fixed by the $ signs.

Using the $ simbol will fix the coordinate of the row or the column.


C$33 - will fix the row number, no matter where you copy the formula, it will mantain the reference to row 33
$C33 - will fix the column letter.
$C$33 - will fix the row number and column letter

BHBMHTAuthor Commented:
That is EXACTLY what I was needing. Thanks!
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.