Mar 24, 2023 · Insert the symbol ±. You can also use the insert Symbol tool. As shown below in the INSERT ribbon (1), you can click on Symbol (2), then make sure you are on the Symbol font (3) (note there are also others) and about 60% down (4) you will see the plus minus symbol (5). Be aware that any formula connected to this cell will break as this is now Select the cell or range where you want to add the dollar sign. Press the “F4” key (function key) on your keyboard. The dollar sign ($) will appear in front of both row and column reference when you add data and hit enter. To remove the dollar sign, press “F4” again until it disappears from the cells or range selected. tk48.

dollar signs in excel formulas