Prev: Deleting cliparts in excel sheet
Next: Paste Values in linked Cells Only
From: cheryl on 2 Jun 2010 09:27
the broom icon shows in some instances. what does it mean and how do i
remove it?
From: trip_to_tokyo on 2 Jun 2010 09:34
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.







"cheryl" wrote:

> the broom icon shows in some instances. what does it mean and how do i
> remove it?
From: Gord Dibben on 2 Jun 2010 09:45
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

On Wed, 2 Jun 2010 06:27:01 -0700, cheryl <cheryl(a)discussions.microsoft.com>
wrote:

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

From: Bob Umlas, Excel MVP on 2 Jun 2010 16:39
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............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
>
> On Wed, 2 Jun 2010 06:27:01 -0700, cheryl <cheryl(a)discussions.microsoft.com>
> wrote:
>
> >the broom icon shows in some instances. what does it mean and how do i
> >remove it?
>
> .
>
 | 
Pages: 1
Prev: Deleting cliparts in excel sheet
Next: Paste Values in linked Cells Only