Open your workbook in Excel. You can open Excel then click File > Open to open your workbook or you can right-click the file in your file manager and select Open with > Excel.
Navigate to the worksheet that has the images you want to remove. The sheets are separated by tabs at the bottom of your screen.
Click the Home tab. It's at the top of your screen in the editing ribbon.
Click Find & Select. You'll find this in the "Editing" grouping.
Click Go To Special. It's near the middle of the menu that dropped down from "Find & Select."
Click to fill in the circle next to Objects and click OK. This will prompt Excel to locate and select all the objects in your current worksheet. Not only will Excel select all the images in your sheet, but it will also select any objects in the sheet including charts, shapes, screenshots, icons, 3D models, and SmartArt. If there are objects you don't want to select, click them to unselect them.
Press Delete on your keyboard. Pressing this will instantly delete and remove all the selected objects from your Excel sheet.
Comments
0 comment