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
|