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.
If you are interested on finding out, just watch the video tutorial below.
If you want to learn how this can be done step by step, you can always read the full post here:
https://officesmart.wordpress.com/2012/06/25/how-to-delete-all-objects-at-once-in-a-spreadsheet/

Please Subscribe To My YouTube Channel:
https://www.youtube.com/user/philippospan
Please Subscribe To My Blog:
https://officesmart.wordpress.com/

Please take the opportunity to connect and share this video with your friends and family if you find it useful.