Results 1 to 11 of 11
  1. #1
    3 Star Lounger
    Join Date
    Nov 2001
    Location
    Brooklyn, New York, USA
    Posts
    200
    Thanks
    2
    Thanked 0 Times in 0 Posts

    annoying insert options icon (2003)

    Every now and then (this time was moving cells down) this IRRITATING little paintbrush (I think it's insert options) flies up in front of the next cell, obscuring it. And even when I choose something, it stays there; and it stays there also when I go to tools-options-edit and turn off the show-paste or show-insert boxes.
    ggrrrrreeeessssssh!

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: annoying insert options icon (2003)

    Does it help if you turn off "Label data with smart tags" in the Smart Tags tab of Tools | AutoCorrect Options...?

  3. #3
    3 Star Lounger
    Join Date
    Nov 2001
    Location
    Brooklyn, New York, USA
    Posts
    200
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Re: annoying insert options icon (2003)

    Hi Hans, I'm afraid that's already off.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: annoying insert options icon (2003)

    And did you quit and restart Excel after turning off "Show Insert Options buttons"? (It shouldn't be necessary, but you never know...)

  5. #5
    3 Star Lounger
    Join Date
    Nov 2001
    Location
    Brooklyn, New York, USA
    Posts
    200
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Re: annoying insert options icon (2003)

    I'll keep this in mind. Seems I've done this before and they keep coming back. Thanks.

  6. #6
    Silver Lounger
    Join Date
    Jul 2001
    Location
    Ottawa, Ontario, Canada
    Posts
    1,609
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: annoying insert options icon (2003)

    Are you certain that you don't mean the "Format Painter"?
    Regards
    Don

  7. #7
    3 Star Lounger
    Join Date
    Nov 2001
    Location
    Brooklyn, New York, USA
    Posts
    200
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Re: annoying insert options icon (2003)

    Well I guess that is what it is, but it's disappeared. I've poked around, would that be autocorrect, autoformat as you type, turn off "apply as you work"?

  8. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: annoying insert options icon (2003)

    The Format Painter is a toolbar button. The Insert Options smart tag is a little button (with a Format Painter icon) displayed next to the cells on the worksheet itself.

  9. #9
    Silver Lounger
    Join Date
    Jul 2001
    Location
    Ottawa, Ontario, Canada
    Posts
    1,609
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: annoying insert options icon (2003)

    Thank You Hans

    Something else about which I need to further enlighten myself.
    Regards
    Don

  10. #10
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: annoying insert options icon (2003)


  11. #11
    Silver Lounger
    Join Date
    Jul 2001
    Location
    Ottawa, Ontario, Canada
    Posts
    1,609
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: annoying insert options icon (2003)

    Merci Mentor!
    Regards
    Don

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •