Excel® 2013 On Demand

Performing One Time Calculations

Sometimes you may want to perform simple calculations, such as dividing each value in a range by 4, without having to take the time to use a formula. You can use the Paste Special command to perform simple mathematical operations, such as Add, Subtract, Multiply, and Divide. If you want to perform a more complex function, you can create a temporary formula to accomplish a one-time task. For example, if you want to display a list of names in proper case with only the first letter of each name in uppercase, you can use the Proper function.

Perform One Time Simple Calculations without Using a Formula

Select an empty ...