View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bill Kuunders
 
Posts: n/a
Default change values globally

Assuming the prices are in one column.
Insert a new column next to it.
enter for instance =C2*1.1 and extend down.
select the new prices range <edit< copy
select the top cell of the old prices range <edit<paste special<values
delete the temporary column.

--
Greetings from New Zealand
Bill K
"MIke" wrote in message
...
I have a price book that i made in excel 97. I want to raise the values of
the cells by 10 % with out having to do each cell independently. I would
like
to select all the cells that need to be change and do it globally. Can any
one help