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.

ToolsOptionsEdit. Uncheck "Show paste options button" and for the heckuvit
uncheck "Show insert options button".

Gord Dibben Excel MVP

On Mon, 29 Nov 2004 17:21:03 -0800, lvh519
wrote:

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.