How to Make a Copy of an Excel Workbook (Every Method Explained)

Making a copy of an Excel workbook sounds simple — and often it is. But depending on why you're copying, where you're saving it, and what version of Excel you're using, the right method can look quite different. Here's a clear breakdown of every reliable approach and what each one actually does under the hood.

Why Copying a Workbook Matters More Than You'd Think

A workbook copy isn't just a backup. People duplicate Excel files for several distinct reasons:

• Preserving a template before filling it in with live data
• Creating a version snapshot before making major edits
• Sharing a clean copy without formulas, macros, or sensitive data
• Moving a file to a new folder, drive, or cloud location

The method you use can affect whether linked formulas break, whether macros carry over, and whether the copy stays connected to external data sources. That's worth understanding before you click anything.

Method 1: Duplicate the File Through Your Operating System

The most straightforward approach doesn't involve Excel at all.

On Windows:

1. Close or save the workbook in Excel
2. Open File Explorer and navigate to the file
3. Right-click the .xlsx (or .xlsm, .xlsb) file
4. Select Copy, then Paste in the destination folder
5. Rename the copy as needed

On macOS:

1. Open Finder and locate the file
2. Right-click and choose Duplicate, or hold Option and drag the file to a new location
3. Rename the copy

This method creates a bit-for-bit identical copy — every formula, macro, format, and sheet tab is preserved exactly. It's the safest method when you need a true backup. 💾

Method 2: Use Excel's Save As Function

Save As is the in-app equivalent of the file copy approach, with one important difference: you can change the file format at the same time.

1. Open the workbook in Excel
2. Go to File → Save As
3. Choose a new location and/or filename
4. Optionally change the format (e.g., save as .xlsx if the original is .xlsm)
5. Click Save

After saving, Excel keeps the new copy open — the original remains untouched in its original location. This is useful when you're branching a file into a new version, or saving a macro-enabled workbook as a standard workbook to share with someone who doesn't need the macros.

Keyboard shortcut: F12 on Windows opens Save As instantly.

Method 3: Copy a Specific Sheet Into a New or Existing Workbook

Sometimes you don't need the entire workbook — just one or a few sheets.

1. Right-click the sheet tab at the bottom of the screen
2. Select Move or Copy
3. In the dialog box, choose the destination workbook from the dropdown (or select new book)
4. Check the Create a copy box ✅
5. Click OK

This creates a copy of the sheet with all its data, formatting, and local formulas intact. However, formulas that reference other sheets in the original workbook will either break or pull from different sources unless those sheets are also copied. Keep that in mind if the sheet is heavily interconnected.

You can also hold Ctrl (Windows) or Option (macOS) and drag a sheet tab to a new position to quickly duplicate it within the same workbook.

Method 4: Copy a Workbook to OneDrive or SharePoint

If your Excel file lives in Microsoft 365 (OneDrive or SharePoint), the copy workflow looks slightly different.

• In the OneDrive web interface, right-click the file and choose Copy to or Move to, then select the destination folder
• In SharePoint, use the document library's file menu to copy the file to another library or site

When you copy a file this way, shared links and co-authoring history are not transferred — the copy starts fresh. If you've set up version history on the original, the copy won't carry that history either.

For Excel Online users, File → Save As → Save a Copy creates a duplicate stored in your OneDrive directly from the browser.

Method 5: Export as a Different Format

If the goal isn't an identical copy but a shareable version — for example, a PDF for distribution or a CSV for importing into another tool — Excel's Export function handles this separately from Save As.

Go to File → Export and choose the format. This creates a new file without modifying the original, but the output may not preserve everything (PDFs lose formulas; CSVs strip formatting and support only one sheet at a time).

What Changes Between Copy Methods

The Variables That Affect Your Best Approach

Even with clear methods laid out, the right choice depends on factors specific to your situation:

File complexity — A workbook with cross-sheet formulas, Power Query connections, or external data links behaves very differently when copied than a simple data table. Broken references after copying are a common pain point that only matters if your file has them.

Excel version — Excel 2016, 2019, Microsoft 365 (subscription), and Excel Online each have slightly different menus and capabilities. The Save a Copy option, for instance, is specific to newer Microsoft 365 builds.

Where the file lives — Local drive, network share, OneDrive, SharePoint, and Google Drive (if using Excel files there) each have their own copy mechanics and sync behaviors.

What you're copying for — A template you'll reuse weekly has different requirements than a one-time archive. Automation users who run VBA macros need to account for whether .xlsm format is preserved. 🗂️

The mechanics are consistent, but which combination of method, format, and destination actually serves your workflow — that's the part no general guide can answer for you.