How To Copy Excel Worksheet. With the move or copy command in excel you can make one copy of a worksheet multiple specific worksheets or all worksheets into active workbook or another workbook at a time. Here s another way to duplicate a sheet in excel that is just as easy.
Hold down the ctrl key on the keyboard while. Simply locate the excel file in your computer and. In the move or copy window in the before sheet section select the worksheet where you want to place the copied worksheet.
This will open the move or copy dialog box.
At the bottom of the excel window right click the worksheet tab you want to copy. Now in the opening copy multiple ranges dialog box check. Copy a worksheet in the same workbook right click on the worksheet tab and select move or copy. Right click on the tab for the worksheet you want to copy and select move or copy from the popup menu.
