Selecting Cells While Entering Formulas.

When entering a formula into a cell, it is possible to use the mouse and the keyboard cursor keys to quickly enter data.

There are several ways to enter a cell range into a formula. Cell ranges and references can be entered into a formula simply by typing in the proper syntax (see the section called Cell Referencing for more details). But manually entering in cell ranges is slow and cumbersome.

When entering data into a cell, and the cursor is at a point where a cell reference is appropriate, it is possible to define a cell reference by selecting a cell via the mouse or keyboard. This selection is a little different from the ordinary selection. It is highlighted by a "marching ants" border.

Figure 1-2. The highlighted selection

Entering data into a formula with the mouse

When entering a formula, if the cursor is at a point where a cell reference may be appropriate, the user just needs to click on a cell to automatically enter its cell reference into the formula. Then finish the formula as normal.

Using the mouse to enter a cell reference into a formula

  1. Select a cell to enter a formula into. For example A1.

  2. Enter a formula, but stop the cursor at a point where a cell reference is appropriate. For this example, =exp(

  3. Now use the mouse to click on another cell to reference. For example, just click on the Cell B1. Its reference will be entered into the formula in cell A1.

  4. To finish the formula, just type in the closing parenthesis. This will also "unselect" the region.

This can be used to select a range of cells just like regular selections.

Entering data into a formula with the keyboard.

If entering lots of formulas or even just entering a few formulas, it is often quickest to use the keyboard to select cells and ranges of cells for use in formulas. Just as reaching a input point allows the user to select cells with the mouse, it is possible to use the keyboard to select cells. Just use the cursor keys and selection modifiers to create a selection.

Using the keyboard to enter data into a formula.

  1. Select a cell to enter a formula into. For example A1.

  2. Enter a formula, but stop the cursor at a point where a cell reference is appropriate. For this example, =SUM(

  3. Move the selection around with the cursor keys. Move the selection cursor to ce