Excel Selection Techniques
Using Selection Techniques
Before you can enter data, you have to select a cell. Before you can change the data, you have to select it. In this section, you'll learn effective, easy techniques that enable you to select cells, ranges, and nonadjacent cells. With one click, you can even select your entire worksheet, which is definitely a timesaver when it comes to making global changes.
Selecting a Cell
Selecting a cell is the first step in entering data or executing most commands in a worksheet. The single cell that receives the data or formula you enter is the active cell. When a cell is selected, its border becomes bold and the column and row indicators are highlighted.
To select a cell:
- Click the desired cell or
- Use the arrow keys to move the desired cell
In the following exercise, you will select cells using the keyboard and the mouse.
- If cell A1 is not selected, click it using the mouse. [Cell A1 is selected and is the active cell.]
- Press Down Arrow 4 times. [A5 becomes the active cell].
- Press Right Arrow 2 times. [C5 becomes the active cell].
- Click cell E5. [E5 becomes the active cell].
Selecting a Range of Cells
A rectangular selection of multiple cells is referred to as a range. You may wish to select a range when entering a group of data or when you wish to perform the same action on several cells. The range appears as a shaded block of cells, and the active cell in a range is defined by a bold border and white background. When a range is selected, its column and row headings are highlighted. In Figure 1-7, the selected range is referred to as B6:C9 ("B6 to C9").
To select a range of cells:
- Select the first cell of the desired range.
- Drag the mouse pointer through the range of cells you wish to include. or
- Press and hold Shift, and then click the final cell of the range.
- Release Shift
- Use the arrow keys to move the cell pointer to the first cell of the desired range.
- Press and hold Shift, and then use the arrow keys to highlight the desired range.
- Release Shift.
In the following exercise, you will select ranges of cells using the mouse and the keyboard.
- Open a Blank workbook select cell A1.
- Drag the mouse pointer to cell D5. [The range A1 to D5 is selected].
- Using the arrow keys, select cell B2. [Cell B2 is selected. The first range, A5 to D5, is deselected].
- Press and hold Shift, and then use the arrow keys to select cell E7. [The range B2:E7 is selected].
- Release Shift.
- Select cell A1. [The range B2:E7 is deselected].
- Press and hold Shift, and then click cell D1.
- Release Shift. [The range A1:D1 is selected].
- Click cell A1. [The range A1:D1 is deselected].
Selecting Nonadjacent Cells and Ranges
As a rule, to select multiple, nonadjacent objects in Windows, you employ the Ctrl key. For example, you may use Ctrl and the mouse to select multiple files or folders in Explorer or My Computer. This method also works in Excel to select nonadjacent cells and ranges.
To select nonadjacent cells or ranges:
- Select the first cell or range.
- Press and hold Ctrl
- Select the next cell or range.
- Release Ctrl.
In the following exercise, you will select nonadjacent cells and ranges.
- Make sure cell A1 is selected.
- Press and hold Ctrl. [The range A1 to D5 is selected].
- Select cell C4. [Cells A1 and C4 are selected].
- Using the mouse, select the range B6:E10. [Cells A1 and C4, and the range B6:E10 are selected].
- Release Ctrl.
- Select cell A1.
Selecting an Entire Worksheet
Selecting an entire worksheet is useful when you want to make changes on a global scale. For instance, you might want to change the size of the font in every cell in the worksheet. Once you select the entire worksheet using the Select All button, illustrated in Figure 1-4, you can do this in a single step.
To select an entire worksheet:
- Click the Select All button.
In the following exercise, you will select the entire worksheet.
- Click the Select All button. [The entire worksheet is highlighted].
- Click any cell. [Only the clicked cell is selected.].