- 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.