In such cases, you can use macros coded in VB Script to quickly make as many duplicates as you need to. For example, you might need to make 20 copies of a worksheet to say, track transactions in different locations. There might be some special situations where you would want to make multiple duplicates of a sheet. Making Multiple Duplicates of a Sheet (Using VBA) Make sure you release the CTRL or Shift key before pressing down the CTRL key again for step 2. If you want to duplicate multiple sheets, you can select the sheets you want to duplicate, and then follow steps 2 to 4. You should now see a duplicate of your selected sheet at the point where you released your mouse button. Release the mouse button once you find the spot where you want the new sheet to go.
You should see a small arrow at the top of the tabs indicating the position where the newly duplicated sheet will be placed.Hold down the CTRL of your keyboard and use the left mouse button to drag the tab to the right or left, depending on where you want the new duplicate sheet to go.Select the tab of the worksheet you want to duplicate.It lets you duplicate one or more worksheets without having to involve any menus. Using this Method to Duplicate Multiple SheetsĪfter that, follow steps 1 to 7 shown above. You should now see a duplicate of your selected worksheet created in your selected location.Select where you want the duplicate sheet to go.Make sure the checkbox next to ‘ Create a Copy’ is checked.Select ‘ Move or Copy’ from the context menu that appears.
Using the Worksheet tab Context Menu to Duplicate a Sheet in Excel If the sheet tabs are next to each other, you can click on the tab of the first sheet, press down the SHIFT key, and select the last sheet that you want to duplicate.Īfter that, follow steps 1 to 7 shown above. If you want to duplicate multiple sheets, press down the CTRL key and select the sheets you want to copy. Using this Method to Duplicate Multiple Sheets Note: In the Move or Copy dialog box, the drop-down list below ‘ To book’ displays only those workbooks that are currently open. At the end of the workbook’s sheet tab s – For this, from the list below ‘ Before sheet:’ select the ‘ move to end’ option.Before a particular sheet’s tab – For this, from the list below ‘ Before sheet:’, select the sheet before which you want the duplicate sheet to go.If you want the duplicate sheet to go into a new workbook, select the ‘ new book’ option. In a different workbook – For this, select the dropdown list below ‘ To book:’ and select the workbook you want to copy the sheet to.Make sure the checkbox next to Create a Copy’ is checked.This will open the Move or Copy dialog box.From the drop-down menu that appears, select the ‘Move or Copy Sheet’ option.Click on the Format button (under the Cells group).To make a duplicate of the sheet, follow the steps given below: Let’s say “ Sheet 1” is the currently active sheet. Using the Format Menu to Duplicate a Sheet in Excel For each of the methods, we will use the set of worksheets shown below: Let us look at each of these methods one by one. Making Multiple Duplicates of a Sheet (Using VBA)ģ ways to Duplicate One or Multiple Sheets in Excelįirst, let us look at how you can make duplicates of one or more sheets in Excel.Using the Worksheet tab Context Menu to Duplicate a Sheet in Excel.Using this Method to Duplicate Multiple Sheets.Using the Format Menu to Duplicate a Sheet in Excel.3 ways to Duplicate One or Multiple Sheets in Excel.