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.


Download Practice Workbook


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.

how to make a copy of an excel file

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

Opening Workbook As Copy

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

how to make a copy of an excel file

  • 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.

Read More: [Fixed!] Copy and Paste Not Working Between Workbooks in Excel


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.

Copying Workbook in Folder

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

how to make a copy of an excel file

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

Read More: How to Copy File Names from Folder to Excel (4 Easy Methods)


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.

Using Save As to Copy an Excel File

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

how to make a copy of an excel file

  • After browsing the file, click Save

how to make a copy of an excel file

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.

Read More: How to Save a Copy of an Excel File (3 Easy Ways)


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.

How to Copy Sheet to Another Workbook

  • 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.

how to make a copy of an excel file

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

Read More: Macro to Copy and Paste from One Worksheet to Another (15 Methods)


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.


Related Articles

Towhid

Towhid

Hello, myself Shajratul Alam Towhid. Basically, I am a Naval Architect who wants to expand knowledge in the field of Microsoft Excel. I wish all of my articles will be beneficial for the readers.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo