I am creating a spreadsheet that will be used to drag and drop and move
information around in but my cell referncing changes when data in a
referenced cell is dragged to another cell. Is it possible to create cell
references in formula's that do NOT change when the data in a referenced cell
is dragged?

For example:
- Desired Formula in Cell C2 "=($A$2*$B$2)"
- if I drag cell A2 to cell A3 my formula in cell C2 automatically changes
to ($A$3*$B$2). Is there a way to stop that from changing?

Thank you for you help.