Articles → EXCEL → Copy Worksheets In Excel

Copy Worksheets In Excel

In this article I will explain how to copy worksheets in excel.

Software Requirement

Before you start reading this tutorial you should make sure that excel 2007(or above) is installed on your machine.

Prerequisite Knowledge

Before you go ahead, it is required that you should know basics about excel.

Open A New Excel

First of all open a new excel and save it with the name ‘Copy_worksheet_Demo.xlsx’ (you can give any name).

Add Data In Excel

For this tutorial I am adding following data in excel file

Picture showing the sample excel file for copying worksheets

Click to Enlarge

Copy Worksheets

To copy a worksheet

Select a worksheet
Right click on it
Select ‘Move or Copy..’ option

Picture showing the Move or Copy... option on the context menu of the tab

Click to Enlarge

A window appears as shown in figure below

Click to Enlarge

Here we have 2 sections

‘To Book:’ - Which worksheet you want to move. Basically the worksheet you have selected appears in the drop down.
‘Before sheet:’ – Before which worksheet you want to insert the selected worksheet. For example you have selected ‘Sheet3’ then ‘Sheet1’ will be moved between ‘Sheet2’ and ‘Sheet3’. If you select the option ‘(move to end)’ then the worksheet will be moved to the last.

More About ‘To Book’: Section

If you expand the ‘To Book:’ section then you can see one more value i.e. ‘(new book)’. Once you select this option and click ‘Ok’ a new excel work book has been created with single worksheet.

Picture showing the new excel file created when user selected the new excel in To Book: section

Click to Enlarge

And in the first workbook, ‘Sheet1’ will be deleted.

Picture showing the sample excel file with the deleted worksheet

Click to Enlarge

How Things Will Change If We Select 'Create A Copy' Option?

If you select ‘Create a copy’ option then the original work sheet will remain at the same position. For example if I select ‘(move to end)’ option along with ‘Create a copy’, then the resultant workbook will be

Picture showing the copy of worksheet when using create a copy option

Click to Enlarge

In the similar way if I select ‘(new book)’ option from ‘To book:’ along with ‘Create a copy’, then a new workbook with a single worksheet will be added, but other workbook remain intact.

Picture showing the new excel file when user selects new workbook from To Book section and Create copy option

Click to Enlarge

Posted By -	Karan Gupta

Posted On -	Sunday, March 2, 2014

Query/Feedback

Your Email Id		**

Subject		*

Query/Feedback	Characters remaining 250	**