"Filling Down" Formulas without changing values

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Auto Fill Options 1
Excel 2003 - fill down error 1
help Fill formulas, highlight cells to specified destination 1
Filling Formulas 2
Fill formula down for cells 74 rows apart 3
Formulas won't increment when dragging to adjacent cells? 3
Custom filling of cells 2
Auto Fill formula when inserting a new line 4

Back
Top