Drag & Drop difference?

  • Thread starter Thread starter GD
  • Start date Start date
G

GD

Can anyone tell me why there are times when dragging and dropping a single
date or number down a column causes it to advance, but then other times the
value stays the same??? Are there settings to control this function?
 
I've given up trying to remember.

If I'm not sure (99.9% of the time), I'll rightclick on the autofill button and
drag.

When I let go of the button, I'll see options that I can use.
 
Excel generally does OK if a single date is entered and dragged.

Does not do well if a single number is entered and dragged.

OK with two numbers selected and dragged..........the sequence is
recognized.

Custom Lists are also recognized when a single item is entered.

As Dave points out............right-click and drag gives you options.


Gord Dibben MS 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

Drop down / validation / lookup into the same cell 2
Drag and Drop Picture 1
AutoFilter then dragging down. 4
Different ways to build Pivot table 1
Excel Drag autofill only part of formula 3
Fill color palette remain on screen 2
Pivot table 2
Fill-in formula which calculates automatically 3

Back
Top