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; (30692.77, « »)

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)

All Comments

Leave a comment...

  • 8 Comments
    • Gerry Hickman <gerry666uk.excel.todaysummary.com.newsgroup.nospam> wrote in news:etTmF$akIHA.4744

      .excel.todaysummary.com.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.todaysummary.com.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.todaysummary.com.newsgroup.nospam> wrote in news:etTmF$akIHA.4744

      > .excel.todaysummary.com.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.todaysummary.com.newsgroup.nospam> wrote in

      news:uRSYhibkIHA.4684.excel.todaysummary.com.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.todaysummary.com.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