Formula staying constant when copying into new cells, keeps going to the right

Occasional Visitor

I am trying to create a budget excel sheet for my fiancée and I, the formula I am trying to copy a formula exactly from the source without it making the cells move. I know this can be accomplished; however, I do not know how. The formula I have now calls on cells x5 and aa5. the formula is as follows =PRODUCT(X5*AA5), this is what need to stay constant. I also have had it written as =X5*AA5. However, i have a problem where it keeps moving the cells right when I try to copy move it, this is what it does with one cell movement, =PRODUCT(Y5*AB5), this is what I need to stop as I have many cells that need the =X5*AA5 formula. Things I have tried, =X$5$*A$A$5$, ctrl + 1, f4. nothing is working for me though so here I am. any help on this is appreciated.


Thank you

1 Reply



You almost got it:  =$X$5*$AA$5 instead of =X$5$*A$A$5$.


PS....  If you type =X5*AA5, then select X5*AA5 in the Formula Bar and press f4 repeatedly, it should cycle through various forms of absolute references automagically.


PPS....  Usually, we can press f4 repeatedly immediately after typing X5 and again after typing AA5 as we enter the formula.  But sometimes that does not work, even in my version (Excel 2010).