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
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.
Search JabSto ::

Custom Search