The simplest way to copy an Excel workbook

The fastest way to copy an Excel workbook is to use Save As, which creates a duplicate with a new name in one step. Open the workbook you want to copy, go to File > Save As, choose where you want to save it, type a new name, and click Save. The original stays untouched, and you now have two separate files.

This method works the same way on Windows and Mac, and it preserves everything in the workbook — all sheets, formulas, formatting, and data. You do not need to select anything or worry about losing information. The new file is when ready ready to edit.

If you want to copy the workbook to a different folder or a different computer, Save As still works. You just navigate to the destination folder before you save. If you want to email the copy to someone else, save it first, then attach the new file from your computer.

Key Takeaways

  • Save As (File > Save As) creates a complete duplicate of your workbook with a new filename in one step.
  • The original workbook remains unchanged when you use Save As, so you can keep both versions.
  • You can save the copy to a different folder, drive, or cloud location by navigating to it before you click Save.
  • All sheets, formulas, formatting, and data copy over exactly as they were in the original file.

Where to save your copy

When you click Save As, a dialog box opens asking you where to save the file. The default location is usually your Documents folder or your Desktop, but you can navigate anywhere on your computer. If you want to save to a cloud service like OneDrive, Google Drive, or Dropbox, navigate to that folder instead of your local Documents folder.

If you are not sure where a folder is, look at the path shown at the top of the Save As dialog. On Windows, it shows something like "Documents > Work Files". On Mac, it shows the folder name in the location bar. You can click on any folder in that path to go back, or use the folder browser on the left side to find where you want to save.

Saving to a cloud folder means the copy will sync to your other devices and you can share it more easily. Saving to your local computer means the file stays only on that machine unless you move it later. Either choice works — pick whichever matches how you plan to use the copy.

Naming your copied workbook

When you save a copy, you need to give it a new name so it does not overwrite the original. The File name field in the Save As dialog shows the current name. Clear it and type a new one. You can use the same name with a different ending (like "Budget 2024" instead of "Budget 2023"), or add a date, version number, or description.

Excel automatically adds the file extension (.xlsx or .xls) when you save, so you do not need to type it. If you type "Budget Copy.xlsx", Excel will save it as "Budget Copy.xlsx". If you type just "Budget Copy", Excel adds the extension for you. Either way works.

A clear name helps you find the copy later. Names like "Budget - Draft v2" or "Sales Data - March 2024" are easier to recognize than "Copy of Budget" or "Budget (1)". Take a few seconds to name it something you will understand when you see it in a folder three months from now.

Copying a single sheet instead of the whole workbook

If you only need to copy one sheet from a workbook (not the entire file), right-click on the sheet tab at the bottom of the window. A menu appears with options including Move or Copy. Click that option, and a dialog opens asking where you want the sheet to go.

You can move or copy the sheet to a different location within the same workbook, or to a completely different workbook. If you want to copy it to a new workbook, select Create a copy (not just Move), and choose new book from the list. Excel creates a fresh workbook with just that one sheet inside it.

This is useful when you have a template sheet or a sheet with data you want to reuse in a different file. The sheet copies with all its formatting and formulas intact. If the original sheet had references to other sheets in the same workbook, those references may break in the new location, so check your formulas after copying.

Copying a workbook using your file manager

You can also copy a workbook the way you would copy any other file — by using Windows File Explorer or Mac Finder. Right-click on the Excel file, select Copy, then right-click in an empty area of the same folder (or a different folder) and select Paste. Windows and Mac will create a copy with a name like "Budget - Copy.xlsx".

This method works, but it has one drawback: if the workbook is currently open in Excel, the copy might not include the latest changes you made. Always save and close the workbook in Excel before you copy it this way. If you use Save As instead, you do not have to worry about this — the file saves automatically before the copy is created.

The file manager method is faster if you need to copy many workbooks at once, or if you want to copy a workbook to an external drive or USB stick. For a single workbook you are actively working on, Save As is the safer choice.

What happens to links and external data when you copy

If your workbook contains links to other files (like a formula that pulls data from a different Excel file), the copy keeps those links pointing to the original files. This is usually what you want — the copy stays connected to the same data sources. If you move the copy to a different computer or folder, those links may break if the original files are not in the same location.

If your workbook pulls data from a website or an online database, the copy will still pull from the same source. The connection does not change when you copy the file. If you want the copy to be completely independent, you may need to convert the linked data to static values — a more advanced step that you can learn about once you understand the basics.

For most workbooks, copying is straightforward and nothing breaks. Just be aware that if your workbook is more complex and relies on other files or external sources, test the copy to make sure everything still works the way you expect.

Frequently Asked Questions

Can I copy a workbook while it is open in Excel?

Yes. Use File > Save As to create a copy while the original is open. The original stays open, and you can switch to the copy by opening it from your file manager or by using File > Open Recent. You cannot have both the original and the copy open at the same time in the same Excel window, but you can open them in separate windows.

What is the difference between Save As and Save?

Save updates the file you are currently working on with any changes you made. Save As creates a new file with a different name or location, leaving the original untouched. If you want to keep both versions, always use Save As. If you just want to save your changes to the current file, use Save.

Will the copy have the same formulas as the original?

Yes. All formulas, formatting, and data copy exactly as they are. The only exception is if a formula refers to the filename or location of the original workbook — in that case, the formula updates to reference the new filename or location. For most workbooks, you will not notice any difference.

Can I copy a workbook to OneDrive or Google Drive?

Yes. When you click Save As, navigate to your OneDrive or Google Drive folder instead of your local Documents folder, then save. The copy will be stored in the cloud and sync to your other devices. Make sure you are signed in to your cloud account on your computer first.

What file format should I use when I copy?

Save the copy in the same format as the original — usually .xlsx for modern Excel files. If you need to share the copy with someone using an older version of Excel, you can choose .xls from the Save as type dropdown in the Save As dialog, but .xlsx works on almost all versions of Excel from the last 15 years.