That's almost enough info, but we'll see.

If that formula is sequential cells and the relative references are
adjusting all the way down, simply select the entire range of cells,
press F2 to edit one of them, the press CTRL-ENTER to apply that same
change to all the cells. The relative portion of the references will
stay relative, any absolute changes will apply absolutely to each cell.

You can even select non-adjacent cells and do the same thing,
Shift-click on each cell until you have them all selected, then F2 to
edit one, and CTRL-ENTER to apply the changes.

Does this work for you?


--
JBeaucaire
------------------------------------------------------------------------
JBeaucaire's Profile: http://www.thecodecage.com/forumz/member.php?userid=73
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=55262