EXCELL 2002 ON WINDOWS XP

[J CADENA]

I need to be able to select several worksheets in file
Do Ctrl+F (to find a record I'm looking for)
Once found, I need to change/enter data for that record
ONLY
PROBLEM
With this version, I noticed that as I add/chg data on a
cell, the program also ENTERS IT in the same cell in all
the selected worksheets.
I Dont want to have to selec/unselect worksheets
everytime I find the record I want to change, just to
prevent data from going into other worksheets.
Help!
Tnx

 

[Richard Choate]

It has always been the case (since Excel97) that if you select multiple
sheets and then type anything into a cell that the same change will occur in
that cell on every sheet. You must have done something different before
because this is not new for XP.
Richard Choate

I need to be able to select several worksheets in file
Do Ctrl+F (to find a record I'm looking for)
Once found, I need to change/enter data for that record
ONLY
PROBLEM
With this version, I noticed that as I add/chg data on a
cell, the program also ENTERS IT in the same cell in all
the selected worksheets.
I Dont want to have to selec/unselect worksheets
everytime I find the record I want to change, just to
prevent data from going into other worksheets.
Help!
Tnx