A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » Excel Discussion (Misc queries)
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Removing the formatting paint brush & Automatic Clipboard Excel 20



 
 
Thread Tools Display Modes
  #1  
Old March 5th 09, 11:43 AM posted to microsoft.public.excel.misc
zaraimrie
external usenet poster
 
Posts: 2
Default Removing the formatting paint brush & Automatic Clipboard Excel 20

Please please please can someone help me as they are driving me crazy. I have
just moved to a new job which has Excel 2003 and work on it all day. The
clipboard constantly pops up even though I untick the automatic clipboard.
Also the formatting paintbrush which appears automatically if cells beside
each other are formatted differently. I cannot work how to turn this off!!

Please help me
Ads
  #2  
Old March 5th 09, 05:20 PM posted to microsoft.public.excel.misc
Gord Dibben
external usenet poster
 
Posts: 22,912
Default Removing the formatting paint brush & Automatic Clipboard Excel 20

To stop the Formatting icon from appearing, disable it at Tools>Options>Edit

"Show paste options buttons"

I also disable "Show insert options buttons"

To stop the ClipBoard from appearing.........

From help on "Clipboard"

Turn off the Office Clipboard
On the Office Clipboard task pane, click Options.
Clear the Show Office Clipboard Automatically check box.
Clear the Show Office Clipboard When Ctrl+C Pressed Twice check box.
Note To copy items to the Clipboard while it is turned off, select the
Collect Without Showing Office Clipboard check box.


Gord Dibben MS Excel MVP

On Thu, 5 Mar 2009 03:43:17 -0800, zaraimrie
> wrote:

>Please please please can someone help me as they are driving me crazy. I have
>just moved to a new job which has Excel 2003 and work on it all day. The
>clipboard constantly pops up even though I untick the automatic clipboard.
>Also the formatting paintbrush which appears automatically if cells beside
>each other are formatted differently. I cannot work how to turn this off!!
>
>Please help me


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
removing automatic link xk Excel Discussion (Misc queries) 0 November 20th 06 04:00 PM
removing automatic link Graham Poole Excel Discussion (Misc queries) 8 March 22nd 06 01:31 PM
How turn off automatic office clipboard forever? Ian Elliott Excel Discussion (Misc queries) 1 June 20th 05 06:36 PM
formatting brush icon chickadeestudio Excel Discussion (Misc queries) 1 April 26th 05 03:47 PM
Shorcut Key for Paint Brush Al Excel Discussion (Misc queries) 1 December 23rd 04 08:37 AM


All times are GMT +1. The time now is 07:00 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Copyright 2004-2014 ExcelBanter.
The comments are property of their posters.