The simplest way to copy a workbook

The fastest way to copy an Excel workbook is to close it, then right-click the file in File Explorer (Windows) or Finder (Mac) and select "Copy". Navigate to where you want the duplicate to live, right-click the empty space, and select "Paste". This creates an exact duplicate with a new filename — usually the original name plus "- Copy".

This method works because Excel files are just files on your computer, like photos or documents. You are not copying the spreadsheet through Excel itself; you are copying the container. Everything inside — formulas, formatting, data, charts — comes along unchanged.

If the workbook is currently open in Excel, close it first. Copying a file while it is open can sometimes create a partial or corrupted copy, especially on shared network drives.

Key Takeaways

  • The easiest method is to close the workbook, then right-click the file in File Explorer or Finder and select Copy, then Paste it in the destination folder.
  • You can also copy a workbook from inside Excel by going to File > Save As and choosing a new filename and location, which creates the duplicate and opens it automatically.
  • If you only need to copy specific sheets rather than the entire workbook, you can right-click a sheet tab, select Move or Copy, and choose to create a copy in the same or a different workbook.
  • Copying a workbook preserves all formulas, formatting, and data exactly as they were in the original.

Copying a workbook using Save As

If the workbook is already open, the quickest path is to use Save As. Click File in the top-left corner, then select "Save As". A dialog box opens showing your current location and filename.

Change the filename to whatever you want the copy to be called. You can also change the folder by clicking the folder dropdown or the "Browse" button. Once you have entered a new name and location, click the Save button. Excel closes the original and opens the copy you just created.

This method is useful because it saves you a step — you end up with the copy already open and ready to work on. The original file remains untouched in its original location.

Copying individual sheets to a new workbook

Sometimes you do not need to copy the entire workbook — you only need one or two sheets. Right-click the sheet tab at the bottom of the screen (the tab that shows the sheet name, like "Sheet1" or "Sales Data"). A menu appears with several options.

Select "Move or Copy". A dialog box opens showing all the sheets in the current workbook. At the bottom, there is a checkbox that says "Create a copy". Check that box. Then select where you want the copy to go: you can place it in the current workbook (which creates a duplicate sheet in the same file) or in a different workbook.

If you choose a different workbook, Excel opens a file browser. Select the workbook you want to copy the sheet into, or create a new blank workbook by selecting "New Book" from the dropdown at the top of the dialog. Click OK, and the sheet is copied to that location with all its data and formulas intact.

Copying a workbook to cloud storage

If your workbook is stored on OneDrive, Google Drive, or another cloud service, the copy process is the same — use File Explorer or Finder to right-click and copy, or use Save As from inside Excel. The copy is created in the cloud just as it would be on your local hard drive.

One thing to watch: if you are working on a file that is syncing to the cloud, wait for the sync to finish before copying. You can usually see a small icon next to the filename in File Explorer that shows whether the file is still uploading. Once that icon disappears, the file is fully synced and safe to copy.

After you copy a cloud file, both the original and the copy will sync separately. Changes you make to one will not affect the other.

What happens to links and references when you copy

If your workbook contains formulas that reference other files — for example, a formula that pulls data from a different Excel workbook — those references stay exactly as they were. The copy will still point to the original files it was linked to.

This is usually what you want. But if you are copying a workbook specifically to work with a different version of the data it references, you will need to update those links manually. Open the copy, go to File > Info, and look for a "Edit Links" button. From there you can point the formulas to the new data source.

If you are unsure whether your workbook has external links, the safest approach is to open the copy and check whether all the numbers look correct. If a formula is pointing to a file that no longer exists or has moved, Excel will show an error or a zero instead of the expected value.

Copying a workbook with macros or VBA code

If your workbook contains macros (automated tasks you have recorded or written), those macros copy along with the file. The copy will have the exact same macros as the original, and they will work the same way.

However, if you plan to modify the macros in the copy, be aware that the original will not be affected. Macros are stored inside the workbook file itself, so each copy is independent. If you want both versions to have the same macro, you will need to update both files separately, or update the original and then copy it again.

Renaming the copy so you do not confuse it with the original

When you copy a workbook using right-click and paste, Windows and Mac automatically add "- Copy" to the filename. This makes it straightforward to spot the duplicate. But if you create multiple copies, you might end up with "- Copy", "- Copy (2)", "- Copy (3)", and so on, which gets confusing fast.

A better approach is to rename the copy to something that describes what it is for. For example, if you copied a budget spreadsheet to create a version for a different department, name it "Budget 2024 - Marketing" instead of "Budget 2024 - Copy". Right-click the file, select "Rename", type the new name, and press Enter.

If you use Save As instead of the copy-and-paste method, you can give the file its final name right away, which saves this extra step.

Frequently Asked Questions

Can I copy a workbook that is open in Excel on someone else's computer?

Not directly — you cannot copy a file that another user has open on a network. Wait until they close it, or ask them to save and close it. If the file is on a shared drive and you both need to work on it, consider using Excel's co-authoring feature instead, which lets multiple people edit the same file at the same time.

Does copying a workbook also copy the file size?

Yes. The copy is an exact duplicate, so it takes up the same amount of storage space as the original. If your original file is 5 MB, the copy will also be 5 MB. If you are running low on storage, you may need to delete the original or move one of the copies to external storage.

What if I copy a workbook and then delete the original by mistake?

The copy is completely independent and will continue to work normally. Deleting the original does not affect the copy at all. However, if the original workbook contained external links that the copy was referencing, those links may break. Check the copy to make sure all formulas are still calculating correctly.

Can I copy a workbook from an older version of Excel to a newer one?

Yes. Excel files are backward and forward compatible across most versions. A workbook created in Excel 2016 will open and copy normally in Excel 2024, and vice versa. The only exception is very old files (pre-2007), which may need to be converted first.