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: