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




Custom Search