Selecting Objects

Vertex42 The Excel Nexus

Professional Excel Templates

Get Instant Access

Generally, selecting objects conforms to standard Windows practices. You can select a range of cells by clicking and dragging. Clicking an object that has been placed on the drawing layer selects the object. To select multiple objects or noncontiguous cells, press Ctrl while you select the objects or cells. To select a large range, click a cell at any corner of the range, scroll to the opposite corner of the range, and press Shift while you click the opposite corner cell.

If an object has a macro assigned to it, you'll find that clicking the object executes the macro. To actually select such an object, right-click it and press Esc to hide the shortcut menu.

In versions prior to Excel 97, clicking an embedded chart selected the chart. In Excel 97 and later, clicking a chart selects a specific object within the chart. To select the chart object itself, press Ctrl while you click the chart.

Was this article helpful?

0 0

Post a comment