Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

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

This tutorial will demonstrate how to save a copy of an Excel file with a new name. If you have a particular Excel file that you need to use repeatedly, then you should use a macro file as well. Microsoft Excel offers you some features to save a copy of an Excel file. Today, in this tutorial, we will learn three suitable ways to save a copy of an Excel file effectively with appropriate illustrations.


Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.


3 Easy Ways to Save a Copy of an Excel File

Let us have a data set like this. We have a record of the revenue earned by the sales representatives of XYZ group. Our Excel workbook contains several sheets. We will save a copy of an Excel file, using the keyboard shortcuts, the Save As command, and VBA macros as well. Here’s an overview of the dataset for today’s task.

how to save a copy of an excel file


1. Applying Keyboard Shortcuts to Save a Copy of an Excel File

In this method, we will learn how to save a copy of an Excel file by applying keyboard shortcuts. You can save a copy of an Excel workbook by default using the keyboard shortcuts. From our dataset, we can easily do that. Let’s follow the instructions below to learn!

Steps:

  • First of all, we will create an Excel file like the below screenshot.

Applying Keyboard Shortcuts to Save a Copy of an Excel File

  • After that, press  Ctrl + S  simultaneously on your keyboard to save the Excel file.

  • Hence, a Save this file dialog box will appear in front of you. From the Save this file dialog box, select the Save option.

  • As a result, you will be able to save a copy of an Excel workbook by default name which has been given in the below screenshot.


2. Using Save a Copy Command to Save an Excel File

Now, we will use the Save a Copy option to save a copy of an Excel sheet. The Save a Copy option is a very effective tool in Excel to save a copy of an Excel workbook. Let’s follow the instructions below to learn!

Steps:

  • First of all, we will select the File tab.

Applying Keyboard Shortcuts to Save a Copy of an Excel File

  • Hence, we will choose the Save a Copy After that, select the Browse option to save your copy in the destination as you want.

Using Save a Copy Command to Save a Copy of an Excel File

  • Further, follow the steps as shown in the below screenshot.

  • Finally, you will be able to save a copy of an Excel sheet named Save a Copy which has been given in the below screenshot.

Using Save a Copy Command to Save a Copy of an Excel File

Note: Using the  Ctrl + S , you can save an Excel file by default. Applying the Save a Copy or Save As command, you can name an Excel sheet as you want.


3. Run Excel VBA Code to Save a Copy of an Excel File

Now I’ll show you how to save a copy of an Excel file by using a simple VBA code. It’s very helpful for some particular moments. From our dataset, we will save a copy of an Excel sheet. Let’s follow the instructions below to learn!

Step 1:

  • First of all, open a Module, to do that, firstly, from your Developer tab, go to,

Developer → Visual Basic

Run Excel VBA Code to Save a Copy of an Excel File

  • After clicking on the Visual Basic ribbon, a window named Microsoft Visual Basic for Applications – Save a Copy will instantly appear in front of you. From that window, we will insert a module for applying our VBA code. To do that, go to,

Insert → Module

  • Now, the VBA window will open on the screen with the current excel workbook name.

Step 2:

  • Hence, the Save a Copy module pops up. In the Save a Copy module, write down the below VBA
Sub SaveFile_1()
Dim File_Name As String
File_Name = "Revenue"
ActiveWorkbook.SaveAs Filename:=File_Name
End Sub

Run Excel VBA Code to Save a Copy of an Excel File

  • Hence, save the Excel file with the  .xlsm  After that, run the VBA code. To do that, go to,

Run → Run Sub/UserForm

  • After running the VBA Code, you will be able to save an Excel file named Revenue which has been given in the below screenshot.
  • Finally, you will get the desired result in the current location of your file.

Run Excel VBA Code to Save a Copy of an Excel File


Bottom Line

👉 You can pop up Microsoft Visual Basic for Applications window by pressing  Alt + F11  simultaneously.

👉 If a Developer tab is not visible in your ribbon, you can make it visible. To do that, go to,

File → Option → Customize Ribbon

👉 You can save an Excel file by pressing  Ctrl + S  simultaneously on your keyboard.

👉 To use the Save As command for saving an Excel file press  Ctrl + Shift + S  simultaneously.


Conclusion

I hope all of the suitable methods mentioned above to save a copy of an Excel file will now provoke you to apply them in your Excel spreadsheets with more productivity. You are most welcome to feel free to comment if you have any questions or queries.

Md. Abdur Rahim Rasel

Md. Abdur Rahim Rasel

Hi! I'm Md. Abdur Rahim Rasel. Welcome to my Profile. Currently, I am working and doing research on Microsoft Excel and here I will be posting articles related to this. I have completed my graduation in Naval Architecture and Marine Engineering(NAME) from Bangladesh University of Engineering and Technology(BUET). I have a passion for learning new things with my knowledge through perseverance and hard work.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo