Enter 1.01 in an empty cell.

Copy it.

Select the range of cells you want to increase by 1%. Paste
special--Multiply.

Click ok.

Dave
--
Brevity is the soul of wit.


"michelplantz" wrote:

I need to increase a column of dollar values by 1%. Is there a formula or
function that will allow me to do this in a simple way, without having to
enter a formula for each one? This will be a yearly thing I need to do and
the formula or function needs to be kept hidden.