Stop autofill icon from appearing?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Whenever I drag a formula or formatting down to another cell, if the formats
don't already match, the drop down icon for autofill formatting appears. How
do I stop this from happening. I do not need the menu and it is always in
the way.
 
Tools>Options>Edit. Uncheck "Show paste options button" and for the heckuvit
uncheck "Show insert options button".

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

Macro to autofill from a specific row to a specific row 2
Autofill list 2
Autofill 3
Autofill block of cells with drop down 1
Autofill column values in formulas 4
Autofill the block of cells with drop down 2
HELP!!! I need macro to autofill 4
Stop Autofill 6

Back
Top