We can reverse the sign of values quickly with Change Sign of Values feature of Kutools for Excel. And the sign of numbers in the selected range have been reversed at once. Then click Insert > Module, and then copy and paste the following VBA code: Sub Convert()ģ. 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. Select the range you want to reverse the sign of values in cells.Ģ.
But we must know how to get the VBA to do the thing. Download and free trial Now!Īlso, we can use a VBA code to reverse the sign of values in cells. Kutools for Excel: with more than 300 handy Excel add-ins, free to try with no limitation in 30 days. 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. Then click OK, and all of the signs of the numbers in the range have been reversed. In the Paste Special dialog box, click All options from Paste and Multiply option from Operation. Select the range that you want to reverse the sign of values, right-click and choose Paste Special. Tap number -1 in a blank cell and copy it.Ģ. We can reverse the sign of values in cells with the Paste Special function in Excel, please do as follows:ġ. Reverse the sign of values in cells with Kutools for Excel quickly Reverse the sign of values in cells with VBA code Reverse the sign of values in cells with Paste Special function Are there any quick tricks to solve this problem? 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.
Supposing we need to change the positive numbers to negative and vice versa. When we use excel, there are both positive and negative numbers in a worksheet. How to reverse signs of values in cells in Excel?