Why do I keep forgetting this? To do math on a selection of cells in Excel (like making all the numbers negative for example)
- type the new number in a blank cell (-1 for this example),
- copy it
- select the cells you want to do the math to
- pick paste special
- pick the correct math function under "Operation" (Multiply for this example)
- Click ok