View Categories

How can I edit multiple sheets at once in Excel?

< 1 min read

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

Powered by BetterDocs