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

Making Cell Selections 133
3. Type the cell address of the last cell in the range in the Reference
text box.
If this address is already listed in the Go To list box, you can enter this address in the text box by clicking it in the list box.
4. Hold down the Shift key as you click OK or press Enter to close the Go To dialog box.
By holding down Shift as you click OK or press Enter, you select the range between the active cell and the cell whose address you specified in the Reference text box.
Instead of selecting the anchor cell and then specifying the last cell of a range in the Reference text box of the Go To dialog box, you can also select a range simply by typing in the address of the cell range in the Reference text box. Remember that when you type a range address, you enter the cell ref- erence of the first (active) cell and the last cell in the range separated by a colon. For example, to select the cell range that extends from cell B2 to G10 in the worksheet, you would type the range address B2:G10 in the Reference text box before clicking OK or pressing Enter.
Name that range!
One of the easiest ways to select a range of data is to assign a name to it and then choose that name on the pop-up menu attached to the Name box on the Formula bar or in the Go To list box in the Go To dialog box. Of course, you reserve this technique for cell ranges that you work with on a somewhat regular basis; for example, ranges with data that you print regularly, consult often, or have to refer to in formula calculations. It’s probably not worth your while to name a range of data that doesn’t carry any special importance in the spreadsheet.
To name a cell range, follow three simple steps:
1. Select all the cells in the range that you intend to name.
You can use any of the cell selection techniques that you prefer. When selecting the cells for the named range, be sure to include all the cells that you want selected each time you select its range name.
2. Click the Name box on the Formula bar.
Excel automatically highlights the address of the active cell in the
selected range.
3. Type the range name in the Name box and then press Enter.
As soon as you start typing, Excel replaces the address of the active
cell with the range name that you’re assigning. As soon as you press the Enter key, the name appears in the Name box instead of the cell address of the active cell in the range.
Book II Chapter 2
Formatting Worksheets