View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default remove Format painter icon on speardsheet

And in other versions of Excel:

ToolsOptionsEdit tab

Uncheck one or both of these:

Show Paste Options buttons
Show Insert Options buttons

OK out

--
Biff
Microsoft Excel MVP


"Squeaky" wrote in message
...
Hi Richard.

In 2007, Press the Button, select Options at the bottom.
Select Advanced. In the Cut, Copy, and Paste section uncheck SHOW PASTE
OPTIONS. If that doesn't do it try unchecking the others.

Squeaky

"Richard" wrote:

Whenever I insert a new line I get an format painter icon on the next
cell
down so I can format. With the work I'm doing this icon covers over a 3
chracter code that I need to read to decide whether I need to insert
another
line. I cannot start from the bottom and move up.
How do I shut this assistant off?

Thanks