✦Template Printable Ideas Insights

Duplicate Excel Workbook: Quick Guide to Copy or Clone

By

Ever found yourself in a situation where you needed to use the same Excel workbook multiple times, but editing the original seemed risky? Or perhaps you wanted to try out some changes without affecting the original data? Well, creating a copy of your Excel workbook is the solution. In this step-by-step guide, we'll walk you through the process, ensuring you're left with an exact duplicate ready for your adjustments.

Before we dive in, it's important to note that creating a copy of a workbook doesn't duplicate any linked data or charts. If your original workbook contains such elements, you'll need to re-link or re-create them in the copied version. Now, let's get started!

Creating a Copy of an Excel Workbook Manually

This method is straightforward and doesn't require any additional software. It's perfect for simple workbooks with minimal linked elements.

How to Create a Workbook in Excel?
How to Create a Workbook in Excel?
Workbook in Excel
Workbook in Excel
Copy a Worksheet into New Workbook Using Macros | MyExcelOnline
Copy a Worksheet into New Workbook Using Macros | MyExcelOnline

Here's how to do it:

Copying the Workbook File

To create a copy of your Excel workbook, you'll first need to copy the original file.

Excel VBA Copy Data from Multiple Workbooks
Excel VBA Copy Data from Multiple Workbooks
How to Copy Multiple Sheets in Excel to New Workbook (3 Methods)
How to Copy Multiple Sheets in Excel to New Workbook (3 Methods)
Simple Excel Practice Exercise for Beginners
Simple Excel Practice Exercise for Beginners

1. Locate your original workbook in File Explorer (Windows) or Finder (Mac). 2. Right-click (Windows) or control-click (Mac) on the file. 3. Select 'Copy' from the context menu. 4. Paste the file into the same or a different folder where you want your copy to reside. 5. Rename the copied file if needed. For instance, you could add "-copy" to the end of the original file name.

Renaming the Workbook's Reference

After copying the file, you'll need to make one more change to ensure you're working on the correct version.

1. Open the copied file. 2. Click on the 'File' tab at the top-left corner of the screen. 3. In the 'Info' section, under 'Properties', click on the 'Edit Properties' option. 4. Change the 'Title' field to something that clearly distinguishes it from the original (e.g., "Copied - Original Name"). 5. Click 'OK' to save your changes.

Excel VBA to Copy Multiple Sheets to New Workbook
Excel VBA to Copy Multiple Sheets to New Workbook
How to combine multiple workbooks into one master workbook in Excel?
How to combine multiple workbooks into one master workbook in Excel?
a notebook with microsoft excel written on it
a notebook with microsoft excel written on it
a laptop computer sitting on top of a desk next to a mouse and keyboard with the words microsoft excel free for beginners
a laptop computer sitting on top of a desk next to a mouse and keyboard with the words microsoft excel free for beginners
How to create a list of all worksheet names from a workbook?
How to create a list of all worksheet names from a workbook?
excel basics tutorial
excel basics tutorial

Creating a Copy of an Excel Workbook Using VBA

If you're working with a complex workbook that has many linked data or charts, or if you need to create many copies of the same workbook, using VBA (Visual Basic for Applications) can streamline the process.

Here's a simple VBA script that duplicates an entire workbook:

Adding the VBA Script

First, you'll need to add the script to your workbook.

41K views · 385 reactions | Learn how you can properly copy your formulas from one workbook to another with this simple trick 💡 📬 Don’t forget to share this post! 🗂️ Remember to save it for future reference. #exc | ExcelCamp
41K views · 385 reactions | Learn how you can properly copy your formulas from one workbook to another with this simple trick 💡 📬 Don’t forget to share this post! 🗂️ Remember to save it for future reference. #exc | ExcelCamp
How to copy Page Setup from one worksheet to another worksheet in MS Excel?
How to copy Page Setup from one worksheet to another worksheet in MS Excel?
How to Copy from Excel to Word Without Losing Formatting (4 Easy Ways)
How to Copy from Excel to Word Without Losing Formatting (4 Easy Ways)
How To Automatically Open A Specific Workbook When You Start Excel | MyExcelOnline
How To Automatically Open A Specific Workbook When You Start Excel | MyExcelOnline

1. Press 'Alt + F11' to open the Visual Basic Editor. 2. In the 'Project' window, click 'Insert' and then 'Module' to add a new module. 3. Copy and paste the following script into the module:

Sub DuplicateWorkbook() ' Create a new workbook with the same name as the active one Dim newWB As Workbook Set newWB = ActiveWorkbook ' Rename the new workbook newWB.Name = "Copied - " & ActiveWorkbook.Name ' Rename the active workbook ActiveWorkbook.Name = "Original - " & ActiveWorkbook.Name End Sub

Running the VBA Script

Now that you've added the script, you can run it to create a copy of your workbook.

1. Press 'Alt + F11' to open the Visual Basic Editor. 2. Press 'F5' to run the script. 3. Once the script has run, close the Visual Basic Editor.

With this, you've successfully created a copy of your Excel workbook, ensuring you have a safe and editable version to work with. The next step? Dive in and make those changes you've been putting off!