How to Make a Copy of an Excel Workbook

The fastest way to make a copy of an Excel workbook is to open the file, go to File > Save As, and save it under a new name or in a new folder. If the file is closed, you can duplicate it straight from File Explorer (Windows) or Finder (Mac) by copying and pasting it — no need to open Excel at all.

This guide covers every reliable way to duplicate an Excel file: the built-in Save As command, File Explorer and Finder copy-paste, the OneDrive and Excel for the web methods, keyboard shortcuts, and how to copy individual sheets instead of the whole workbook. It also fixes the most common errors people hit along the way.

Method 1: Use Save As (the standard way)

Save As is the method most people want. It creates an independent duplicate while keeping the original untouched — perfect for making a backup before editing, or branching a template into a new version.

1. Open the workbook you want to copy.
2. Click File in the top ribbon.
3. Select Save As (or Save a Copy if the file lives in OneDrive/SharePoint).
4. Choose a location — the same folder or a new one.
5. Give the copy a unique file name so you can tell it apart from the original.
6. Confirm the format in Save as type is Excel Workbook (.xlsx), then click Save.

You now have two separate files. Edits to the copy never touch the original. If your workbook contains macros, choose Excel Macro-Enabled Workbook (.xlsm) instead, or the macros will be stripped out. If you simply want to keep saving versions of the same file, see our guide on how to save an Excel file.

Keyboard shortcut for Save As

Action	Windows	Mac
Open Save As dialog	F12	Cmd + Shift + S
Quick Save (overwrites original)	Ctrl + S	Cmd + S

On Windows, pressing F12 jumps straight to the full Save As dialog — the fastest route to a copy. Avoid pressing only Ctrl + S when your goal is a duplicate, because that overwrites the file you have open rather than creating a new one. For a deeper look at version safety, see saving a copy of an Excel file.

Method 2: Copy the file without opening Excel

You don’t actually need to open Excel to duplicate a workbook. This is the quickest approach when the file is already closed, and it copies everything — formatting, macros, and named ranges — byte for byte.

On Windows (File Explorer):

1. Open File Explorer and navigate to the workbook.
2. Click the file once to select it.
3. Press Ctrl + C, then Ctrl + V in the same folder. Windows creates a file named “Original - Copy.xlsx”.
4. Rename it if you like by pressing F2.

On Mac (Finder):

1. Open Finder and locate the workbook.
2. Click the file once, then press Cmd + C followed by Cmd + V. Finder creates “Original copy.xlsx”.
3. Alternatively, select the file and press Cmd + D to duplicate it instantly in place.

Because this method copies the raw file, it’s the most faithful way to clone a workbook with complex formatting or VBA. If you later need to free up space, see how to make an Excel file smaller.

Method 3: Copy a workbook in OneDrive or Excel for the web

When your file is stored in OneDrive or SharePoint, Excel renames Save As to Save a Copy, and there’s also a browser-based route.

• In the desktop app: Click File > Save a Copy, then pick a destination folder and name. This keeps AutoSave intact on the original.
• In Excel for the web: Open the workbook in your browser, then choose File > Save As > Save a Copy (or Make a Copy). The duplicate lands in your OneDrive.
• From OneDrive directly: Right-click the file in the OneDrive web interface and there is no native “duplicate,” so download a copy or use Save a Copy from within Excel instead.

If you collaborate often, our walkthrough on sharing an Excel file with multiple users in Office 365 explains how copies and shared editing interact.

Method 4: Copy a single worksheet instead of the whole workbook

Sometimes you don’t want the entire file — just one tab. Excel’s Move or Copy feature handles this without disturbing the rest of the workbook.

1. Right-click the sheet tab at the bottom of the window.
2. Select Move or Copy.
3. In the To book dropdown, choose an existing workbook or pick (new book) to spin the sheet into a brand-new file.
4. Check the Create a copy box. This is the step people forget — without it, Excel moves the sheet instead of copying it.
5. Click OK.

You can also drag a sheet tab while holding Ctrl (Windows) or Option (Mac) to duplicate it within the same workbook. For more on this, see how to make a copy of an Excel sheet, duplicate a sheet in Excel, and copy an Excel sheet to another sheet.

Method 5: Open as a copy (read-only protection)

If you want to be certain you never accidentally save over the original, open the file as a copy from the start:

1. Go to File > Open.
2. Browse to the workbook but don’t double-click it.
3. Click the small arrow next to the Open button.
4. Choose Open as Copy.

Excel opens a duplicate titled “Copy(1)FileName” and leaves the source file closed and safe.

Choosing the right method

Your situation	Best method
File is open, want a backup before editing	Save As / Save a Copy
File is closed	File Explorer or Finder copy-paste
Need an exact clone with macros	File Explorer / Finder copy
File lives in OneDrive	Save a Copy or Excel for the web
Only need one tab	Move or Copy sheet
Want to avoid overwriting the source	Open as Copy

Troubleshooting common problems

“The document could not be saved” or grayed-out Save As. The original may be open in another window or marked as final. Close other instances, and if it’s locked, see how to make an Excel file read-only to understand the setting. A workbook marked final via Mark as Final must be re-enabled for editing first.

Can’t save on a Mac. Permission and iCloud sync issues are common culprits. Our dedicated fix for when you can’t save an Excel file on Mac walks through the exact settings to check.

The copy is missing macros. You saved as .xlsx instead of .xlsm. Re-save the file as an Excel Macro-Enabled Workbook to preserve VBA code.

You overwrote the original by mistake. Don’t panic. Excel often keeps prior versions — see how to recover a previous version of an Excel file and recover an overwritten Excel file.

The workbook is password-protected. You can still copy the file, but you’ll need the password to open the duplicate. If you set the protection and forgot it, our guide on protecting an Excel workbook explains the options.

Frequently Asked Questions

How do I make a copy of an Excel file?

Open the file and choose File > Save As, then give it a new name or folder. If the file is closed, select it in File Explorer (Windows) or Finder (Mac) and press copy then paste — Windows adds ” - Copy” and Mac adds ” copy” to the new file’s name automatically.

How do I duplicate an Excel file without opening it?

In File Explorer, click the file once and press Ctrl + C then Ctrl + V. On a Mac, select the file in Finder and press Cmd + D to duplicate it instantly, or Cmd + C then Cmd + V. This copies the entire workbook — formatting, macros, and all — without launching Excel.

Is there a keyboard shortcut to copy an Excel workbook?

There’s no single shortcut that clones an entire open workbook, but F12 (Windows) or Cmd + Shift + S (Mac) opens Save As instantly so you can save a copy. In Finder, Cmd + D duplicates a closed file in one keystroke. Note that Ctrl + D inside Excel fills cells downward — it does not copy the workbook.

Can I copy just one sheet instead of the whole workbook?

Yes. Right-click the sheet tab, choose Move or Copy, tick Create a copy, and pick (new book) to send that single sheet into its own new file. See our guide on copying an Excel worksheet for the full walkthrough.

Does copying a workbook keep the copy updated with the original?

No. A copy is fully independent. Changes you make to the original will not appear in the duplicate, and vice versa. If you need linked, auto-updating data instead, look at linking Excel sheets or referencing another sheet in Excel.

How do I copy an Excel file in OneDrive?

Open it in the desktop app and choose File > Save a Copy, or open it in Excel for the web and select File > Save As > Make a Copy. The duplicate is saved to your OneDrive, leaving the AutoSaved original intact.

Wrap-up

Making a copy of an Excel workbook takes seconds once you know which method fits your situation. Use Save As when the file is open, copy-paste in File Explorer or Finder when it’s closed, Save a Copy for OneDrive files, and Move or Copy when you only need a single tab. Whatever route you take, give the copy a distinct name so you never confuse it with the original — and you’ll always have a safe fallback to return to.