Question: how to subtract a number from a whole column in excel?
Answer: Type a number in cells C1 and D1. For example, a 5 and a 3.
In cell E1, type an equal sign (=) to start the formula.
After the equal sign, type C1-D1.
Press RETURN . If you used the example numbers, the result is -2. Notes: