Hi,
I have range of cells with forumula which have references to other cells.
For example:: In cell A1 I have forumula "=B1*C1"
In cell A2 I have forumla" =B2*C2"
I want to select these two cells A1 and A2 and make forumulas in them permanent.
For example I want in cell A1 I want the forumula to be "=$B$1*$C$1"
How to do this in one stroke for all selected cells. Is there any shortcuts for this?
Thanks