If you are looking to Rename a Table in Excel, this article is for you. Here, we demonstrate to you 5 easy and effective methods to rename your Table in Excel.
5 Ways to Rename a Table in Excel
The following Table on Student Score on Different Subjects shows Student ID, Student Name, Subject Name, and Score. We will rename this Table Using 5 easy and effective methods.
Method-1: Rename a Table Using Table Tool Box
To rename your table using the Table Tool box follow the following steps.
➤ At first, we have to click anywhere on the table
➤ After that, from Ribbon, we select the Table Design Tab.
➤ Now, in the Table Design tab, we will see that Table Name is set as Table2.
➤ We will delete the name in the Table Name box, and we will type the table name according to our choices.
➤ Here, we typed Student_Score as Table Name.
➤ Then, press Enter.
➤ Finally, if we select any cell on the table and go to the Table Design tab, we will see that the Table Name is shown as Student_Score.
Method-2: Name Manager to Rename a Table
In the following table, we can see that when we select any cell on the table, in Ribbon, the Table Design tab appears. From the Table Design tab, we can see that Table Name is set to Table24. We will rename this by using the Name Manager method.
➤ First of all, we have to click on any cell of the table.
➤ After that, from Ribbon, we will select Formulas.
➤ And then, we will select the Name Manager option.
➤ After that, a Name Manager window will pop up, and we have to select Table24, as it is the required table we want to name.
➤ Then, we will select Edit.
➤ We can see from the Name box, that the table name is Table24.
➤ We will delete this name.
➤ We will type the name of the table according to our choices.
➤ Then, click OK.
➤ Finally, we can see that the Table Name now appears as Student_Score1.
Read More: Excel Table Name: All You Need to Know
Method-3: Rename Multiple Tables in Excel
If you have several worksheets where there is a number of tables, and you want to rename those tables at once, then you can follow the following procedure.
➤ First of all, we will click on any cell.
➤ Then, from Ribbon, select Formulas.
➤ After that, we will select Name Manager.
➤ A Name Manager box will appear. And we can see multiple table names in that window.
➤ Here, we will rename Table245, therefore, we have to select Table245.
➤ After that, we have to click on the Edit Option.
➤ We have to delete the existing Name in the box and type the table Name as Table_Score.
➤ Then, click OK.
➤ Finally, we can see that the table name appears as Table_Score.
In this method, if we have multiple tables, we can rename any table. Here, we’ve renamed all our tables through the method.
- Does TABLE Function Exist in Excel?
- Convert Range to Table in Excel (5 Easy Methods)
- Pivot Table Field Name Is Not Valid: 9 Causes and Corrections
- How to Provide Table Reference in Another Sheet in Excel
- Compare Two Tables and Highlight Differences in Excel (4 Methods)
Method-4: Using VBA Code to Rename a Table
We will use VBA code to rename a table in Excel. We will use that code on our Excel Sheet5.
We can see that the Table Name appears as Table24567.
➤ To begin with, we will click any cell on the table
➤ Then, we will type ALT+F11.
➤ A VBA project window will appear.
➤ After that, we will double-click on Sheet5.
➤ A VBA editor window will appear.
➤ We will type the following code in the VBA editor window.
Sub RnmeTable() Dim odTable As String, newTable As String odTable = "Table24567" 'change to suit newTable = "Student_Score_5" 'change to suit With ActiveSheet .ListObjects(odTable).Name = newTable End With End Sub
➤ Now, we will close the VBA editor window.
➤ We have to open Sheet5.
➤ After that, we have to type ALT+F8, and a Macro window will appear.
➤ We will click on Run.
➤ Finally, we can see that the Table Name appears as Student_Score_5.
Method-5: Rename a Table Using Keyboard Shortcut
If you are fond of keyboard shortcuts then this method will help you renaming the table name using the keyboard shortcut.
➤ First, we have to click on any cell of the table.
➤ After that, we have to type ALT+J+T+A.
➤ We will see that Table Name box appears, and we can rename it from that box.
➤ We will type Table Name as Student_Score_6.
➤ After that, Press Enter.
➤ Finally, we will see the rename of the table.
Here, we showed you some simple, easy, and effective methods that will help you to Rename a Table in Excel. We hope you will find this article helpful. If you have any queries or suggestions, please feel free to know us in the comment section.
- Pivot Table Not Refreshing (5 Issues & Solutions)
- How to Calculate Percent Frequency Distribution in Excel (2 Methods)
- VBA to Refresh Pivot Table in Excel (5 Examples)
- How to Use Calculated Field in Excel Pivot Table (8 Ways)
- Insert A Pivot Table in Excel (A Step-by-Step Guideline)
- How to Make an Amortization Table in Excel (4 Methods)