View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben
 
Posts: n/a
Default change values globally

Mike

Enter 1.10 in a cell.

Copy that cell.

Select all other cells to be changed and Paste SpecialMultiplyOKEsc.

Delete the cell with 1.10.


Gord Dibben Excel MVP

On Wed, 16 Nov 2005 10:22:55 -0800, "MIke"
wrote:

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