You can't get rid of the format painter in 2007 without customizing the
ribbon. It's a handy tool for copying formatting.

"Gord Dibben" wrote:

In 2007............ButtonExcel OptionsAdvancedCut, copy and paste.

In 2003............ToolsOptionsEdit

Uncheck the options which display the format painter.


Gord Dibben MS Excel MVP

On Wed, 2 Jun 2010 06:27:01 -0700, cheryl
wrote:

the broom icon shows in some instances. what does it mean and how do i
remove it?

.