Excel Tip of the Day
Easily select objects embedded in a worksheet
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. To do so, choose View | Toolbars | Customize from the menu bar. Then, click on the Commands tab. Next, select Drawing from the Categories list box. Finally, drag the Select Multiple Objects button from the Commands list box to the toolbar you prefer and 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. Simply click the check boxes next to the objects you want to select and click OK.
Note that Excel 2002s's Select Multiple Objects dialog box has been enhanced to include Select All and Unselect All buttons.
(Content provided by Element K Journals)
(Note: Your browser is set to refuse cookies. As a result, you may frequently see previously-viewed tips)
Print
CloseCopyright © 2001 - 2025 MJ Technologies, LLC. All rights reserved.