+ Reply to Thread
Results 1 to 3 of 3

can't delete pics and textboxes

  1. #1
    Forum Contributor
    Join Date
    08-14-2006
    Location
    USA
    MS-Off Ver
    2019
    Posts
    682

    can't delete pics and textboxes

    I have numerous screenshots pasted and dozens of text boxes and arrows on my work sheet. When trying to delete them it takes a minimum of 5 tries.

    I select the item and hit delete key, the previously active cell becomes active and the item is not deleted.
    I'll do this 5 to 10 times before it finally is deleted!
    I've tried selecting, right click and cut, with no success. (There is no delete option in the shortcut menu.)

    Any ideas why this is happening?
    Last edited by carsto; 07-14-2011 at 10:51 PM.

  2. #2
    Forum Contributor
    Join Date
    12-29-2006
    MS-Off Ver
    2010
    Posts
    180

    Re: can't delete pics and textboxes

    Quote Originally Posted by carsto View Post
    I have numerous screenshots pasted and dozens of text boxes and arrows on my work sheet. When trying to delete them it takes a minimum of 5 tries.

    I select the item and hit delete key, the previously active cell becomes active and the item is not deleted.
    I'll do this 5 to 10 times before it finally is deleted!
    I've tried selecting, right click and cut, with no success. (There is no delete option in the shortcut menu.)

    Any ideas why this is happening?
    You could use the Selection tool on the drawing toolbar to select all the shapes and then delete them.

    Or if there are no other objects on the sheet you could use CTRL+G > Special > Objects. To select all.

    Original post >
    http://www.excelforum.com/excel-new-...cel-sheet.html

    OR if you want to do it by macro try this link

    http://www.excelforum.com/excel-prog...with-code.html

    *if it work , please don't forget to mark the thread as SOLVED and RATE in thread that you used

    Thank you

  3. #3
    Forum Contributor
    Join Date
    08-14-2006
    Location
    USA
    MS-Off Ver
    2019
    Posts
    682

    Re: can't delete pics and textboxes

    I don't know how they got there but there seems to be numerous duplicate EDITED pics on top of each other! How do you unknowingly copy & paste a pic exactly over the top of another??????

    I just had to delete them one by one. I don't want all the pics deleted, just every single copy of specific pics.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1