Microsoft Office Tutorials and References

In Depth Information

**Perform One Time Calculations Using a Formula**

Press Esc to cancel Copy mode.

The operation is applied to the contents of each cell in the range. The formula

in each cell is changed to include the new operation.

Perform One Time Calculations Using a Formula

Create a temporary formula in an unused cell, typically a column out of the

way. Select an empty cell at the top, type = (equal sign), and then type a func-

tion, such as Proper().

Click the
Home
tab.

If you want to change a range of data, use the fill down handle to copy the for-

mula to unused cells.

Select the cell or range with the formula.