autofill

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

Guest

The old autofill worked great because you could tell it to copy down a formula sequentially only changing the one value you wanted. Office XP apparently doesn't do this anymore. Now its a time consuming find and replace or other manual methods. has any one found a solution. The autofill options does not allow for my example, it does allow for steps but thats not what I'm interested in.

Thanks

PS
 
AFAIK, autofill in Excel 2002 works the same as it did in previous
versions. Can you type an example of a formula that you're trying to
copy down, and having problems with?

In your formulas, use absolute references ($A$2) for the references that
shouldn't change, and relative references (A2) for the references that
should change, and you can fill down by dragging the autofill handle.
 
Also make sure Tools>Options>Edit>Settings>"allow cell drag and drop" is
checked.

Although, this unchecked should not affect Edit>Fill functions, just drag/copy
functions.

Gord Dibben Excel MVP
 

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

autofill down won't work!!!! 3
how do I create a nonadjacent series for autofill to go by? 3
I can't autofill cells in a column if blank cells in between 1
selective autofill with functions 3
Edit Multiple Cells 15
VLOOKUP and AutoFill 5
AutoFill w/formulas 1
Can't use Autofill with a User Defined Function in VBA 3

Back
Top