We use the Dollar sign to make absolute/mixed cell references in Excel. And also after using it, we often may have any need to remove the Dollar sign. In this article, I will show you how to remove the dollar sign in the Excel formula by simple methods and transparent illustrations.

## Introduction to Relative, Mixed, and Absolute Cell References

We use cell references in Excel to automate the calculation. For example “**=A4 * B7**” will do the multiplication of cell **A4 **and cell **B7 **and here cell **A4 **is the cell of **Column A** and **Row 4** similarly **B7 **is the cell of **Column B** and **Row 7**.

There are 3 types of cell references: Relative, Mixed, and Absolute.

**Relative Cell Reference: **In Excel, all cell references are relative references by default. After using relative cell references, when you will copy and paste the formula into other cells, the references will change based on the relative positions of rows and columns.

**Absolute Cell Reference**: In Excel, we use it when we have to fix the position of a cell or range of cells in any formula. So, the reference of the fixed cell will not change by doing copy and paste to other cells.

Making absolute references is very easy. Just put a Dollar** ($)** sign before the row and column index in the formula. For example, if you want to fix the value of Cell **B2**, then you have to write **$B$2** so it will make an absolute cell reference.

**Mixed Cell Reference: **We use this when we have to lock either only the row or the column index.

- To lock the row, put the dollar
**($)**sign before the row number. So, if you copy and paste the formula to other cells it will change only**Column**numbers relative to that cell. - Similarly, if you want to lock the column number then put a dollar
**($)**sign before the column number. As an outcome, if you copy and paste the formula to other cells it will change only**Row**numbers relative to that cell.

## Remove Dollar Sign in Excel Formula: 2 Simple Methods

Now, if you want to remove the dollar signs in formulas in your Excel worksheet, we are here to help you with 2 quick methods. Before starting, have a look at the following screenshot of a dataset that has formulas with dollar signs in them.

### 1. Use F4 Key to Remove Dollar Sign in Excel Formula

To remove the Dollar ($) sign from any Excel Formula, you can use the **F4 **key. This shortcut works in Excel by default.

**📌**** STEPS:**

- First, go to the cell which you want to edit. And double click on it to open the edit mode.

- Then, press the
**F4**key on the keyboard once. - As a result, you will see that the Dollar sign before the
**Column**name is removed.

- Then, press the
**F4**key again. - You will see that the Dollar sign before the
**Row**number is removed but the Dollar sign before the**Column**name returns again.

- At last, press the
**F4**key again - And, you will see both Dollar signs will go away.

- Now, you can do similar steps for the other cells to remove the
**Dollar**sign from them

**Read More: **How to Remove Pound Sign in Excel

### 2. Remove Dollar Sign in Excel Formula Manually

For this, just go to the cell and double-click on the cell to open the edit option. Alternatively, click on the cell and go to the Formula bar. Then remove the **Dollar **sign by using backspaces on the keyboard.

**Download Practice Workbook**

You can download the practice workbook from here:

## Conclusion

In this article, you have learned how to remove the Dollar sign in Excel formula. You should try these methods yourself. I hope you found this article helpful. If you have any queries or recommendations, please share them in the comments section below. Keep learning new methods and keep growing!

## Related Articles

- How to Remove Currency Symbol in Excel
- How to Remove Dollar Sign in Excel
- How to Remove Plus Sign in Excel
- How to Remove Negative Sign in Excel
- How to Remove Percentage Symbol in Excel
- Remove Percentage Symbol in Excel Without Changing Values
- How to Remove Sign from Numbers in Excel

**<< Go Back to Remove Symbol in Excel | Excel Symbols | Learn Excel**