The fastest way to copy an Excel file depends on where it lives

If your file is on your computer, right-click it in File Explorer (Windows) or Finder (Mac), select Copy, then right-click in the folder where you want it and select Paste. The copy appears instantly with a new name like "Copy of filename.xlsx". If the file is in OneDrive, Google Drive, or another cloud service, use the service's own copy button instead — this keeps permissions and sharing settings separate from the original.

The method you choose matters because copying through your operating system and copying through a cloud service create different results. A file copied on your computer stays only on your computer unless you move it. A file copied in OneDrive or Google Drive creates a new file in the cloud that syncs to all your devices. Both work, but they affect where the copy lives and who can see it.

Key Takeaways

  • On Windows, right-click the file in File Explorer, choose Copy, navigate to where you want it, and right-click Paste.
  • On Mac, right-click the file in Finder, choose Copy, then right-click in the destination folder and select Paste.
  • For files in OneDrive or Google Drive, use the cloud service's copy or duplicate option to keep the copy in the cloud.
  • Copying a file does not affect the original, and you can rename the copy immediately after pasting it.

Copying a file on Windows

Open File Explorer and navigate to the folder containing your Excel file. Right-click the file name and select Copy from the menu. The file is now in your clipboard.

Navigate to the folder where you want the copy to appear. This can be the same folder as the original or a different one. Right-click in the empty space of the folder and select Paste. Windows creates a copy with the name "Copy of [original filename].xlsx" in that location. You can immediately right-click the new file and select Rename to give it a different name.

Copying a file on Mac

Open Finder and navigate to the folder containing your Excel file. Right-click (or Control-click) the file and select Copy from the menu. The file is now in your clipboard.

Navigate to the folder where you want the copy. Right-click in the empty space and select Paste Item. Mac creates a copy with the name "[original filename] copy.xlsx". To rename it, right-click the new file, select Rename, and type the new name.

Copying a file stored in OneDrive

Open OneDrive in your web browser or through the OneDrive app on your computer. Find the Excel file you want to copy. Right-click it and look for an option labeled Copy to or Make a copy — the exact wording depends on your version of OneDrive.

Select the destination folder from the list that appears. OneDrive creates a new file in that folder with a name like "Copy of [filename].xlsx". The copy is stored in OneDrive, not just on your computer, so it syncs to all your devices and you can access it from any browser. If you want to rename it, right-click the copy and select Rename.

Copying a file stored in Google Drive

Open Google Drive in your web browser. Find the Excel file you want to copy — it will have a file name ending in .xlsx. Right-click the file and select Make a copy. A dialog box appears asking where you want the copy to go and what you want to name it.

By default, Google Drive suggests the name "Copy of [filename]" and places it in the same folder as the original. You can change either of these. Click the folder icon next to the location field to choose a different folder, or edit the name field to give it a different name. Click Make a copy to finish. The new file appears in Google Drive and syncs to your devices.

Copying through Excel itself

If you have the Excel file already open, you can save a copy without closing it. Click File in the top left corner, then select Save As. A dialog box opens asking where you want to save the file and what name you want to give it.

Choose the destination folder and type a new file name. Click Save. Excel creates a copy with the new name and opens that copy — your original file closes. If you want to keep working on the original, use the copy method for your operating system instead of Save As, because Save As switches you to the new file.

What happens to formulas and data when you copy

When you copy an Excel file, everything inside it copies exactly as it is: formulas, data, formatting, charts, and sheets. The copy is independent — if you edit the original file later, the copy does not change, and vice versa. If the original file contains links to other files (such as a formula that pulls data from another workbook), those links stay in the copy and point to the same external files.

If you copy a file that is shared with other people, the copy is not automatically shared with them. You have to share the copy separately if you want others to see it. This is true whether you copy through your operating system or through a cloud service like OneDrive or Google Drive.

Frequently Asked Questions

Can I copy an Excel file while it is open?

Yes. You can copy the file through File Explorer or Finder while it is open in Excel, and the copy will include all current data and formulas. If you use Save As instead, Excel switches you to the new copy and closes the original from your view, though the original file still exists on disk.

Does copying a file take up twice as much storage space?

Yes, the copy uses as much storage as the original. If your original file is 5 MB, the copy is also 5 MB, and both count toward your storage limit. If storage is tight, you can delete the original after confirming the copy works correctly.

What if I copy a file and then delete the original?

The copy remains unchanged. Deleting the original does not affect the copy in any way. The copy is a completely separate file with its own location and name.

Can I copy an Excel file to a USB drive or external hard drive?

Yes. Plug in the USB drive or external drive, open File Explorer or Finder, navigate to the drive, and paste the file there the same way you would paste it to any other folder on your computer.

If I copy a file from OneDrive to my computer, does it stay in OneDrive?

The original stays in OneDrive. When you copy a file from OneDrive to your computer, you create a separate copy on your computer. Changes to the OneDrive version do not affect the computer copy, and vice versa. If you want both versions to stay in sync, keep the file in OneDrive instead of copying it to your computer.