Say I want to copy the formula in a cell to other cell. Formula in the cell from where i want to copy is $A$1*$B$3. When I copy this formula into a new cell I will get $A$1*$B$3 , but I want the formula to be ( Without Dollar Sign. ie relative refference ), so it will be a formula without dollar and depending on which cell I paste the alphabets and numerics will change accordingly.

Please note in my original file the formula is a 7 line formula so I cant manually make changes ...unless i have like an hour.

Help will be highly appreciated as it will save me from spoiling my Sunday

Roshan