Microsoft Office Tutorials and References

In Depth Information

**Speed Techniques for Entering Formulas**

4.
Enter the formula.

For example, enter
=B1*.06
. Make sure that you enter all cell addresses

correctly. By the way, you can enter lowercase letters in cell references.

Excel changes them to uppercase after you finish entering the formula.

The next section in this chapter explains how to enter cell addresses

quickly in formulas.

5.
Press Enter or click the Enter button (the check mark on the Formula

bar).

The result of the formula appears in the cell.

Speed Techniques for Entering Formulas

Entering formulas and making sure that all cell references are correct is a

tedious activity, but fortunately for you, Excel offers a few techniques to

make entering formulas easier. Read on to find out how ranges make entering

cell references easier and how you can enter cell references in formulas by

pointing and clicking. You also find instructions here for copying formulas.

Clicking cells to enter cell references

The hardest part about entering a formula is entering the cell references

correctly. You have to squint to see which row and column the cell you want

to refer to is in. You have to carefully type the right column letter and row

number. However, instead of typing a cell reference, you can click the cell

you want to refer to in a formula.

Book III

Chapter 3

In the course of entering a formula, simply click the cell on your worksheet

that you want to reference. As shown in Figure 3-5, shimmering marquee

lights appear around the cell that you clicked so that you can clearly see

which cell you’re referring to. The cell’s reference address, meanwhile,

appears in the Formula bar. In Figure 3-5, I clicked cell F3 instead of entering

its reference address on the Formula bar. The reference F3 appears on the

Formula bar, and the marquee lights appear around cell F3.

Get in the habit of pointing and clicking cells to enter cell references in

formulas. Clicking cells is easier than typing cell addresses, and the cell references

are entered more accurately.