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
CAclubindia
