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.
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:
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.