Copy Worksheet
First of all, 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.
| OrderDate | Region | Rep | Item | Units | Unit Cost | Total |
|---|---|---|---|---|---|---|
| 1/6/2010 | East | Jones | Pencil | 95 | 1.99 | 189.05 |
| 1/23/2010 | Central | Kivell | Binder | 50 | 19.99 | 999.5 |
| 2/9/2010 | Central | Jardine | Pencil | 36 | 4.99 | 179.64 |
| 2/26/2010 | Central | Gill | Pen | 27 | 19.99 | 539.73 |
| 3/15/2010 | West | Sorvino | Pencil | 56 | 2.99 | 167.44 |
| 4/1/2010 | East | Jones | Binder | 60 | 4.99 | 299.4 |
| 4/18/2010 | Central | Andrews | Pencil | 75 | 1.99 | 149.25 |
| 5/5/2010 | Central | Jardine | Pencil | 90 | 4.99 | 449.1 |
| 5/22/2010 | West | Thompson | Pencil | 32 | 1.99 | 63.68 |
| 6/8/2010 | East | Jones | Binder | 60 | 8.99 | 539.4 |
| 6/25/2010 | Central | Morgan | Pencil | 90 | 4.99 | 449.1 |
| 7/12/2010 | East | Howard | Binder | 29 | 1.99 | 57.71 |
| 7/29/2010 | East | Parent | Binder | 81 | 19.99 | 1,619.19 |
| 8/15/2010 | East | Jones | Pencil | 35 | 4.99 | 174.65 |
 |
| Excel Sample Text |
Here are the steps to copy an entire worksheet.
Step 1 − Right Click the Sheet Name and select the Move or Copy option.
 |
| Copy Sheet |
Step 2 − Now you'll see the Move or Copy dialog with select Worksheetoption as selected from the general tab. Click the Ok button.
 |
| Move Dialog |
Select Create a Copy Checkbox to create a copy of the current sheet and Before sheet option as (move to end) so that new sheet gets created at the end.
Press the 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, the sheet name becomes editable. Enter any name say Sheet5 and press Tab or Enter Key.
