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.
Posted on June 25, 2012, in Excel 2010 English, Microsoft Office 2010 English and tagged Delete All Objects, Excel 2010, Go To Special, Objects, Office Smart, Smart Office. Bookmark the permalink. Comments Off on How To Delete All Objects At Once In A Spreadsheet.