drag a cell down in a column

  • Thread starter Thread starter William Franks
  • Start date Start date
W

William Franks

when you drag a cell down in a column a drop down list
becomes available and i would like to make the default
option to be copy cell instead of fill series. Is there a
way to do this?
 
Hi William

haven't really got an answer for you but to cause a autofill list to copy
rather than fill hold your Control key down while you drag (and make sure
you let the mouse go before the control key) - hope this helps somewhat

Cheers
julieD
 
William

Right-click and drag then hit "c"

Gord Dibben Excel MVP
 
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

drag formula down from columns that go acros 3
using the =page! feature to transpose a row to column 0
Dragging a formula in a column 1
Formatted cell column in drop down list 1
How do I drag a hyperlink series to fill instead of copy? 2
drop-down list 2
Copy corresponding cell in Column B if cell in A contains certain text? 1
Locking a cell reference in a formula 1

Back
Top