If you select multiple sheets BEFORE making a change to a cell then that change will be made on all the selected sheets.

To select multiple sheets, you either hold the Shift key (to select from the current sheet to the sheet you click on) or Ctrl key (to individually select/deselect sheets) before clicking on other sheet tab names.

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia