Duplicate Sheets

With “Duplicate Sheets”, you can quickly duplicate all selected (or grouped) sheets.

To duplicate sheets, follow the steps below:

  1. In the currently active workbook, select the sheet(s) you want to duplicate. You can select more than one sheet. To select multiple sheets, hold the Ctrl key while clicking on the sheet tabs (i.e. the small tabs which contain the names of the sheets at the bottom of the screen).
  2. Run Duplicate Sheets

Tip :
After selecting the sheets you want to duplicate, you can quickly access the Duplicate Sheets function by right-clicking on any of the sheet tabs. A short-cut menu will pop up, with the item “Duplicate Sheets” for you to choose. (Actually, you can access almost all the Excel Power Expander functions from short-cut menus.)