Query on Excel help for adding $ sign to formula

Anil (1638 Points)

30 March 2009  

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