You can add many types
of objects to a worksheet. In addition to chart objects and OLE objects
like embedded Word documents, you can add items like form controls,
drawing shapes, and WordArt to enhance your worksheets.
If you need to make the
same change to many objects, the process can be time consuming. In
addition, it's sometimes difficult to select an object -- you may intend
to select a narrow line object and inadvertently select a cell.
Excel has a feature
that helps you select embedded objects, but it's hidden by default.
To take advantage of
this feature, you need to add a button to one of Excel's toolbars.
-
From the View menu
select Toolbars4Customize.
-
Click on the
Commands tab.
-
From the
Categories list box select Drawing .
-
Drag the
button from the Commands
list box to the toolbar.
-
Click Close.
From this point
forward, you can select objects by clicking the Select Multiple Objects
button.
When you click it,
Excel displays a dialog box that lists all of the objects associated with
the current worksheet.
Note that Excel
2002s's Select Multiple Objects dialog box has been enhanced to include
Select All and Unselect All buttons.
