How to Change Signs of Cells in Excel
To change the signs of cells in Excel, follow these steps:
- Select the range of cells that you want to change the signs of.
- Right-click on the selected cells and choose "Copy" or press "Ctrl+C" on your keyboard.
- Right-click on a blank cell where you want to paste the values and choose "Paste Special" or press "Ctrl+Alt+V" on your keyboard.
- In the "Paste Special" dialog box, check the box next to "Values" and then check the box next to "Multiply" under "Operations".
- In the "Multiply" box, enter and click "OK".
This will multiply all the values in the selected range by -1, effectively changing all the minus signs to plus signs and vice versa.