Tags: excel, icon, insert, microsoft, msdn, office, own, paintbrush, reported, screen, software, sp1, stuck, system, user, vista, wrong
Excel 2007 - paintbrush icon stuck on screen after insert
On Microsoft » Microsoft Excel
6,718 words with 8 Comments; publish: Thu, 22 May 2008 03:48:00 GMT; (30646.88, « »)
Hi,
A new user reported this. I thought they must be doing something wrong,
but now I see it on my own system.
Vista SP1
Office 2007 SP1 (all defaults)
1. Start with a new sheet
2. Enter data into the three rows (rows 1,2,3)
3. Format that data as bold
4. Insert a new row at position 2
A paintbrush icon appears on screen just below the row I've inserted,
pressing escape does not get rid of it.
The new user found this annoying, and I agree. I also don't know why
it's a picture of a paintbrush when it's for "insert options".
Any way to get rid of it without changing global options?
--
Gerry Hickman (London UK)
http://excel.itags.org/q_microsoft-excel_148388.html
All Comments
Leave a comment...
- 8 Comments
- Gerry Hickman <gerry666uk.excel.itags.org.newsgroup.nospam> wrote in news:etTmF$akIHA.4744
.excel.itags.org.TK2MSFTNGP06.phx.gbl:
> Hi,
> A new user reported this. I thought they must be doing something wrong,
> but now I see it on my own system.
> Vista SP1
> Office 2007 SP1 (all defaults)
> 1. Start with a new sheet
> 2. Enter data into the three rows (rows 1,2,3)
> 3. Format that data as bold
> 4. Insert a new row at position 2
> A paintbrush icon appears on screen just below the row I've inserted,
> pressing escape does not get rid of it.
> The new user found this annoying, and I agree. I also don't know why
> it's a picture of a paintbrush when it's for "insert options".
> Any way to get rid of it without changing global options?
>
lol its a "feature", but i turned mine off
- click your office button (for new office user reading htis, its the big
circle icon with 4 squares on top left)
- click excel options (bottom right of window)
- click advanced
- uncheck the box that say "Show Insert Options buttons"
then test it again.
you can turn off the other annoying new features while you are there.
#1; Thu, 22 May 2008 03:50:00 GMT
- On Sat, 29 Mar 2008 15:15:45 +0000, Gerry Hickman <gerry666uk.excel.itags.org.newsgroup.nospam>
wrote:
> I also don't know why
>it's a picture of a paintbrush when it's for "insert options".
When you "insert" do you want to "format same as above", "format same as below",
"clear formatting".
Sounds like a format paintbrush job to me.
Gord Dibben MS Excel MVP
#2; Thu, 22 May 2008 03:51:00 GMT
- Hi Gord,
>> I also don't know why
>> it's a picture of a paintbrush when it's for "insert options".
> When you "insert" do you want to "format same as above", "format same as below",
> "clear formatting".
> Sounds like a format paintbrush job to me.
OK, but why does it get stuck on the screen? The normal "format painter"
brush can be turned off by pressing escape.
--
Gerry Hickman (London UK)
#3; Thu, 22 May 2008 03:52:00 GMT
- Hi Pub,
OK, I can disable these features globally, but I was hoping for the
"paste" behavior where you can get rid of the little paste icon if you
don't want it.
pub wrote:
> Gerry Hickman <gerry666uk.excel.itags.org.newsgroup.nospam> wrote in news:etTmF$akIHA.4744
> .excel.itags.org.TK2MSFTNGP06.phx.gbl:
>> Hi,
>> A new user reported this. I thought they must be doing something wrong,
>> but now I see it on my own system.
>> Vista SP1
>> Office 2007 SP1 (all defaults)
>> 1. Start with a new sheet
>> 2. Enter data into the three rows (rows 1,2,3)
>> 3. Format that data as bold
>> 4. Insert a new row at position 2
>> A paintbrush icon appears on screen just below the row I've inserted,
>> pressing escape does not get rid of it.
>> The new user found this annoying, and I agree. I also don't know why
>> it's a picture of a paintbrush when it's for "insert options".
>> Any way to get rid of it without changing global options?
> lol its a "feature", but i turned mine off
> - click your office button (for new office user reading htis, its the big
> circle icon with 4 squares on top left)
> - click excel options (bottom right of window)
> - click advanced
> - uncheck the box that say "Show Insert Options buttons"
> then test it again.
> you can turn off the other annoying new features while you are there.
Gerry Hickman (London UK)
#4; Thu, 22 May 2008 03:53:00 GMT
- pub wrote:
> - click excel options (bottom right of window)
> - click advanced
Hehe, it shows just how dumbed down Excel has become, this is what
Microsoft call "Advanced" these days!
--
Gerry Hickman (London UK)
#5; Thu, 22 May 2008 03:54:00 GMT
- Gerry Hickman <gerry666uk.excel.itags.org.newsgroup.nospam> wrote in
news:uRSYhibkIHA.4684.excel.itags.org.TK2MSFTNGP06.phx.gbl:
> Hi Pub,
> OK, I can disable these features globally, but I was hoping for the
> "paste" behavior where you can get rid of the little paste icon if you
> don't want it.
>
globally is the best way
the other ways are
after you insert the row and the brush appears
if you are a mouse user (like me)
- just click in the formula bar real quick
- then click out, and it will go away
if you are a keyboard user
-type in a random number or letter
-hit backspace
-hit enter
thats the best i can do
#6; Thu, 22 May 2008 03:55:00 GMT
- Hi,
> When you "insert" do you want to "format same as above", "format same as below",
> "clear formatting".
I can see the logic of waiting for user input if you try to insert new
rows into the middle of a formatted selection, but the user basically
wants to be able to insert blank rows after a formatted selection.
I tested on my system, and if I insert the rows immediately after the
formatted selection (ie first blank row), I still get the paintbrush.
--
Gerry Hickman (London UK)
#7; Thu, 22 May 2008 03:56:00 GMT
- I don't have 2007 but with 2003 I would go to Tools>Options>Edit and disable the
"Show paste Options buttons" and the "Show Insert Options Buttons"
I don't like either of them, along with "error checking" indicator.
Gord
On Sat, 29 Mar 2008 20:02:57 +0000, Gerry Hickman <gerry666uk.excel.itags.org.newsgroup.nospam>
wrote:
>Hi,
>> When you "insert" do you want to "format same as above", "format same as below",
>> "clear formatting".
>I can see the logic of waiting for user input if you try to insert new
>rows into the middle of a formatted selection, but the user basically
>wants to be able to insert blank rows after a formatted selection.
>I tested on my system, and if I insert the rows immediately after the
>formatted selection (ie first blank row), I still get the paintbrush.
#8; Thu, 22 May 2008 03:57:00 GMT