How to Make a Copy of an Excel File (3 Useful Methods)

If you are looking for how to make a copy of an Excel file, then you are in the right place. We frequently need to make a copy of an Excel file while using Excel. In this article, we’ll try to discuss how to make a copy of an Excel file.

Table of Contents hide

Download Practice Workbook

3 Ways to Make a Copy of an Excel File

1. Opening Workbook As Copy

2. Copying Workbook in Folder

3. Using Save As to Copy an Excel File

How to Copy Sheet to Another Excel File

Conclusion

Download Practice Workbook

Making a Copy.xlsx

3 Ways to Make a Copy of an Excel File

Excel offers a couple of ways to make a copy. We’ll try to describe those in a straightforward way.

1. Opening Workbook As Copy

We can open a new workbook as a copy. Suppose, we have the following workbook named Making a Copy. We need to make a copy of it.

Firstly, open the Excel file by double-clicking
Secondly, go to File.

Thirdly, select Open > choose Browse. After choosing Browse we need to select the Excel file from the specified location.

So, select the file named Making a Copy > click the drop-down button > choose Open as Copy.

Eventually, a copy of the main file is created like this.

2. Copying Workbook in Folder

We can also copy the workbook directly into the folder. This is quite easy and flexible to use.

To do this, firstly, right-click the main file. In this case, it is Making a Copy.
Secondly, select Copy.

Thirdly, click outside of the file and right-click at any blank space.
Fourthly, select Paste.

Eventually, a copy of the main file is created which is Making a Copy- Copy.

Similar Readings

3. Using Save As to Copy an Excel File

We can also use Save As to copy an Excel file. This Save As command actually saves the file as a new Excel file.

Steps:

Firstly, double-click the main Excel file to open it.
Secondly, go to File.

Thirdly, select Save As.
Fourthly, click Browse to search the main file from the specified location.

After browsing the file, click Save

You may see the following warning, considering you are going to save the copied one into the same folder.

Press Yes to make the save (don’t forget to change the name manually to keep the original one intact).

Note: If you select a different directory or folder you will not see the warning.

How to Copy Sheet to Another Excel File

In Excel, we can also copy a sheet to another workbook very easily. Sometimes, we need to make a copy of a sheet to make necessary changes while keeping the main sheet unchanged. In that case, we feel the need to copy the sheet. Excel offers a couple of ways to do it. But we will discuss the user-friendly one. We just need to follow some simple steps.

Steps:

Firstly, right-click on the sheet name which is Copying Sheet.
Secondly, select Move or Copy.

Eventually, a Move or Copy window will appear.
Thirdly, select Copying Sheet.
Fourthly, make sure that Create a Copy box is selected.
Fifthly, click OK.

Consequently, we’ll see that the sheet is copied holding the name as Copying Sheet (2).

Conclusion

That’s all about today’s session. And these are the ways to make a copy of an Excel file. We strongly believe this article would be highly beneficial for you. Don’t forget to share your thoughts and queries in the comments section and explore our website Exceldemy, a one-stop Excel solution provider.