Question: how to make a formula in excel negative?
Answer: Highlight the range that you want to change, then right-click and choose Paste Special from the context menu to open the Paste Special dialog box. ... 
Then select All option from the Paste, and Multiply from the Operation.