The background inside the area changes color and becomes transparent.

The direction that you drag your cursor from the first point to the opposite corner determines which objects are selected.

However, if an object with a noncontinuous (dashed) linetype is only partially visible in the viewport and all the visible vectors of the linetype can be enclosed within the selection window, the entire object is selected.

Use window polygon selection to select objects entirely enclosed by the selection area.

Use crossing polygon selection to select objects enclosed or crossed by the selection area.

The circuit board illustration shows a fence selecting several components.

For a description of each of the selection options, see the SELECT command.

Select a table Sometimes you must select rather than just click a table to modify it.

Selecting ensures that the table is in the correct state for the steps that follow.

Click the table, then click in its top-left corner; three white squares appear on the edges of the table when its selected.

Select a range of cells: Click a cell, then drag a white dot any direction to encompass the range of cells you want.

If you drag the yellow dot, you copy the cell contents to the rows you drag over.

If you do this accidentally, drag the yellow dot back to its original position, or press Command-Z on the keyboard to undo the action.

Select nonadjacent cells: Click a cell, then Command-click any other cells.

When you select a table cell, the Smart Cell View appears at the bottom of the Numbers window.

The Smart Cell View shows you the actual value of a selected cell (for example, Apr 3, 2014 12:00 AM), or the formatted value of a cell if youre editing it (for example, 43).

If the selected cell contains a formula, the Smart Cell View shows you the formula.

If youre editing the formula, the Smart Cell View shows you the formula result.

You can also select a range of cells to see quick calculations for those cellssuch as the sum, average, minimum value, and maximum valuein the Smart Cell View.

Letters appear above the columns and numbers appear to the left of the rows.

Do any of the following: Select a single row or column: Click the number or letter for the row or column.

Select multiple rows or columns: To select adjacent rows or columns, click the number or letter for the first row or column, then drag a white dot to encompass the rows or columns you want.

Select nonadjacent rows or columns: Command-click any row numbers or column letters.

Excel For Mac Select Multiple Objects