paste special
This really is a powerful tool.
We all know about copy and paste. Here are a set of options that allow the Excel user to paste the elements that they want from the cells. That could be formulas, formats, values or comments. But there are other tools here too.
Look at the Operation section, You can use this tool to convert negative numbers to positives (by multiplying a range by -1).
