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

Custom Search