what does the broom icon mean and how do i get rid of it?

[cheryl]

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

 

[trip_to_tokyo]

EXCEL 2007

If you mean the Format Painter try the following:-

Home main tab

Clipboard group

click on Format Painter to turn it off or on

If my comments have helped please hit Yes.

Thanks.

 

[Gord Dibben]

In 2007............Button>Excel Options>Advanced>Cut, copy and paste.

In 2003............Tools>Options>Edit

Uncheck the options which display the format painter.


Gord Dibben MS Excel MVP

 

[Bob Umlas, Excel MVP]

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