tomgilb

Junior Member

Posts: 2

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.

Reply With Quote

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

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

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

All times are GMT +1. The time now is 03:46 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us