- Open the Excel workbook you need.
 - Select which sheets need to be edited.
 - Using the sheet tabs, select one sheet, open it and make the changes.
 - Go back to the tab panel 
and select the sheet you just edited. - Press and hold the Ctrl key and select the sheet tabs of the other sheets you want to edit.
 - Make the changes in all selected sheets.
 - Save the workbook.
 
