How To Delete All Objects At Once In A Spreadsheet

Assuming that we have charts and objects in our spreadsheet and we come to the point that we are not satisfied with the appearance of them and we want to delete them all at once. What do we do?

Instead of selecting them one by one (procedure which will take a long time) and then pressing the delete button every time, we can follow the next tip.

On the Home tab of the Excel window and in the area of the ribbon named Editing, we select the Find & Select button. From the drop down menu that appears we select the Go To Special… command as we can see in the image below.


The Go To Special window appears, where we activate the button next to the command Objects as we can see in the image below and the press the OK button.


Once we press the OK button, we will notice that all the objects in our spreadsheet are now selected.

Now all we have to do is to press the delete button (seeing that, that is what we wanted) in order for all the objects to be deleted.


Below you can check out the video describing on how to delete all the objects in our spreadsheet very quickly.


About officesmart

MVP: Honored with the MVP (Most Valuable Professional) for OFFICE SYSTEM title for the years 2011, 2012, 2013, 2014 and 2015 by Microsoft, for my contribution and commitment to the technical communities worldwide. Microsoft Master Specialist: This certification provides skill-verification tools that not only help assess a person's skills in using Microsoft Office programs but also the ability to quickly complete on-the-job tasks across multiple programs in the Microsoft Office system

Posted on June 25, 2012, in Excel 2010 English, Microsoft Office 2010 English and tagged , , , , , . Bookmark the permalink. Comments Off on How To Delete All Objects At Once In A Spreadsheet.

Comments are closed.