How to move or copy worksheets in Excel

This is a short tutorial is about the steps required for moving or copying worksheets in Excel 2016 and Excel 2013. Excel users can copy or move users using the right click context menu or Format menu options.

image

Step 1: Select the Sheet tab that needs to be copied or moved. If you want to copy or move more than one Worksheets then press Ctrl key on the Keyboard and select the Sheet tabs.

Step 2: Right on selected Sheet tabs and select Move or Copy from the menu list.

image

Or you use Format menu option and select Move or Copy Sheet from the dropdown list.

image

This should then display the following “Move or Copy” Window.

image

Step 3: Now if you want to move the worksheet within the same workbook then choose the sheet under “Before Sheet”. And to move or copy the Worksheets to different workbook, click To book dropdown and select the Workbook (The “To book” dropdown will list only the open workbooks.).

image

In order to copy worksheets, make sure to mark the check box with caption as “Create a copy”.

 

 

 

 

 

 

In Category: Excel 2013, Excel 2016, MS Office

Ravi Shankar

A Software developer and blogger who is always looking to provide technical help to the wider community.

Show 1 Comment

Leave a Comment

Get your free copies of the following tech guides by joining the Digital Answers mailing list.