Excel Auto Fill Options

A

astanfo

Is there a way to change the default on the Excel auto fill? When you grab
the bottom right of the cell and drag it down it defaults to fill the
formula. I want to change it so it defaults to fill "copy cells" instead of
the formula.
Someone please help!
Thanks
 
D

Dave Peterson

You can't change the default.

I like to rightclick on that autofill button and then when I let go, I can
choose how I want to fill.
 

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

Auto Fill Options 1
auto fill options (copy cell, not create series) 4
Auto Fill Defaults 3
Autofill defaults 4
Excel 2003 - fill down error 1
Series fill only copying and fill series greyed out 1
Set default in auto fill options, I always want to copy cell, som. 2
Change Default Auto-Fill-In month 4

Top