This tutorial demonstrates how to change the signs of values in Excel and Google Sheets.
Reverse Value Signs
If you need to change (reverse) the signs of values in Excel (from negative to positive, or from plus to minus), you can achieve it easily using Paste Special. Say you have the following data with Income in Column C and Expense in Column D.
As shown, income values have negative signs while expenses are positive. To correct this and change signs, follow these steps:
- Multiply by a constant with Paste Special. First enter -1 in an empty cell (here, cell F2).
- Right-click the cell with the value -1 (F2), and select Copy (or use the keyboard shortcut CTRL + C).
- Select and right-click the range where you want to reverse signs (here, C2:D9), and choose Paste Special.
- In the Paste Special window, select Multiply, and click OK.
As a result, all values from the paste range are multiplied by the copied value (-1), and signs are reversed.
Change the Sign in Google Sheets
Since multiply is not a Paste Special option in Google Sheets, you can use the SIGN Function as an alternative. This function can also be used to reverse signs in Excel.