Stop autofill icon from appearing?

L

lvh519

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.
 
G

Gord Dibben

Tools>Options>Edit. Uncheck "Show paste options button" and for the heckuvit
uncheck "Show insert options button".

Gord Dibben Excel MVP
 
Top