How to Make a Duplicate of an Excel Workbook?

To make a duplicate of an Excel workbook, use the "Save As" function and create a copy. Here's how:

Steps to Duplicate an Excel Workbook

1. Open the workbook you want to duplicate in Excel.
2. Go to File > Save As. This opens the Save As dialog box.
3. Choose a location to save the copy.
4. In the "File name" field, you can either enter a new file name or keep the suggested name that Excel provides, which typically adds "-Copy" to the existing filename.
5. Click Save. This will create a new, independent copy of your Excel workbook.

Important Considerations:

• The original workbook will remain open. The duplicate workbook will open in a new window if Excel is configured to open each workbook in a separate window.
• The copied workbook will contain all the data, formulas, formatting, and other properties of the original workbook.
• Any changes made to the original workbook after the copy is created will not be reflected in the copy, and vice versa. They are now two separate files.

This process effectively creates a standalone duplicate of your Excel workbook, allowing you to work on either version without affecting the other.