Excel 简明教程

Copy Worksheet in Excel 2010

Copy Worksheet

首先，在我们继续之前，让我们创建一些样本文本。打开一个新的 Excel 工作表并输入任意数据。我们在屏幕截图中显示了一个样本数据。

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

以下是复制整个工作表步骤。

Here are the steps to copy an entire worksheet.

Step 1 − 右键单击 Sheet Name 并选择 Move or Copy 选项。

Step 1 − Right Click the Sheet Name and select the Move or Copy option.

Step 2 − 现在您将看到“移动或复制”对话框，并从常规选项卡中选择 Worksheet 选项。单击 Ok 按钮。

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

选中 Create a Copy 复选框以创建当前工作表的副本，并为“工作表前”选项选择 (move to end) ，以便在最后创建一个新的工作表。

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.

按 Ok 按钮。

Press the Ok Button.

现在应该有如您在下所示的已复制的工作表。

Now you should have your copied sheet as shown below.

您可以通过双击来重命名该工作表。双击后，工作表名称便可编辑。输入任意名称（例如 Sheet5），然后按 Tab 或 Enter 键。

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.