|
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
|