Microsoft Office Tutorials and References

In Depth Information

As you press this key, notice that Excel displays a moving border around the cell, and that the cell reference

(A1) appears in cell A3 and in the Formula bar. Also notice that Excel displays Point on the status bar.

If you prefer, you can use your mouse and click cell A1.

4.
Type a plus sign (
+
).

The moving border becomes a solid blue border around A1, and Enter reappears in the status bar. The cell

cursor also returns to the original cell (A3).

5.
Press one more time. If you prefer, you can use your mouse and click cell A2.

A2 is appended to the formula.

6.
Press Enter to end the formula.

As with typing the formula manually, the cell displays the result of the formula, and the formula appears in

the Formula bar when the cell is activated.

If you prefer, you can use your mouse and click the check mark icon next to the Formula bar instead of

pressing Enter. And if, at any time, you change your mind about entering the formula, just press Esc or click

the X icon next to the Formula bar.

This method might sound a bit tedious, but it's actually very efficient after you get the hang of it. Pointing to

cell addresses rather than entering them manually is almost always faster and more accurate.

Excel 2013 color-codes the range addresses and ranges when you are entering or edit-

ing a formula. This helps you quickly spot the cells that are used in a formula.

When you're working with a table of data (created by using Insert
⇒
Tables
⇒
Table), you

can use a different type of formula — a self-propagating formula that takes advantage

of column names. I cover this topic in Chapter 9.

Pasting names

As I discuss in Chapter 3, you can assign a name to a cell or range. If your formula uses named cells or ranges,

you can type the name in place of the address, or choose the name from a list and have Excel insert the name for

you automatically.

To insert a name into a formula, position your cursor in the formula where you want the name entered and use

one of these two methods:

• Press F3 to display the Paste Name dialog box. Select the name and click OK.

• Take advantage of the Formula AutoComplete feature. When you type a letter while constructing a formula,

Excel displays a list of matching options. These options include functions and names. Use the down-arrow

key ( ) to select the name and then press Tab to insert the name in your formula.