1. Enter the numbers as usual, after finishing all entries, do the following:
2. Go to any other empty cell, and type '-1' and copy it, now select the entire column you want to make negative.
3. Right-click on the selection and select 'Paste Special..'
4. Choose 'All' and 'Multiply' and click OK, as shown in the picture below: Now all the selected cells will be negative. Now delete the cell value '-1' you copied from.
Or you can use VBA
. I often use the first method to perform tasks for https://assignment.essayshark.com/finance-help.html
. For me it is simpler and more understandable, besides, I'm already used to this action.