Excel 2013

How to Create A Workbook Clone in Excel

There may come a  time when you would like to make a copy of your workbook, without affecting the original. Excel does provide an easy method to do this.

Follow the steps below to learn how:

  1. Display the Open dialog box. (If you are using Excel 2007, click Office button | Open. If you are using Excel 2010 , click File | Open. If you are using Excel 2013, click File | Open | Computer |Browse.
  2. Select the workbook you would like to make a copy of.
  3. Click on the down-arrow on the right-hand side of the Open button. Excel will displas a list of different ways you can open the selected workbook.
  4. Select Open As Copy . Excel will  open a copy of the workbook.

The workbook that has been opened will use the same file name, but Excel will attach something at the beginning of the file name, as a prefix. For instance, you might see the file name prefixed with Customers copy or Copy (1). Thus, if the original workbook you selected in above is named Customers.xlsx, Excel will create 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.