Question: how to copy and paste negative in excel?
Answer: Type negative 1 in any blank cell, copy that cell, select the entire column that you wish to make negative, now 'paste special' selecting options 'values' and 'multiply'. Now all the numbers in this column should be negative.