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!雅虎！ 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
- Create, Convert and Print to PDF Documents with PrimoPDF Free Acrobat Creator創建，轉換和打印以PDF文件與primopdf免費的Acrobat創作者
- Backup Email Database with Amic Email Backup備份電子郵件數據庫與amic電子郵件備份
