equation

[Guest]

How do I make an equation for one whole column, but
differsfor each cell? For instance, row 3: C3+D2-G3 then
row 4: C4+D3-G4.

 

[Norman Harker]

Hi!

You'll need to ensure that "drag and drop is enabled"

Tools > Options > Edit
Check "Allow cell drag and drop"
OK

In row 3:

=C3+D2-G3
Enter
Select the cell you entered the formula in
Point to the bottom right corner of the cell
Left click and hold down the + drag handle
Drag down as many rows as you want and release the left button.
Each cell reference will increment by one for each row it is copied
down.

If you have data in all cells to the left or right of where you want
to copy
Point to the + drag handle and then double click it.



--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Guest]

Your formula should adjust automatically as you copy or fill. The reference style you used is refered to as Relative references. Check out the help files on Relative and Absolute reference styles

----- (e-mail address removed) wrote: ----

How do I make an equation for one whole column, but
differsfor each cell? For instance, row 3: C3+D2-G3 then
row 4: C4+D3-G4