How to Create a Duplicate Identical Copy of Worksheet in 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. 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). 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.

Related Articles

• How to Change the Microsoft Office Excel Protect Sheet Password
• Create a Portable Workspace with Tiny USB Office
• EjectMe! Yahoo! Widget Download to Eject and Close Optical Drive from Desktop
• SecureZIP 12 Free Full User License Product with Key Download
• Remove Password and Unlock Protected PDF Which Allowed To Be Printed Without Knowing Secret
• Design TipandTrick Fonts Online with FontStruct Font Builder
• Backup and Disk Imaging via Macrium Reflect Free Edition
• Fix Error Cannot Install WGA or OGA Plugin (WGAPluginInstall.exe and OGAPluginInstall.exe) in Firefox
• Create, Convert and Print to PDF Documents with PrimoPDF Free Acrobat Creator
• Backup Email Database with Amic Email Backup

This entry was posted on Tuesday, May 20th, 2008 at 12:09 am and is filed under Office. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.