I have a worksheet that has a column for quantities, I have to subtract 1
from the quantity of 120 rows. Other than doing it manually can I select
those rows and do something that will subtract 1 from each of the cells I
select.

In other words if a cell currently has 9 and need it to be changed to 8

Thanks