Question: how to subtract the same number from a column in excel?
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.