View Single Post
  #1  
Old April 24th, 2004, 03:04 AM
Peter
external usenet poster
 
Posts: n/a
Default Changing a group of entries

Hello,
I am using Excel 97. I am not an advance user by any means.
If I have a spreadsheet with numeric entries, is it possible to apply a same
mathematical formula to all the highlighted entries? For example, if I had
100 numeric entries (10 rows by 10 columns) but I want to change all the
entries of the first 3 columns (30 entries) by reducing them by 25%.
Therefore I want to multiply the entries in the first 3 columns by 0.75. Is
this possible without having to change each and every entry separately?
Thank you very much for your help.

Peter