Microsoft Office Tutorials and References
In Depth Information
Create a Formula
Working with Formulas and Functions
4 Type an operator for the formula.
5 Click the next cell that you want to
include in the formula.
C Excel inserts the cell reference into
6 Repeat Steps and until all the 5
necessary cells and operators have
7 Press .
D You can also click Enter ( ) on the
Formula bar to accept the formula.
E You can click Cancel (
) to cancel
F The result of the formula appears in
G The formula appears in the Formula
bar; you can view it by clicking the
cell containing the formula.
Note: If you change a value in a cell
referenced in your formula, Excel
automatically updates the formula result
to reflect the change.
How do I edit a formula?
To edit a formula, click in the cell containing the
formula and make any corrections in the Formula
bar. Alternatively, double-click in the cell to make
edits to the formula from within the cell. When
How do I reference cells in other worksheets?
To reference a cell in another worksheet, specify
the worksheet name followed by an exclamation
mark and then the cell address (for example,
Sheet2!D12 or Sales!D12). If the worksheet name
includes spaces, enclose the sheet name in single
quote marks, as in ‘Sales Totals’!D12.
or click Enter (
) on the