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.