To duplicate an Excel file on Windows, save and close it, open its folder in File Explorer, select the workbook, press Ctrl+C, then press Ctrl+V. Windows creates a second file; rename the copy so you can tell it apart. You can also use Excel’s Save As command to create a copy in a chosen folder. Both methods preserve the original, as long as you give the duplicate a different name and location.
What You’ll Need
- A Windows PC and the Excel workbook you want to copy. These steps apply to Microsoft Excel for Microsoft 365 on Windows.
- Permission to access the folder where the workbook is stored, plus enough space to save another copy.
- A destination folder and a clear name for the duplicate. If the workbook is in OneDrive or another synced location, an internet connection may be needed for the new copy to finish syncing.
Step-by-Step
- Save your latest changes. If the workbook is open in Excel, press Ctrl+S and wait for the save to finish. If the title bar shows a syncing or saving status, wait until it settles. Close the workbook before copying it in File Explorer. This reduces the chance of copying an older saved version while Excel still has unsaved changes. If Excel asks whether to save changes as you close the file, choose Save.
- Open the workbook’s folder. In Excel, select File > Info and look for the file location, if it is shown. You can also select File > Open > Browse, navigate to the workbook, and note its folder in the Open dialog. If you already know where the file is, open File Explorer with Windows key+E and browse there. A workbook may be in Documents, Downloads, a work folder, a network drive, or a OneDrive folder.
- Select the workbook in File Explorer. Click the file once. Excel workbooks commonly end in .xlsx, .xlsm, or .xls, but Windows may hide the extension. Check the name and file type so you do not accidentally select a PDF, a shortcut, or a similarly named workbook. If you are unsure, right-click the file and choose Properties to check its type and location.
- Copy and paste the file. With the workbook selected, press Ctrl+C. Browse to the folder where you want the duplicate and press Ctrl+V. To put the copy beside the original, stay in the same folder before pasting. You can also right-click the selected file, choose Copy, open the destination folder, right-click an empty area, and choose Paste. Windows creates a separate file; it does not overwrite the original in the normal same-folder copy process.
- Give the duplicate a clear name. If the copy is in the same folder, Windows may add wording such as “- Copy” to its name. Click the copied file and press F2 to rename it, or right-click it and choose Rename. Use a name that identifies its purpose or date, such as “Quarterly Budget – Working Copy.xlsx.” Keep the file extension intact. If extensions are hidden, type only the new name, not “.xlsx” again.
- Check that the copy exists. Confirm that the original and duplicate appear as separate files, with the names and locations you intended. Compare their file sizes if useful; two copies of the same saved workbook will usually have similar sizes. Open the duplicate and check a few important sheets, cells, and formulas. Make a small, safe change only if you need to confirm that editing the copy does not change the original; close without saving if you do not want that test change.
- Alternatively, create a copy from Excel with Save As. Open the workbook and select File > Save As > Browse. In the Save As dialog, choose the destination folder, enter a different file name, and confirm that the file type is appropriate. For a standard workbook, that is usually Excel Workbook (*.xlsx); keep Excel Macro-Enabled Workbook (*.xlsm) if the file contains macros. Select Save. Excel saves the new file and switches the open workbook to that newly named copy. The original remains in its original location, so check the title bar and folder before editing if you need to continue working on the original.
- Choose the method that fits your goal. File Explorer copy and paste makes a file-level duplicate without changing which workbook is open in Excel. Save As is convenient when you are already working in the workbook and want to continue in a newly named version. In either case, keep the original until you have confirmed the copy opens and contains the expected data.
Common Mistakes
Using Save instead of Save As. Save updates the workbook you already opened; it does not create a second file. To make a named duplicate from Excel, choose File > Save As > Browse and use a different name or folder. After saving, Excel works in the new copy, which can surprise you if you thought the original would remain active.
Overwriting an existing workbook. If you paste into a folder that already contains a file with the same name, Windows may ask whether to replace it. Choose Cancel or keep both files if you are not certain. Replacing a file can destroy the earlier version. Use a unique name, or choose a new destination folder instead.
Copying unsaved changes. A File Explorer copy reflects what was last saved to disk, not unsaved edits currently open in Excel. Save and close the workbook first, or use Save As from Excel if the latest on-screen changes need to be in the duplicate.
Confusing a workbook copy with a worksheet copy. These steps duplicate the entire file, including its sheets. To duplicate only one sheet, right-click that sheet’s tab in Excel, choose Move or Copy, select the destination workbook or “(new book),” and check Create a copy. That creates a sheet copy, not an independent duplicate of the whole original workbook.
Changing or removing the extension. The ending .xlsx, .xlsm, or .xls tells Windows and Excel what kind of workbook it is. Renaming the file is fine, but do not remove or replace the extension accidentally. A macro-enabled workbook saved as .xlsx may lose its VBA macros, so preserve .xlsm when macros must remain available.
Tips
- Make the purpose obvious in the filename. Names such as “Inventory – Before Update” or “Forecast – 2026-11-03” help distinguish a backup from the working file. Avoid relying on ambiguous names such as “new,” “final,” or “final2.”
- Keep a backup in another location when it matters. A duplicate in the same folder is useful for quick comparison, but it may not help if the drive or folder becomes unavailable. For an important workbook, keep a copy on a separate drive or in an approved cloud location, following your organization’s storage rules.
- Preserve the right file format. Most workbooks without macros use .xlsx. A workbook with VBA macros generally needs .xlsm. If the workbook uses older Excel features, retain its existing format unless you have a reason to convert it, and check Excel’s compatibility prompts before saving.
- Remember that a file copy is not a data snapshot in every sense. The duplicate contains the workbook as saved, but it may still include formulas linked to other workbooks, data connections, or links to external sources. Those links may continue to refer to the same sources in the copied file. Review Data connections or formulas if you need the duplicate to be independent.
- Use a separate folder for repeated versions. Creating a folder such as “Archive” or “Monthly snapshots” keeps copies from being mixed up with the live workbook. Include a date in the filename and avoid editing the archive copy unless you intend to make another version.
Troubleshooting
Paste is unavailable or no copy appears. Make sure you selected the workbook itself, pressed Ctrl+C, then opened the destination folder before pressing Ctrl+V. If using the context menu, choose Copy rather than Create shortcut. Try another destination, such as Documents, to check whether the original folder has restrictions. For a network or cloud folder, confirm that it is connected and that you have permission to write there.
Windows says the file is in use. Return to Excel and close the workbook. Also check whether another Excel window or user has it open. If a prompt offers to create a copy with a different name, use that only if you understand which version is being copied. Do not force-close Excel before saving if you need unsaved changes.
The duplicate looks out of date. The copy may have been made before the newest edits were saved, or a cloud upload may still be pending. Open the original, check that the changes are present, press Ctrl+S, wait for saving or syncing to finish, and make the copy again with a new name. If you use Save As, verify the destination and timestamp in File Explorer.
You cannot find the copied file. Check the folder you pasted into and sort by Date modified or search for part of its filename in File Explorer. If you used Save As, check the location displayed in the dialog before saving; Excel may have opened in a recent folder different from the original’s. Search Windows for the distinctive part of the new filename.
The copy will not open or Excel reports a format problem. Check that the file extension was not removed or changed, and make sure the copy process finished before opening it. Try copying again to a local folder such as Documents. If the original also fails to open, the issue may be with the source workbook rather than the duplicate. Keep the original untouched while investigating, and restore from another known-good backup if needed.
The copied workbook still updates from another file. A duplicate preserves formulas, external links, and data connections; it does not automatically replace them with fixed values. If you need a self-contained workbook, inspect its links and connections and decide whether to update, remove, or convert them. Make another backup first, because changing links or replacing formulas with values can affect the workbook’s behavior.
Frequently Asked Questions
Does duplicating an Excel file change the original?
No. Copying and pasting in File Explorer creates a separate file. Save As also leaves the original in place, but Excel switches to the newly saved copy. Avoid choosing a command or prompt that replaces an existing file if you need to preserve it.
Can I duplicate an Excel file while it is open?
You can use Excel’s File > Save As > Browse while it is open. For File Explorer copying, save and close the workbook first so the duplicate includes the latest saved version and is less likely to be locked or inconsistent.
Will the duplicate include all the sheets and formatting?
Yes. A file-level copy includes the workbook’s sheets, formatting, formulas, and other saved workbook content. It may also retain external links, connections, and macros, depending on the source file and the format you choose.
Can I make the copy in the same folder?
Yes. Copy the workbook, then paste it into the folder that contains the original. Windows will normally give the new file a different name or ask how to handle a name conflict. Rename the copy clearly and do not replace the original by mistake.
Does this work in Excel for the web or on a Mac?
The steps above are for Excel on Windows. Excel for the web uses browser and cloud-storage options, so copy the workbook through OneDrive or SharePoint’s file controls if available. On a Mac, use Finder to copy and paste the file, or use Excel’s File > Save As; Windows shortcuts such as Ctrl+C and Ctrl+V differ, with Command+C and Command+V commonly used on Mac.
Related
- How to Delete Microsoft Excel Without Losing Files
- How to Delete Multiple Cells at Once in Excel
- How to Delete Leading Zeros in Excel Without Losing Data
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Table Data Validation: Setup and TroubleshootingTo add data validation to an Excel table, select its data cells, choose Data > Data Validation, and…
- How to Remove a Dropdown List from an Excel ColumnTo remove a dropdown list from an Excel column in Microsoft 365 for Windows, select the cells, choose…
- Excel Random Numbers Between a Range and ValueIn Excel for Microsoft 365, use =RANDBETWEEN(1,100) to generate a random whole number from 1 through 100, including…
- Microsoft Excel Text to Columns: A Practical GuideIn Microsoft Excel for Microsoft 365 on Windows, select the cells you want to split, then choose Data…
- Conditional Formatting in Excel: How It WorksConditional formatting in an Excel spreadsheet automatically changes a cell’s appearance when its value or a formula meets…
- Excel Column Sorting Drop-Down: How to Use ItIn Excel for Microsoft 365 on Windows, click the arrow in a column header and choose Sort A…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.