Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 709
Default remove Format painter icon on speardsheet

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
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 155
Default remove Format painter icon on speardsheet

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

  #3   Report Post  
Posted to microsoft.public.excel.misc
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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Format Painter:Can it repeat w/out having to hit icon multi times tralfaz113 Excel Discussion (Misc queries) 8 May 12th 23 11:42 AM
copy conditional format without using format painter MsConfused Excel Worksheet Functions 2 May 4th 09 07:16 AM
Format Painter Fay Excel Discussion (Misc queries) 1 March 14th 08 07:44 PM
how can I use the format painter?? hermosilla New Users to Excel 1 August 11th 06 11:56 PM
how can i place the Format Painter icon on the Context menu? Saratusthra Excel Discussion (Misc queries) 2 June 8th 05 05:20 PM


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

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

About Us

"It's about Microsoft Excel"