"Filling Down" Formulas without changing values

P

Portland Ken

I want to copy a formula down to the next 20 cells. When I highlight the cell
and the next 20 blank cells below, and hit the "fill down" button, it copies
the cells, but also becomes additive. For instance, the D45 changes to D46,
D47, etc. Before reformatting recently, that only did as above if I dragged
a formula down by grabbing a corner. How do I change the fill-down command so
that it only copies-down?
 
P

Portland Ken

That's where I'm confused. I recently reformatted my computer and loaded in
Windows XT and all of the Office updates. Before reformatting (W98) it always
did it just fine! Now it won't.
 
M

Myrna Larson

I think you are remembering incorrectly. When copying a formula, the
references will change unless you have used absolute references, with the
dollar signs. This is, and has been, true in all versions of Excel since 2.1
in 1987.
 
Top