The fastest way to copy an Excel file

The simplest method is to right-click the file in File Explorer (Windows) or Finder (Mac), select Copy, then right-click in the same folder and select Paste. Windows will automatically rename it to "filename - Copy.xlsx". On Mac, the pasted file gets "copy" added to the name. This takes 10 seconds and works whether the file is open or closed.

If you want to rename it when ready instead of editing the name afterward, you can right-click the original file, choose Copy, then right-click the empty space and select Paste Special (Windows) or just Paste (Mac), and rename before releasing the mouse. But the standard copy-paste method is faster for most people.

You can also duplicate a file while it is open in Excel itself. Go to File > Save As, choose where to save it, type a new name in the filename box, and click Save. This creates a copy and leaves you working in the new file, which is useful if you plan to edit it right away.

Key Takeaways

  • Right-click the file in File Explorer or Finder, select Copy, then Paste in the same folder to create a duplicate in seconds.
  • Windows adds "- Copy" to the filename automatically; Mac adds "copy", so you may want to rename it afterward.
  • Use File > Save As inside Excel if you want to duplicate the file and start editing the copy when ready.
  • Duplicating a file preserves all formulas, formatting, and data exactly as they were in the original.

Duplicating a file in different locations

If you want the copy in a different folder, copy the file as described above, then navigate to the destination folder and paste it there. You can also use Save As to save the copy directly to a specific location: open the file, go to File > Save As, click the folder dropdown or Browse button, select your destination, type the new filename, and click Save.

On Windows, you can also drag the file while holding Ctrl to copy it to another location on the same drive. On Mac, hold Option while dragging. This is faster than copy-paste if you can see both the source and destination folders at once.

Renaming the duplicate so you can tell them apart

The automatic names "filename - Copy" and "filename copy" work fine if you only need one backup, but if you are creating multiple versions, a clearer name saves time later. Right-click the duplicate file, select Rename, and type a new name that describes what it contains or when you made it — for example, "Budget 2024 - Draft 2" or "Inventory Jan 15".

If you duplicated the file using Save As, you named it during the save process, so it already has a custom name. This is one reason Save As is useful when you know exactly what you want to call the new file.

Making sure the duplicate is truly separate

When you duplicate an Excel file, the copy is completely independent. Changes you make to one file do not affect the other. You can open both at the same time and edit them separately without any connection between them.

If you want to link the files so that one pulls data from the other, that is a different task — you would use formulas that reference the other file. But a straightforward duplicate is just two separate files with identical starting content.

Duplicating files on cloud storage like OneDrive or Google Drive

If your Excel file is stored on OneDrive, right-click it in the web browser and select Copy to, then choose the destination folder. The file will be duplicated in that location. You can also right-click and select read to save a copy to your computer, then upload it back with a new name if you prefer to work locally.

For files in Google Drive, right-click the file and select Make a copy. Google Drive will create a duplicate with "Copy of" added to the name and place it in the same folder. You can then rename it and move it to a different folder if needed.

Duplicating multiple Excel files at once

If you need to copy several files, select them all by clicking the first one, then holding Ctrl (Windows) or Command (Mac) and clicking the others. Right-click any selected file and choose Copy. Navigate to the destination folder and paste. All files will be copied with "- Copy" or "copy" added to their names.

This is much faster than duplicating them one at a time, especially if you are organizing multiple versions of related spreadsheets.

Frequently Asked Questions

Does duplicating an Excel file copy the formulas and formatting?

Yes. A duplicate is an exact copy of the original file at the moment you created it. All formulas, formatting, colors, fonts, and data are identical. If you later change the original, the duplicate does not update — they are separate files.

Can I duplicate a file that is currently open in Excel?

Yes, you can use File > Save As to create a copy while the file is open. You can also close it and duplicate it using File Explorer or Finder. Both methods work fine.

What if I duplicate a file and then realize I made a mistake in the original?

The duplicate is separate, so mistakes in the original do not affect it. If you need the original to match the duplicate, you can copy the corrected data from the duplicate back to the original, or straightforward delete the original and rename the duplicate to take its place.

Is there a limit to how many times I can duplicate a file?

No. You can create as many duplicates as you need. Each one takes up storage space equal to the original file size, so keep that in mind if you are working with very large spreadsheets or limited storage.