The fastest way to duplicate an Excel file
The simplest method is to right-click the file in Windows File Explorer or Mac Finder, select "Copy", then right-click in the same folder and select "Paste". Windows will automatically name the copy "filename - Copy.xlsx". On a Mac, the pasted file appears as "filename copy.xlsx". This takes ten seconds and requires no software beyond what you already have.
If you are working inside Excel itself rather than in your file manager, you can also duplicate through the File menu. Open the file you want to copy, go to File > Save As, choose your location, change the filename, and click Save. This creates a second file with the new name while keeping the original untouched. The difference is that Save As leaves you inside the new copy, whereas copying through File Explorer leaves you where you started.
Key Takeaways
- Right-click and paste in File Explorer or Finder is the fastest method and requires no steps inside Excel itself.
- Save As from within Excel works equally well but leaves you working in the new copy rather than the original.
- Windows automatically names copies "filename - Copy.xlsx" while Mac uses "filename copy.xlsx", so you can spot them when ready.
- Both methods preserve all formulas, formatting, and data exactly as they were in the original file.
- Duplicating before you make changes protects you if you need to go back to the original version later.
Duplicating through File Explorer (Windows)
Open File Explorer and navigate to the folder containing your Excel file. Locate the file you want to copy — it will have a .xlsx or .xls extension. Right-click directly on the filename and a menu will appear with several options.
Click "Copy" from that menu. The file is now held in your clipboard. Right-click in an empty area of the same folder (or a different folder if you prefer the copy elsewhere) and select "Paste". A new file with the same name plus " - Copy" will appear in that location. If you paste multiple times, Windows will number them: "filename - Copy (2).xlsx", "filename - Copy (3).xlsx", and so on.
You can rename the copy when ready by right-clicking it and selecting "Rename", then typing a new name. This is useful if you want the copy to have a descriptive name like "filename - Backup" or "filename - Draft" rather than the automatic " - Copy" label.
Duplicating through Finder (Mac)
Open Finder and navigate to the folder holding your Excel file. Click once on the file to select it — you will see it highlighted in blue. Go to the File menu at the top of your screen and select "Duplicate". A new file will appear in the same folder with the name "filename copy.xlsx".
Unlike Windows, Mac does not add a number if you duplicate multiple times — each new copy will still be named "filename copy.xlsx". To avoid confusion, rename each copy right away. Click once on the new file, press Enter (or Return), and type a new name. Press Enter again to confirm.
If you prefer not to use the File menu, you can also select the file and press Command+D, which is the keyboard shortcut for Duplicate on Mac. This is faster if you are duplicating several files in a row.
Using Save As to create a copy while working
If you already have the Excel file open on your screen, you can create a copy without closing it. Click the File menu in the top left corner of Excel, then select "Save As". A dialog box will open showing your current location and filename.
Change the filename to whatever you want the copy to be called. You can also change the folder if you want the copy stored elsewhere. Click the "Save" button. Excel will now close the original file and open the new copy you just created. The original file remains unchanged in its original location.
This method is useful when you are about to make significant changes and want to preserve a version before you started. Save As before you begin editing, and you will have both the original and a working copy.
What happens to formulas and formatting when you duplicate
When you copy an Excel file using any of these methods, everything inside it copies exactly as it was — all formulas, cell formatting, colors, fonts, and data. If the original file contains a formula that references another file, that reference stays the same in the copy. The copy is a complete, independent version of the original.
The only thing that changes is the filename itself. If your original file was named "Budget 2024.xlsx" and you duplicate it, the copy becomes "Budget 2024 - Copy.xlsx" (on Windows) or "Budget 2024 copy.xlsx" (on Mac). The contents are identical.
Where to store your duplicate so you can find it later
When you copy a file through File Explorer or Finder, the copy appears in the same folder as the original by default. This is usually the right choice because you know where to find it — it is right next to the file you copied from. If you have organized your files into folders by project, date, or category, keeping the copy in that same folder maintains your organization.
If you want the copy in a different location, you can paste it there instead. Right-click in the destination folder and select Paste. The file will appear there while the original stays where it was. You can also use Save As to specify a different folder before you save the copy.
Give your copy a name that tells you why it exists. "Budget - Backup" is more useful than "Budget - Copy" because six months later you will remember what that file was for. If you are creating multiple versions as you work through changes, consider naming them with dates: "Proposal - 2024-01-15" and "Proposal - 2024-01-22".
Frequently Asked Questions
Can I duplicate a file that is currently open in Excel?
Yes. You can use Save As while the file is open, which creates a copy and switches you to working in that copy. You can also close the file first, then duplicate it through File Explorer or Finder. Both approaches work equally well.
What if I duplicate a file and then delete the original by mistake?
The copy remains untouched. Deleting the original does not affect any copies you made. This is actually one reason to duplicate files before making major changes — if something goes wrong, your copy is still there.
Does duplicating a file take up twice as much storage space?
Yes. A duplicate is a complete second copy, so it uses the same amount of storage as the original. If your original file is 5 MB, the copy will also be 5 MB. If storage space is limited, you may want to delete old copies once you no longer need them.
Can I duplicate a file that someone else is currently editing?
Yes. Duplicating creates a snapshot of the file as it exists at that moment. If the other person is still making changes to the original, those changes will not appear in your copy. Your copy will be frozen at the point when you duplicated it.
What is the difference between duplicating and moving a file?
Duplicating creates a second copy while leaving the original in place. Moving transfers the file to a new location and removes it from the old one. If you want to keep the original where it is, duplicate. If you want to relocate it, move instead.