Assuming all cells in your range are numbers, and all numbers need to be
decreased by 1.
Type -1 in a cell, copy that cell
Select your range, Paste Special -- Add

Voila!
--
John C


"Nobody" wrote:

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