To copy an entire Excel spreadsheet into a separate file, open the workbook in Excel for Microsoft 365 on Windows and choose File > Save As, then save it under a different name or in a different location. This creates a new workbook file containing the original workbook’s sheets; the original file remains unchanged. If you only need one worksheet, use Move or Copy instead.
First decide what you mean by the entire spreadsheet
People use “spreadsheet” to mean either a single worksheet (one tab) or a whole workbook (the Excel file, which can contain many tabs). The distinction matters: saving a copy of a workbook preserves all its worksheets together, while copying one worksheet creates a workbook with that sheet and may not bring along every workbook-level feature or dependency.
For example, a sales workbook might have tabs for January through December, a summary dashboard, and a lookup table. If you want a complete duplicate of that file, use Save As. If you want only the dashboard in a separate file, use Move or Copy on that worksheet, then check the result for formulas that depend on the other tabs.
- Copy the workbook: best for making a complete independent starting point, archive, or backup.
- Copy a worksheet: best when you need one tab in a different workbook.
- Copy cell contents: best when you need data but not the original workbook structure and features.
Make a complete copy with Save As
Save As is the simplest way to duplicate a workbook without rebuilding it. It saves the open workbook as a second file, including its worksheets and most workbook content, while leaving the source file in place. Follow these steps in Excel for Microsoft 365 on Windows:
- Open the workbook you want to duplicate. If it is important, confirm that you have the right file and that recent changes have been saved.
- Select File > Save As. Choose Browse if you want to select a folder on your computer or a network location.
- Choose the destination folder and enter a different file name. Check the file type shown in the Save as type list.
- Select Save. Excel switches to the newly saved copy, so check the title bar or use File > Info to confirm which file is now open.
- Make a small, harmless change only if you intend to edit the copy, then save it. Reopen the original separately if you need to work on that version.
On Windows, F12 opens the Save As dialog in desktop Excel. You can also use File > Save As, which makes the destination and file type easier to review. On Mac, use File > Save As; Command+Shift+S is the usual Save As shortcut in Excel for Mac. Shortcuts can vary with keyboard settings and Excel version, so the menu is the reliable route.
Give the new file a clear name, such as Quarterly Sales – Working Copy.xlsx, and save it in a different folder if you want to reduce the chance of overwriting or confusing it with the original. A different name alone is usually enough to make a separate file, but a distinct location can make the two versions easier to manage.
Copy one worksheet into a new workbook
If by “spreadsheet” you mean a single tab, Excel can copy that sheet directly into a new workbook. In the desktop app, right-click the worksheet tab at the bottom of the window and select Move or Copy. In the dialog, choose (new book) in the To book list, select Create a copy, and select OK. Excel opens a new workbook containing a copy of the selected sheet. Save that new workbook with File > Save As.
If you leave Create a copy unchecked, Excel moves the sheet out of the source workbook instead of duplicating it. That is an easy mistake to miss. Confirm that the box is checked before selecting OK, especially when the source workbook is your only copy.
To copy several tabs, repeat the process for each sheet, or select adjacent tabs first by clicking the first tab and Shift-clicking the last, then open Move or Copy. To select non-adjacent tabs, use Ctrl-click on Windows. Grouped sheets are indicated by selected tabs. Ungroup them when finished by right-clicking a selected tab and choosing Ungroup Sheets; otherwise, a change you make may affect every grouped sheet.
What Save As carries into the new file
A normal Save As copy retains the workbook’s sheets, cell values, formulas, formatting, column widths, charts, and many other features stored in the workbook. It is therefore more complete than selecting cells and pasting them into a blank file. It also preserves the workbook’s existing organization, which is useful when the copy is meant to be a working version of the same project.
Some workbook contents need extra attention because they depend on something outside the file or on the way it is stored. Examples include:
- External links: formulas may refer to another workbook. The copied file can continue to depend on that source file, rather than becoming fully self-contained.
- Queries and connections: imported data may refresh from a database, website, or another file. Copying the workbook does not necessarily change the source or access permissions.
- Macros: a workbook with VBA code should generally be saved in a macro-enabled format such as .xlsm. Saving as .xlsx removes VBA macros, and Excel warns about features that the selected format cannot preserve.
- Passwords and permissions: workbook protection, file encryption, or cloud sharing access should be checked separately. A duplicate file does not automatically give other people permission to open the original cloud location or its data sources.
- Custom settings: printer settings, add-ins, and some environment-specific features may depend on Excel or the computer, not solely on the workbook file.
When a warning appears during saving, read it before proceeding. If Excel says that a feature is incompatible with the selected format, choose a format that supports the feature if you need to keep it. For example, do not save a macro-enabled workbook as .xlsx if its VBA code is required.
Choose the right method for your goal
Use Save As when you want a full duplicate that can be edited independently. This is the closest match to copying an entire Excel spreadsheet into a new one. Use Move or Copy when you want just one or several sheets from a larger workbook. Copying and pasting cells is appropriate when you want selected data, but it is not a dependable substitute for duplicating a complete workbook.
There is also a difference between a duplicate and a template. If you repeatedly create new workbooks with the same layout, a template may be more convenient than keeping a master file and using Save As each time. Excel templates use the .xltx format, or .xltm if macros are included. Opening a template creates a new workbook based on it, leaving the template itself available for future use. A template is useful for repeated starting points, but not necessary for a one-off copy.
For a cloud-stored workbook, such as one in OneDrive or SharePoint, use Save As and select a new name or destination rather than simply continuing to edit the original. Depending on the account and location, Excel may show a Save a Copy option or ask where to save. Confirm that the copy is stored where you expect and that it has a distinct name. In Excel for the web, use File > Save As and choose the available copy or download option; labels can differ depending on whether the file is stored in OneDrive or SharePoint. Downloading a copy creates a local file, not another cloud file in the same shared folder.
Common problems and how to avoid them
The original seems to have changed. After Save As, Excel generally leaves the newly named file open. The edits you make from that point are saved to the copy. Check the file name shown in Excel before editing, and use File > Open to return to the original when needed. Avoid relying on the workbook’s visible worksheet name as proof of which file is open; the worksheet tab name and file name are different things.
The copied sheet has errors or incomplete results. The sheet may contain formulas that refer to other tabs or workbooks. When you copy only that sheet, references to missing sheets can remain unresolved or become links to the source workbook. Open the formulas and inspect any warnings or prompts about links. If the new workbook needs to be self-contained, copy the required supporting sheets too, and verify important calculations against the original.
Formatting or features appear to disappear. Check the file extension and any format warning. Saving a workbook with macros as .xlsx, for instance, does not preserve VBA. Also distinguish between copying a sheet and copying the workbook: sheet-level copying does not reproduce the complete file structure.
The new file overwrote another file. Excel may ask whether to replace a file when a workbook with the same name already exists in the destination. Cancel if you are unsure, then choose another name or folder. Do not accept an overwrite prompt unless you are certain that replacing the existing file is intended.
Others cannot access the copy. A file saved to your computer is not automatically available to collaborators. Put the new copy in the appropriate shared OneDrive or SharePoint folder and check its sharing permissions. Conversely, if you want a private copy, avoid saving it to a shared location without reviewing who can access that folder.
Check the new workbook before relying on it
A quick verification can catch mistakes before you delete, share, or make substantial changes to anything. Compare the copy with the source while both are available, and check the parts that matter for your task rather than assuming every dependency was handled automatically.
- Confirm the copy has the expected file name, extension, and number of worksheet tabs.
- Open key sheets and check representative formulas, charts, tables, and formatted areas.
- Look for alerts about external links, missing data, or disabled macros.
- If the workbook refreshes data, confirm whether the new file should use the same connections and whether you have permission to refresh them.
- Save the copy, close it, and reopen it if you want to confirm that the changes and file format persist.
For high-value or sensitive work, keep the original unchanged until the copy has been checked. Save As is not a substitute for a managed backup system: a second file in the same folder can still be lost if that storage location fails or is deleted.
Frequently Asked Questions
Does Save As copy every sheet in an Excel workbook?
Yes. Saving the open workbook with a new name creates a copy of the workbook file, including its worksheets. Check the selected file format because some features, such as VBA macros, may not be supported by every format.
How do I copy an Excel workbook without changing the original?
Open it, choose File > Save As, and save it with a different name or in a different folder. Afterward, confirm that Excel has opened the new copy before editing.
How do I copy just one Excel tab to a new file?
Right-click its sheet tab, choose Move or Copy, set To book to (new book), check Create a copy, and select OK. Save the new workbook with a suitable name.
Will copying a worksheet copy its formulas?
It copies the sheet’s formulas, but formulas that depend on other sheets or workbooks may still refer to those sources. Copy required supporting sheets and verify important formulas in the new workbook.
Can I copy an Excel file while it is open?
Save As is the simplest method from an open workbook. You can also copy a closed file using your computer’s file manager, but close the workbook first if you want to avoid copying an outdated or unsaved version.
Related
- Delete Multiple Tabs in Excel at Once: How It Works
- Can You Change Keyboard Shortcuts in Excel?
- Can You Compare Excel Files? Methods and Limits
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Double Space Bullet Points in Microsoft WordTo double-space bullet points in Microsoft Word, select the bullet paragraphs, then choose Home > Line and Paragraph…
- How to Schedule an Email in OutlookTo schedule an email in Outlook, write your message, open the menu beside Send, and choose Schedule send…
- How to Make a Flowchart in Word: Step-by-Step GuideTo make a flowchart in Microsoft Word, choose Insert > Shapes, add shapes from the Flowchart section, label…
- Excel Print Area: How to Fit It on One PageTo make an Excel print area fit on one page in Microsoft 365 for Windows, select the cells,…
- Excel Day of Year: Find the Day Number for Any DateTo find the day of the year in Excel, put a real Excel date in A2 and enter…
- How to Create and Print Number Labels in Microsoft WordTo create sequential number labels in Microsoft Word, put one number per row in an Excel list, then…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.