Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Format Painter:Can it repeat w/out having to hit icon multi times | Excel Discussion (Misc queries) | |||
copy conditional format without using format painter | Excel Worksheet Functions | |||
Format Painter | Excel Discussion (Misc queries) | |||
how can I use the format painter?? | New Users to Excel | |||
how can i place the Format Painter icon on the Context menu? | Excel Discussion (Misc queries) |