Question: how to subtract one value from multiple cells in excel?
Answer: Just insert 500 in any empty cell. Copy this cell (Ctrl+C). Select all cells where you want subtract this value and press Ctrl+Shift+V. Select "Subtract" and "OK".