How to Rename a Workbook in Excel (4 Easy Methods)

Get FREE Advanced Excel Exercises with Solutions!

While working in Excel, we often have to rename a workbook. In addition to this, properly named and organized worksheets and workbooks are important for the look of the spreadsheet. Moreover, this is an easy and time-saving task as well. This article will be very helpful for them. In this article, I will show you 4 easy methods in order to rename a workbook in Excel. Hence, let’s get started.


How to Rename a Workbook in Excel: 4 Easy Methods

In the following section, I will use four effective and tricky methods to count the number of columns in Excel. Moreover, this section provides step-by-step procedures and details for all methods, and I have used Microsoft Office 365. It includes the keyboard shortcuts, context menu, VBA code, and Excel File tab. For the purpose of demonstration, I have used the following sample dataset.

how to rename a workbook in excel


1. Apply Keyboard Shortcut to Rename a Workbook in Excel

In this section, I will apply the keyboard shortcut to rename a workbook in Excel. You can easily rename a sheet without using a mouse. However, go through the following steps in order to complete the task easily.

📌  Steps:

  • Firstly, select the workbook.
  • Secondly, press F2 or click again and rename the workbook.

Apply Keyboard Shortcut to Rename a Workbook in Excel

  • Lastly, you will get your desired name.


2. Rename a Workbook Through Excel File Tab

Fortunately, you can easily rename a workbook using the File tab in Excel. Moreover, the process is quite easy and handy to operate. However, you need to go through the following steps to rename your desired workbook.

📌  Steps:

  • Initially, click on the File tab.

Rename a Workbook Through Excel File Tab

  • Then, select Save As option.

  • After that, write your desired name and press the Save button.

  • Lastly, the name will change.


3. Use Context Menu for Renaming a Workbook

Furthermore, you can use the context menu for renaming a workbook in Excel. You need not open the workbook. Moreover, you can utilize it using the mouse. However, you need to follow the steps mentioned below.

📌  Steps:

  • First, select the file and right-click with the mouse to open the context menu.
  • Then, select Rename.

Use Context Menu for Renaming a Workbook in Excel

  • After that, rename the file according to your choice.

  • Finally, the final output will appear below.


4. Rename Excel File with VBA

Last but not least, a VBA code can also help you to rename a workbook in Excel. A VBA code is necessary for this method. Moreover, it is quite simple and handy to use. However, you can just copy the code and run it in your Excel worksheet by following the below steps.

📌  Steps:

  • Firstly, open the workbook and hold the Alt+F11 keys in Excel, which opens the Microsoft Visual Basic Applications window.
  • Secondly, click the Insert button.
  • Thirdly, click on Module from the menu to create a module.

Rename Excel File with VBA in Excel

  • Fourthly, a new window will open. Write the following VBA macro in the Module window.
Sub rename_a_workbook()
'ExcelDemy Publications
Name "D:\New Microsoft Excel Worksheet.xlsx" As "D:\Rename a Workbook.xlsx"
End Sub

VBA Code to Rename a Workbook in Excel

  • After that, press the F5 key to run the VBA code.
  • Finally, you will get your desired result.


How to Rename a Worksheet in Excel

So far, I have changed the name of one workbook at a time. However, you can change the sheet names individually by following several methods. In this section, I will discuss steps for an effective and simple method to rename one sheet at a time. Fortunately, the sheet name can be changed by double-clicking on the sheet name. For the purpose of demonstration, I have chosen the following sample dataset. Hence, the steps for doing that are given below.

📌  Steps:

  • First, double-click (left) on the sheet name from the sheet name tab at the bottom.
  • Then, type the new name (Dataset).
  • Afterward, hit Enter.

How to Rename a Worksheet in Excel Using Mouse

  • Finally, the sheet name will change as in the image below.

Read More: How to Auto Refresh Excel File Without Opening


Download Practice Workbook

You can download the workbook used for the demonstration from the download link below.


Conclusion

These are all the steps you can follow to rename a workbook in Excel. Hopefully, you can now easily create the needed adjustments. I sincerely hope you learned something and enjoyed this guide. Please let us know in the comments section below if you have any queries or recommendations.

What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Mehedi Hasan
Mehedi Hasan

Hi, I am Mehedi. I have completed my B.Sc. from Bangladesh University of Engineering and Technology. I have a strong interest in innovation and research in the field of Data Science and Machine Learning. Gradually, I now understand the value of Data Analysis and I am trying to learn everyday.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo