Page 150 - Excel 2013 All-in-One For Dummies

132 Making Cell Selections
In terms of selecting the table of data shown in Figures 2-2 and 2-3, this means that you would have to complete four separate operations to select all of its cells:
1. With A3 as the active cell, hold down Shift and press End+↓ to select the range A3:A8.
Excel stops at A8 because this is the last occupied cell in that column. At this point, the cell range A3:A8 is selected.
2. Hold down Shift and then press End+→.
Excel extends the range all the way to column J (because the cells in column J contain entries bordered by blank cells). Now all the cells in the table (the cell range A3:J8) are selected.
Selecting cells with Go To
Although you usually use the Go To feature to move the cell cursor to a new cell in the worksheet, you can also use this feature to select a range of cells. When you choose the Go To option from the Find & Select button’s drop- down menu on the Home tab of the Ribbon (or press Ctrl+G or F5), Excel dis- plays a Go To dialog box similar to the one shown in Figure 2-4. To move the cell cursor to a particular cell, enter the cell address in the Reference text box and click OK. (Excel automatically lists the addresses of the last four cells or cell ranges that you specified in the Go To list box.)
Figure 2-4:
Selecting a cell range with the Go To dialog box.
Instead of just moving to a new section of the worksheet with the Go To fea- ture, you can select a range of cells by taking these steps:
1. Select the first cell of the range.
This becomes the active cell to which the cell range is anchored.
2. On the Ribbon, click the Find & Select command button in the Editing group on the Home tab and then choose Go To from its drop-down menu or press Ctrl+G or F5.
The Go To dialog box opens.