## How to reverse signs of values in cells in Excel?

When we use excel, there are both positive and negative numbers in a worksheet. Supposing we need to change the positive numbers to negative and vice versa. Of course, we can change them manually, but if there are hundreds of numbers need to be changed, this method is not a good choice. Are there any quick tricks to solve this problem?

**Reverse the sign of values in cells with Paste Special function**

**Reverse the sign of values in cells with VBA code**

**Reverse the sign of values in cells with Kutools for Excel quickly**

** Reverse the sign of values in cells with Paste Special function**

We can reverse the sign of values in cells with the **Paste Special** function in Excel, please do as follows:

**1**. Tap number **-1** in a blank cell and copy it.

**2**. Select the range that you want to reverse the sign of values, right-click and choose **Paste Special**. See screenshot:

**3.** In the **Paste Special** dialog box, click** All** options from **Paste** and **Multiply** option from **Operation**. See screenshot:

**4**. Then click **OK**, and all of the signs of the numbers in the range have been reversed.

**5**. Delete the number -1 as you need.

**Reverse the sign of all numbers at once**

**Kutools for Excel**’s **Change Sign of Values** utility can help you to change the positive numbers to negative and vice versa, it also can help you to reverse the sign of the values and fix trailing negative sign to normal. ** Click to download Kutools for Excel!**

**Kutools for Excel**: with more than 300 handy Excel add-ins, free to try with no limitation in 30 days.** Download and free trial Now! **

** Reverse the sign of values in cells with VBA code**

Also, we can use a VBA code to reverse the sign of values in cells. But we must know how to get the VBA to do the thing. We can do it as the following steps:

**1.** Select the range you want to reverse the sign of values in cells.

**2**. Click **Developer** > **Visual Basic** in Excel, a new **Microsoft Visual Basic for applications** window will be displayed, or using the shortcut keys (**Alt+F11**) to active it. Then click **Insert** > **Module**, and then copy and paste the following VBA code:

```
Sub Convert()
Dim C As Range
For Each C In Selection
C.Value = -C.Value
Next C
End Sub
```

**3.** Then click button to run the code. And the sign of numbers in the selected range have been reversed at once.

** Reverse the sign of values in cells with Kutools for Excel quickly**

We can reverse the sign of values quickly with **Change Sign of Values** feature of **Kutools for Excel**.

Kutools for Excel : with more than 300 handy Excel add-ins, free to try with no limitation in 30 days. |

After installing** Kutools for Excel**, please do as follows:

**1.** Select the range that you want to reverse the signs of the numbers.

**2**. Click **Kutools** > **Content** > **Change Sign of Values**…, see screenshot:

**3**. In the **Change Sign of Values** dialog box, check the **Reverse the sign of all values**, see screenshot:

**4**. And then click **OK** or **Apply**. All of the signs of the numbers have been reversed.

The **Change Sign of Values** of Kutools for Excel can also** fix trailing negative signs**, c**hange all negative values to positive** and **change all positive values to negative**. For more detailed information about **Change Sign of Values**, please visit **Change Sign of Values feature description**.

** Click to Download and free trial Kutools for Excel Now! **

** Reverse the sign of values in cells with Kutools for Excel**

**Kutools for Excel**: with more than 300 handy Excel add-ins, free to try with no limitation in 30 days.

**Download and free trial Now!**

**Related articles:**

- Change negative numbers to positive
- Change positive numbers to negative
- Fix trailing negative signs in cells

### Best Office Productivity Tools

**Supercharge Your Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. ** **Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time. Click Here to Get The Feature You Need The Most...**

#### Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier

- Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
- Open and create multiple documents in new tabs of the same window, rather than in new windows.
- Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!