pastercosmic.blogg.se

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.Right-click on the tab of the worksheet that you want to duplicate.To use this method, follow the steps below: You can also use Excel’s context menu to duplicate one or more sheets. 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.