**What is $ sign in excel formulas?**

For example, if you have formula "=A1+B1" in cell C1, and drag it downward. (or copy the formula to other cells).

The values in column C will automatically equal those in column A + Column B.

please see the screen shot below,

If you add the dollar sign inside the cell A1 like A$1, and drag it downward, you will have the column C equal the value which is equal to A1+B1, A1+B2, A1+B3,... Etc

see that A1 is constant for all calculations.