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.