ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   what does the broom icon mean and how do i get rid of it? (https://www.excelbanter.com/excel-discussion-misc-queries/265062-what-does-broom-icon-mean-how-do-i-get-rid.html)

Cheryl

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

trip_to_tokyo[_3_]

what does the broom icon mean and how do i get rid of it?
 
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?


Gord Dibben

what does the broom icon mean and how do i get rid of it?
 
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?



Bob Umlas, Excel MVP

what does the broom icon mean and how do i get rid of it?
 
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?


.



All times are GMT +1. The time now is 02:50 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com