Quote:
Originally Posted by thajtodad
I have the follwimg formula
=D5+E12
If i want to make the formula continue as follows
=D5+E13
=D5+E14
=D5+E15
etc...
is there any way to do that besides typing in the formula multiple times?
|
If you put a $ in front of the column and/or row, it won't change, e.g. =$D$5+E12. You can copy this and paste into multiple cells below in the same column all at once and be done in one action.