Auto Format icon
 

Hi All,

Is there a way to turn off the auto-format icon (the brush) that pops up
when I insert a row?

Thanks!

Amy

Auto Format icon
 

EXCEL 2007

Office Button (top left hand corner)

Excel Options (lower right hand corner)

Advanced

Cut, copy, and paste (on right hand side)

Toggle off the Show Insert Options buttons switch.

If my comments have helped please hit Yes.

Thanks.




"cvgairport" wrote:

Hi All,

Is there a way to turn off the auto-format icon (the brush) that pops up
when I insert a row?

Thanks!

Amy

Auto Format icon
 

2007

ButtonExcel OptionsAdvancedCut, Copy Paste

Uncheck "show insert options button"

2003

ToolsOptionsEdit

I also don't like the paste options so I uncheck it.


Gord Dibben MS Excel MVP


On Thu, 1 Apr 2010 06:13:02 -0700, cvgairport
wrote:

Hi All,

Is there a way to turn off the auto-format icon (the brush) that pops up
when I insert a row?

Thanks!

Amy

Auto Format icon
 

Tools - Options - Edit, uncheck the box to see insert options

--
Best Regards,

Luke M
"cvgairport" wrote in message
...
Hi All,

Is there a way to turn off the auto-format icon (the brush) that pops up
when I insert a row?

Thanks!

Amy