remove Format painter icon on speardsheet

  • Thread starter Thread starter Richard
  • Start date Start date
R

Richard

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
 
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
 
And in other versions of Excel:

Tools>Options>Edit tab

Uncheck one or both of these:

Show Paste Options buttons
Show Insert Options buttons

OK out
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Format Painter won't stay on 5
Inserting Rows...but losing "FORMAT" 1
Format Painter 1
Format painter mouse icon missing 2
Conditional formating icons 3
Help with format painter and conditional format 2
how can i place the Format Painter icon on the Context menu? 3
Format Painter not working in Word 2010 3

Back
Top