Turning Off Auto Fill Options

J

John13

How do you turn of the Auto Fill Options so when I copy a cell over
that little popup stops popping up and offering "Copy Cells", "Fill
Series", etc. It's more annoying than it's worth.

I'm using Excel 2003 and thanking you in advance for your help.

John
 
G

Gord Dibben

Don't use the right mouse button to copy over or down.

Use the left mouse button.


Gord Dibben MS Excel MVP
 
D

Debra Dalgleish

Choose Tools>Options
Select the Edit tab
Remove the check marks from 'Show Paste Options buttons'
and 'Show Insert Options buttons'.
Click OK
 

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

Kill the annoying "Auto Fill Options" button 3
auto fill options (copy cell, not create series) 4
Excel Auto Fill Options 1
Auto Fill function in Excel 2007 not working properly 4
Cell outline prevents drag and fill 2
Auto Fill Defaults 3
Auto Fill Options 1
Excel 2007 won't recalculate unless I turn off or re-apply auto filter 0

Top