EXCELL 2002 ON WINDOWS XP

  • Thread starter Thread starter J CADENA
  • Start date Start date
J

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
 
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
 
Back
Top