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.
- 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.
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.
- 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.
Read More: How to Copy File Names from Folder to Excel (4 Easy Methods)
- How to Use Paste Special to Multiply Numbers in Excel
- [Fixed!] Paste Link Not Working in Excel
- Excel VBA: Copy Range to Another Workbook
- How to Copy a Cell in Excel Using Formula(7 Methods)
- Excel VBA to Copy Data from Another Workbook without Opening
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.
- 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.
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.
- 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).
Read More: Macro to Copy and Paste from One Worksheet to Another (15 Methods)
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.
- How to Use Paste Name Dialog Box In Excel (3 Ideal Examples)
- Enable Paste Option in Excel (3 Suitable Ways)
- How to Copy Number Not Formula in Excel (5 Quick Tricks)
- Copy and Paste from PDF to Excel (3 Examples)
- How to Copy Cell If Condition Is Met in Excel (7 Easy Ways)
- [Solved:] Copy Paste from Excel to Google Sheets Not Working
- How to Copy and Paste a Column in Excel (5 Handy Ways)