Written by Allen Wyatt (last updated June 19, 2021)
This tip applies to Excel 2007, 2010, 2013, 2016, 2019, and 2021
There may be times when you want to make a copy of a workbook, without affecting the original. Excel provides an easy way to do this. Simply follow these steps:
The workbook that is opened uses the same file name, but Excel attaches some sort of phrase to the beginning of the file name, as a prefix. For instance, you might see the file name prefixed with "Copy of" or "Copy (1)." Thus, if the original workbook you selected in step 2 is named "Budget.xlsx," what Excel creates is a workbook named "Copy of Budget.xlsx" or "Copy (1)Budget.xlsx." If you want to rename the file, you will need to either use the Save As command, or rename the workbook after closing it.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (8036) applies to Microsoft Excel 2007, 2010, 2013, 2016, 2019, and 2021. You can find a version of this tip for the older menu interface of Excel here: Creating a Workbook Clone.
Save Time and Supercharge Excel! Automate virtually any routine task and save yourself hours, days, maybe even weeks. Then, learn how to make Excel do things you thought were simply impossible! Mastering advanced Excel macros has never been easier. Check out Excel 2010 VBA and Macros today!
All good things must come to an end at some point. When you are done sharing your workbook with others, this is how you ...
Discover MoreIf you work with multiple workbooks at the same time, you might wonder how to tie them together so they open and close at ...
Discover MoreWhen you open a workbook, Excel displays the worksheet that was visible when the workbook was last saved. You may want, ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
2022-03-10 03:34:26
ahmetgns
Again me! In Word, File>Open>Recent list>right click>Open as copy opens a copy but name the document as Document1, not appending 1 the original name. I know this is Excel forum but any solution to this problem is welcome.
2022-02-18 03:16:00
ahmetgns
If right click on a file in the File>Open>Recent list and select "Open as copy" (must be like this in English version) it opens and adds "1" (one) to the file name but does not save a copy on disk, until you click on Save (or Save as...) and select a directory. This is good.
But the way you are describing above saves a copy on disk with a "Copy of " prefix. This is just wrong. Or simply I don't like it since I open as copy just to check some value in the file and close it, without preventing other colleagues on the network who may want to edit file while I am viewing it. Since this file is on a network directory, if I forget to delete the copy after opening it as copy and then closing, it may remain there for long time and confuse my colleagues as which file is being updated and up-to-date.
The first way is good but the file must be in the Recent section to use that way, which may not always be the case.
2021-06-19 09:01:23
Workbook clone: using Windows Explorer, Ctrl+C, Ctrl+V takes about one second to create the clone.
Got a version of Excel that uses the ribbon interface (Excel 2007 or later)? This site is for you! If you use an earlier version of Excel, visit our ExcelTips site focusing on the menu interface.
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2025 Sharon Parq Associates, Inc.
Comments