About Us

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?

tomgilb

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.

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Changing the range for averages with out changing the formula.	JessLRC	Excel Worksheet Functions	0	April 20th 10 03:10 PM
how to edit formula without changing formula of each cell	sadat	Excel Worksheet Functions	2	April 24th 07 02:02 PM
Need Help changing FORMULA	zipper21	Excel Discussion (Misc queries)	2	April 2nd 06 09:44 AM
Copy Formula Down Without Changing Entire Formula	roy.okinawa	Excel Discussion (Misc queries)	3	March 16th 06 01:54 AM
Formula changing	hookahbrain	Excel Discussion (Misc queries)	3	January 19th 06 10:12 PM

Menu

About Us