How To Copy Excel Worksheet. This example copies worksheets sheet1 sheet2 and sheet4 to a new blank workbook and then saves and closes the new workbook. To copy a worksheet copying all contents of that worksheet to a new worksheet follow the steps below.
Open the excel file with the worksheet you would like to copy. In the certain workbook where you will copy worksheets select multiple worksheets on the sheet tab bar. Put a tick in the create a copy box.
Under before sheet choose where you want to place the copy.
Copy a worksheet in the same workbook right click on the worksheet tab and select move or copy. Hold down the ctrl key on the keyboard while. Then from move or copy box check the box of create a copy with tick and press ok to proceed for creating a copy of that sheet. This example copies worksheets sheet1 sheet2 and sheet4 to a new blank workbook and then saves and closes the new workbook.
