Excel tips: convert formulas to values

Excel Tips: convert formulas to values

A quick and easy way with Mouse to convert formulas to values, rather than using Paste Special… Values:

How?

Position your mouse pointer over the edge of a selected range of cell.

The pointer will change to a four-headed arrow.

With your right mouse button, drag away from then back to its original position.

Now release drag, you can select Copy Here As Values Only from the 6 options

and for single cell: Press {f2}{f9}{enter}

Exshail