If you are referencing cell $($C$2)$in Excel and want to be able to copy the formula and update the column and keep the row fixed, how do you reference the cell in a formula, you don't need to include the $=?$

Answer format: Text