How to Remove Unwanted Objects in Excel (4 Quick Methods)

Get FREE Advanced Excel Exercises with Solutions!

While working in Excel you may see some unwanted objects occurring on your worksheet. It may be any kind of pictures, shapes, charts, etc. Therefore, this article will guide you on how to remove unwanted objects in Excel with 4 quick methods.


How to Remove Unwanted Objects in Excel (4 Quick Methods)

For example, we have taken a dataset of 6 companies’ profits in 2020. Unfortunately, while copying the names from a browser, we got some company logos beside the texts as pictures.

How to Remove Unwanted Objects in Excel


Now, we will try to deploy the 4 methods below to remove them from our worksheet.

1. Remove Objects in Excel with Go To Special Feature

The first method will help you to remove objects with the Go To Special feature in Excel. Let’s see the process below:

  • Firstly, go to the Home tab and click on Find & Select.

Remove Objects in Excel with Go To Special Feature

  • Secondly, select Go To Special from the drop-down menu.

Remove Objects in Excel with Go To Special Feature

  • Now, select the option Object in the new Go To Special window.

Remove Objects in Excel with Go To Special Feature

  • Then, press OK.
  • As a result, you will see that the images are selected like this:

  • Finally, press the Delete button on your keyboard to remove the selected objects.

Read More: How to Make Fishbone Diagram in Excel


2. Apply Excel VBA Code to Remove Unwanted Objects

In this second method, we will apply Excel VBA Macro code to remove the unwanted objects. Follow the steps below:

  • First, go to the Developer tab and select Visual Basic.

Apply Excel VBA Code to Remove Unwanted Objects

  • Then, in the new window select Module from the Insert section.

Apply Excel VBA Code to Remove Unwanted Objects

  • After that, insert this code on the blank page.
Sub DeleteAllPictures()
Dim Picture As Object
For Each Picture In ActiveSheet.Pictures
Picture.Delete
Next Picture
End Sub

Apply Excel VBA Code to Remove Unwanted Objects

  • Now, click on the Run Sub button or press F5 on your keyboard.

  • Following, click on Run in the Macros window.

Apply Excel VBA Code to Remove Unwanted Objects

  • Finally, you will see that the unwanted objects have disappeared from the worksheet.

Note: You can apply this code if you have any unwanted shapes in the worksheet.
Sub DeleteAllShapes()
Dim sp As Shape
For Each sp In ActiveSheet.Shapes
sp.Delete
Next
End Sub

Read More: How to Draw to Scale in Excel


3. Omit Unwanted Objects Using Excel Select Object Command

In this section, we will go through a quick step-by-step procedure to omit unwanted objects using the Select Objects command in Excel.

  • In the beginning, go to the Home tab and click on Find & Select.

Omit Unwanted Objects Using Excel Select Object Command

  • Then, choose Select Objects from its drop-down section.

Omit Unwanted Objects Using Excel Select Object Command

  • Now, select the pictures you want to remove.
  • In case of multiple objects, press the Ctrl key on your keyboard and proceed with the selection.

  • After that, press the Delete button.
  • Finally, the unwanted images are not showing in the worksheet anymore.

Read More: How to Draw Engineering Drawing in Excel


4. Apply Selection Pane Tool to Erase Unwanted Objects

This final method will help you to erase objects with the Selection Pane tool. Follow the quick process below:

  • Firstly, go to the Home tab.
  • Then, click on Find & Select.
  • After that, choose the Selection Pane option.

Apply Selection Pane Tool to Erase Unwanted Objects

  • After this, you will see the picture list in the Selection Pane appearing on the right side.
  • In this section, press Ctrl + A to select all the picture names.

Apply Selection Pane Tool to Erase Unwanted Objects

  • Next, press Delete.
  • Finally, you can see that the unwanted objects are removed successfully.

Read More: How to Draw a Floor Plan in Excel


Things to Remember

  • The Checkbox is not like the unwanted objects described above and so requires different methods to remove.
  • If you do not have a Developer tab, you can find it in File > Option > Customize Ribbon.
  • You cannot simply remove the images or shapes incorporated with the text with the Delete button. You have to follow any of the methods above.

Download Workbook

Download the sample file from here to practice by yourself.


Conclusion

I concluded the article with the hope that it was an effective and helpful article for you on how to remove unwanted objects in Excel with 4 quick methods. Let us know if you have any other techniques to suggest.


Related Articles


<< Go Back to Drawing in Excel | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Sanjida Mehrun Guria
Sanjida Mehrun Guria

Hello! Welcome to my blog. I have completed my Bachelor in Architecture from Ashanullah University of Science & Technology, Dhaka. I am a passionate, goal-oriented person with an immense thirst for knowledge and an attitude to grow continuously. Besides Architectural work, I find it very enthusiastic to work in Excel blogging. Exceldemy is a platform where I have got the opportunity to flourish my skill in Microsoft Excel and therefore, here I will be posting blogs related to... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo