ok, say in A1 i have this formula: =B1+C1 now, say i copy this formula from A2 to A1000 in A2, i will get =B2+C2 HERE IS WHAT BUGS ME! what if in the formula i want B1 to change, but i want C1 to stay C1? for example, say i want A2 to be =B2+C1 what i have been doing is copying the formula to the cells i want it, then i go back by hand and change the values that i didn't want changed. BUT FOR A LOT OF CELLS, THIS SUCKS! what can i do, if anything?! thx!