How to Copy or Move Worksheets in Excel
Move Worksheets Within the Same Workbook
To move a worksheet within the same workbook, right-click on the worksheet tab and select "Move or Copy". In the "Move or Copy" dialog box, select the destination workbook from the "To book" dropdown list and click "OK".
Copy Worksheets to a New Workbook
To copy a worksheet to a new workbook, right-click on the worksheet tab and select "Move or Copy". In the "Move or Copy" dialog box, select "Create a copy" and click "OK".
Move or Copy Worksheets in the Same Folder
To move or copy worksheets in the same folder, open both workbooks in Excel. Right-click on the worksheet tab in the source workbook and select "Move or Copy". In the "Move or Copy" dialog box, select the destination workbook from the "To book" dropdown list and click "OK".
Komentar