ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Removing the formatting paint brush & Automatic Clipboard Excel 20 (https://www.excelbanter.com/excel-discussion-misc-queries/223151-removing-formatting-paint-brush-automatic-clipboard-excel-20-a.html)

zaraimrie

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 :)

Gord Dibben

Removing the formatting paint brush & Automatic Clipboard Excel 20
 
To stop the Formatting icon from appearing, disable it at ToolsOptionsEdit

"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 :)




All times are GMT +1. The time now is 06:48 PM.

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