Altering existing data in-situ

  • Thread starter Thread starter Adam
  • Start date Start date
A

Adam

Hi All,

I wonder if anyone can help me. How can I perform a calculation on a
range of cells so that their contents are updated. I can't do it from
another cell as the original cell is referenced from /lots/ of other places.

E.g. I've got a big load of data:

12 45 56
89 56 32
67 76 89 etc...

Which I want to change to:

120 450 560
890 560 320
670 760 890 etc...

Thanks a lot,
Adam
 
one easy way is to put 10 in a cell somewhere. copy that cell>select the
area to modify>edit>paste special>multiply
 
Back
Top