TheExcelAddict .com
Microsoft Excel 'Quick Tip'

Open As Copy

How many times have you done this. You want to create a new workbook based on an existing workbook. You open the original file with the intention of using the Save As command to save the file with a new name. BUT you forget, make major changes, and overwrite the original file. Ouch! Over the years that I've been using Excel, I have made that same mistake too many times. Fortunately, since Excel 2000, there's a safer way to create a new workbook based on an existing one.

Select File, Open and browse to the folder of the workbook you want to duplicate. In the Open dialog box, click on the small drop-down arrow on the Open button and you will see several options including Open As Copy. Select Open As Copy and a new workbook identical to the original will be created (with no risk of overwriting the original).

Note that when you select Open As Copy, Excel immediately creates an identical workbook and saves it to the same folder as the original with the name "Copy of original filename". Even if you close this workbook without saving it, the duplicate file will still remain in the folder. If you use Save As to save this workbook with a different name, you may want to delete the "Copy of" version from the folder.

Why not print (CTRL+P) this tip and
share it with your friends and associates?

Get more time-saving tips just like this one delivered to you by email every week in my FREE newsletter "Spreadsheet Tips From An Excel Addict".
Subscribe at the TheExcelAddict.com/Newsletter.htm and you could win a really cool prize.
You'll be amazed how much time you'll save just by learning a few of these tips.
Copyright All Rights Reserved by

Close this window