MS Excel - Copy Worksheet

Advertisements


Copy Worksheet

First let us create some sample text before we proceed. Open a new excel sheet and type any data. We've shown a sample data in the screenshot.

OrderDateRegionRepItemUnitsUnit CostTotal
1/6/2010EastJonesPencil951.99189.05
1/23/2010CentralKivellBinder5019.99999.5
2/9/2010CentralJardinePencil364.99179.64
2/26/2010CentralGillPen2719.99539.73
3/15/2010WestSorvinoPencil562.99167.44
4/1/2010EastJonesBinder604.99299.4
4/18/2010CentralAndrewsPencil751.99149.25
5/5/2010CentralJardinePencil904.99449.1
5/22/2010WestThompsonPencil321.9963.68
6/8/2010EastJonesBinder608.99539.4
6/25/2010CentralMorganPencil904.99449.1
7/12/2010EastHowardBinder291.9957.71
7/29/2010EastParentBinder8119.991,619.19
8/15/2010EastJonesPencil354.99174.65
Excel Sample Text

Here are the steps to copy an entire worksheet

Step (1): Right Click the Sheet Name and select Move or Copy option.

Copy Sheet

Step (2):Now you'll see the Move or Copy dialog with select Worksheet option as selected from the general tab. Click Ok button

Move Dialog

Select Create a Copy Checkbox to create a copy of current sheet and Before sheet option as (move to end) so that new sheet gets created at end.

Press Ok Button

Now you should have your copied sheet as shown below.

Copied Sheet

You can rename the sheet by double clicking on it.On double click, name become editable. Enter any name say Sheet5 and press Tab or Enter Key.



Advertisements
Advertisements