Can Autofill be Defaulted to copy cells instead of fill series

B

Barry A&P

i know im just being lazy but i use the drag box to copy lots of data and it
always wants to copy as an incremental series and i want it to default to
just copy cells without having to open the autofill menu and select it..

Thanks
Barry
 
A

Andy

Hi Barry,

I had the same problem. All you have to do is press "Ctrl" while you are
dragging the data.

Andy
 
G

Gord Dibben

In addition you can right-click and drag......release and "Copy Cells"


Gord Dibben MS Excel MVP
 
B

Barry A&P

you get so used to doing things in certain ways, a simple tip in technique
helps

Thanks guys
 

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

Series fill only copying and fill series greyed out 1
How to put series of number in excel while filters applied? 1
Excel AutoFillOption 3
How do I drag a hyperlink series to fill instead of copy? 2
auto fill options (copy cell, not create series) 4
Change a Macro - Copy in Columns instead of copy in Rows 7
How do you turn off the Autofill Options box when dragging cells. 1
Auto Fill and Excel 2003 8

Top