See all How-To Articles

Change / Reverse Signs of Values in Excel & Google Sheets

This tutorial demonstrates how to change the signs of values in Excel and Google Sheets.

 

reverse signs initial data

 

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.

 

reverse signs initial data

 

As shown, income values have negative signs while expenses are positive. To correct this and change signs, follow these steps:

  1. Multiply by a constant with Paste Special. First enter -1 in an empty cell (here, cell F2).

 

reverse signs 1

 

  1. Right-click the cell with the value -1 (F2), and select Copy (or use the keyboard shortcut CTRL + C).

 

reverse signs 2

 

  1. Select and right-click the range where you want to reverse signs (here, C2:D9), and choose Paste Special.

 

reverse signs 3

 

  1. In the Paste Special window, select Multiply, and click OK.

 

reverse signs 4

 

As a result, all values from the paste range are multiplied by the copied value (-1), and signs are reversed.

 

reverse signs final

 

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.