I often see Excel users who need to replace formulas with values doing it manually by typing the value in each cell. If you’re one of those people, I’ve got a much easier way for you — and less chance of making a costly or embarrassing mistake.
A quick and easy way to convert formulas to values, rather than using Paste Special… Values, is by dragging the edge of a cell or range using the right mouse button, dropping it where you want to paste the values (even back to the original cells), and select Copy Here As Values Only.
Position your mouse pointer over the edge of a selected range of cell. The pointer will change to a four-headed arrow.With your left-mouse button, click and drag away from then back to its original position.
It’s so simple!