Help needed- To copy formulas in the cells without changing the reference cell

[velu_888]

I'm new to excel and preparing an accounting model for my office use. I request the members to help me to solve the copying of formula to all other cells.

The detail is here:

Sheet 1:
1) I've entered a number 1000 in L2

Sheet 2:
1) I've entered a values in columns D,E,F,G
2) Calculations :
at G2 : the formula is =D2*Sheet1!L2

The problem is when I Copy the formula in G2 through G3, G4, G5............... it changes to =D3*Sheet1!L3, =D4*ValidData!L4, =D5*ValidData!L5 and so on......
but it should be =D3*Sheet1!L2, =D4*ValidData!L2, =D5*ValidData!L2, so that the L2 value shall be constant for calculations in all cells.

Please help me to resolve this, Thanks in advance.............!

[Sam Capricci]

change L2 to $L$2 or so...
$ before the column locks in the column, $ before the row locks in the row, $ before both locks in the cell.

[velu_888]

Thank you Sambo, kind of you in solving the issue...............!