How to Create a Duplicate Identical Copy of Worksheet in Office Excel如何创建一个重复完全相同的副本，工作在Office Excel
In Microsoft Office Excel (including Excel 2003 and Excel 2007), user can easily create another duplicate copy of worksheet that has the exactly identical contents and data from the original sheet.在Microsoft Office Excel （包括Excel 2003和Excel 2007年） ，用户可以轻松地创建另一个复本的工作具有完全相同的内容和数据从原来的资产负债表。 Creating another copy of worksheet is useful if user want to try out new formula, calculation, font, format or other changes, and don’t want to risk messing up the original version, or want to be able to quickly revert to original worksheet when anything goes wrong.创建另一个副本的工作是有益的，如果用户想尝试新的公式，计算，字体，格式或其他变化，不想搞乱风险的原始版本，或者希望能够很快恢复到原来的工作时任何事情都会发生错误的。
To create another exact identical copy of worksheet, press and hold Ctrl key, then click on the tab of the sheet that want to create a copy and drag the cursor in the form of tab with plus sign to the left or right past the original tab location of the spreadsheet or workbook (if the tab location is already far left or far right, you can only drag it to the right or left respectively).要创建另一个确切完全相同的副本，工作，按住Ctrl键 ，然后按一下标签上的表要创建一个副本并拖动光标的形式标签，加号的左边或右边过去的原始标签位置的试算表或工作簿（如标签的位置已经是最左边或最右边，你只能将它拖曳到左边或右边分别） 。 The new location user drop the tab-cursor will be the location of the new duplicate worksheet tab.新的位置的用户下降的标签，将光标的位置，新的重复工作标签。
Alternatively, right click on the tab of worksheet to duplicate, the select Move or Copy .或者，右键点击标签，工作重复，在选择移动或复制 。
Then, on “Move or Copy” dialog box, tick the check box for Create a Copy , and select the location of the new tab for the exactly duplicated worksheet.然后，在“移动或复制”对话框，剔复选框创建一个拷贝 ，并选择位置的新标签的完全重复的工作。 User can even create the new copy of sheet in another workbook.用户甚至可以创建新的副本，资产负债表在另一个工作簿。 Click OK when done. 时 ，单击确定完成。
IMPORTANT : You're reading a machine translated page which is provided "as is" without warranty. 重要：您正在阅读的机器翻译网页这是“原样”提供，无保修。 Unlike human translation, machine translation does not understand the grammar, semantics, syntax, idioms of natural language, thus often produce inaccurate and low quality text which is misleading and incomprehensible.不同人的翻译，机器翻译不明白的语法，语义，句法，成语自然语言，因此，往往产生不准确，低质量的文字这是误导和费解。 Thus, please refer to因此，请参阅 original English article英文原文的文章 when in doubt.当怀疑。
Related Articles相关文章
- How to Change the Microsoft Office Excel Protect Sheet Password如何更改的Microsoft Office Excel密码保护工作表
- Create a Portable Workspace with Tiny USB Office创建工作同可携式微型USB接口处
- EjectMe! EjectMe ！ Yahoo!的Yahoo ！ Widget Download to Eject and Close Optical Drive from Desktop部件下载弹出和关闭光盘驱动器从桌面
- SecureZIP 12 Free Full User License Product with Key Download SecureZIP 12日全部免费用户许可产品的关键下载
- Remove Password and Unlock Protected PDF Which Allowed To Be Printed Without Knowing Secret删除密码和解锁受保护的PDF格式，使印制不知道的秘密
- Design TipandTrick Fonts Online with FontStruct Font Builder TipandTrick字体设计在线FontStruct字体建设者
- Backup and Disk Imaging via Macrium Reflect Free Edition备份和磁盘影像通过Macrium反映免费版
- Fix Error Cannot Install WGA or OGA Plugin (WGAPluginInstall.exe and OGAPluginInstall.exe) in Firefox修正错误无法安装WGA或属于正版插件（ WGAPluginInstall.exe和OGAPluginInstall.exe ）在Firefox
- Backup Email Database with Amic Email Backup数据库备份电子邮件与朋友的电子邮件备份
- Create, Convert and Print to PDF Documents with PrimoPDF Free Acrobat Creator创建，转换和打印到PDF文档与PrimoPDF免费的Acrobat造物主
