Question: how do you subtract multiple cells from a fixed number?
Answer: Place the cursor in the subtraction number position (cell B1) Do a copy (CTRL+C) Make a range A1:A10, containing the numbers that will be subtracted. Do a paste special (CTRL+ALT+V) Select “Subtract” in the Operation section. Click the OK button.