Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Sep 2001
    Location
    California
    Posts
    106
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Removing Object from Cell (2002/SP3)

    Attached is a sample worksheet that has an object in each cell. I can select the object but cannot delete it. HELP! How do I get rid of these "bullets"? Thank you in advance.
    Thanks,
    Caroline in lala-land

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

    Re: Removing Object from Cell (2002/SP3)

    Press Ctrl+G or select Edit | Go To...
    Click Special...
    Select the Objects radio button.
    Click OK.
    All "bullets" will be selected now.
    Press Delete.

    The cell values in column C start with two spaces. You'll probably want to delete those.

  3. #3
    Platinum Lounger
    Join Date
    Jan 2001
    Posts
    3,788
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Removing Object from Cell (2002/SP3)

    I addition to the response from Hans, the reason that it appeared that the objects were not being deleted was because there were multiple "bullets" sitting on top of each other. As soon as you deleted one it showed the one underneath.

  4. #4
    2 Star Lounger
    Join Date
    Sep 2001
    Location
    California
    Posts
    106
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Removing Object from Cell (2002/SP3)

    Thank you, thank you, thank you ...
    Thanks,
    Caroline in lala-land

Posting Permissions

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