Quickly Clear Objects from Worksheet

Earlier this week, I copied a list of Excel keyboard shortcuts from the Microsoft website, and pasted it into Excel. Then I noticed that a few objects had come along with the shortcuts list.

In the screen shot below, you can see one of the tiny icons that you can click, to go to the top of the web page. Those are handy on the web page, but aren’t much help on the Excel sheet.


See What Objects You Copied

Sometimes these objects are easy to spot, but if they’re small, or if there are lots of them, it’s not so easy.

A quick way to see all the objects that are on a worksheet is to use the Selection Pane.

  • On the Ribbon’s Home tab, click File & Select
  • Click Selection Pane
  • The Selection Pane opens, and you can see the full list of objects on the active sheet.

    To select an object, click its name in the Selection Pane. (NOTE: If the worksheet contains ActiveX Controls, you can only select those in Design Mode.)


    Select All the Objects

    If you’d like to select all the objects, instead of selecting them one at a time, you can follow these steps:

  • On the Ribbon’s Home tab, click Find & Select
  • Click Go To Special
  • In the Go To Special window, click on Objects, and click OK
  • objectsdelete05

    Delete the Selected Objects

    After you’ve selected one or more objects, you can delete them.

    • On the keyboard, press the Delete key, or
    • On the Ribbon’s Home tab, click Clear, then click Clear All.

    And if you want to see that list of shortcuts on the Microsoft site, click here: Excel Keyboard Shortcuts.

    Watch the Video

    To see the steps for selecting and deleting worksheet objects, please watch this short video tutorial.