Microsoft Office Tutorials and References

In Depth Information

**Entering the Same Formula in Many Cells**

Using this method requires ten keystrokes, with no trips to the mouse. You can

enter formulas that have no absolute references, mixed references, paren-

theses, or exponents by using just the arrow keys and the keys on the numeric

keypad.

Note

Officially, every formula must start with an equal sign. However,

to make former Lotus 1-2-3 users comfortable, Excel allows you to

start a formula with a plus sign. Power Excel users have discovered

that using a plus sign enables them to start a formula by typing on

the numeric keypad. Because I routinely start formulas with the plus

sign, I am often asked why I start with =+ instead of just =. Even

though the formulas appear that way onscreen, I don
’
t actually

enter the plus sign. When a formula starts with a plus sign, Excel

adds an equal sign and does not remove the plus sign, so you end up

with a formula that looks like =+B2*$F$1.

Entering the Same Formula in Many Cells

So far in this chapter, you have entered a formula in one cell and then copied

and pasted to get the formula in many cells. To enter the same formula in

many cells, you can use three alternatives:

•
Preselect the entire range where the formulas need to go. Enter the

formula for the first cell and press Ctrl+Enter to enter the formula

in the entire selection simultaneously.

•
Enter the formula in the first cell and then use the fill handle to

copy the formula.

•
Beginning with Excel 2007, the method is to define the range as a table.

When you use this method, the new formulas are copied down a column

automatically.

Copying a Formula by Using Ctrl+Enter

Copying a Formula by Using Ctrl+Enter

This strategy works when you are entering formulas for one or more screens

that are full of data:

11. If you have just a few cells, select them before entering the formula.