Enter 1 in a free cell and copy that cell to the clipboard, Ctrl-C

Select all the numbers to be actioned

Goto EditPasteSpecial, and in the Operation section, click the Subtract
option

OK out and clear the 1 from the previous cell

--
__________________________________
HTH

Bob

"Nobody" wrote in message
...
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