Thread: change...
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Mark Lincoln
 
Posts: n/a
Default change...

An alternative is to select both sheets before typing in the original
value. If you type in "5" in A1 of one of the sheets, A1 will show "5"
in both sheets.

When you want to change the value of A1 in Sheet1 but leave the value
of A1 in Sheet2 unchanged, make sure Sheet1 is the only active sheet
before entering the new number.