Share via

bulk delete?

Anonymous
2023-02-24T18:47:39+00:00

I have downloaded a file with images and everything matches up. If i go to sort the images lets say by license to show a customer "this is what we have in stock for disney" there are images that get thrown to the bottom of the table and they seem to be stacked on top of each other.

there are thousands of images that are in this "pile" how can i just bulk delete all of them instead of deleting one by one which will take forever.

thanks!

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

4 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-03-21T20:04:26+00:00

    Either, while on the sheet, press F5 on the keyboard and choose Special…, then Objects, OK

    Image

    or select a big area with a marquis (mentioned earlier) (click and drag while you've opted for Select Objects). If there are many objects on top of each other, all of them will be selected.

    or show the selection pane, and select objects in there one at a time while holding the control key (probably best to use this to deselect objects you don't want to lose, some dropdown arrows sometimes get included as objects)

    After one of those processes, press the delete key on the keyboard.

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments
  2. Anonymous
    2023-02-25T12:56:22+00:00

    In the Home tab of the ribbon, there's a section called Editing, and in there there's a dropdown Find & Select, in there, choose Select objects.

    Image

    This will allow you to select many/all pictures by dragging a marquis around them, then you can press the delete key.

    Don't forget to toggle Select Objects off so that you can use the sheet normally again.

    In the same place, there's also a Selection Pane option which will list the pictures (and other objects) which you can use to check you've got rid of all that you want to get rid of.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  3. Anonymous
    2023-03-21T19:21:13+00:00

    so when i do do that i am just selecting one by one .

    so for example i deleted one picture another one pops up behind it i delete that and so on and so forth. how do i just delete ALL

    thank you!

    Was this answer helpful?

    0 comments
  4. Anonymous
    2023-02-25T09:43:12+00:00

    Dear Kimberly,

    Welcome to the forum here.

    About the issue "If i go to sort the images lets say by license to show a customer 'this is what we have in stock for disney' there are images that get thrown to the bottom of the table and they seem to be stacked on top of each other.", could you upload some related screenshots for our confirmation?

    May I know whether the issue happens when you edit the file in Excel for the web?

    If it is convenient, please open Excel>click on File>Account and upload a full screenshot of the Account page for our reference.

    Note: Remove any private information before uploading the screenshots.

    Thanks for your effort and time!

    Sincerely,

    Cliff | Microsoft Community Moderator

    Was this answer helpful?

    0 comments