Forum Discussion
Formula staying constant when copying into new cells, keeps going to the right
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; h...
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).
Hi Joe
I read your answer with interest as we have the same problem in our sheet. We are calculating holiday on a weekly basis, each week needing the new "last weeks pay" to be inserted at the start and calculated for the growing year, so we only need the start column to be fixed. At the moment the formula reads =SUM($B$17:BG17)/52 but as Scorpion's issue, it moves to the right and next week will be =SUM($C$17:BF17)/52. Totally foxed so if you or anyone has any thoughts please can you help? It's so tedious manually changing every line. TIA
I read your answer with interest as we have the same problem in our sheet. We are calculating holiday on a weekly basis, each week needing the new "last weeks pay" to be inserted at the start and calculated for the growing year, so we only need the start column to be fixed. At the moment the formula reads =SUM($B$17:BG17)/52 but as Scorpion's issue, it moves to the right and next week will be =SUM($C$17:BF17)/52. Totally foxed so if you or anyone has any thoughts please can you help? It's so tedious manually changing every line. TIA