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