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.
Rename a Table in Excel: 5 Ways
The following Table on Student Scores 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 Toolbox
To rename your table using the Table Toolbox, follow the following steps.
➤ At first, we have to click anywhere on the table
➤ After that, from the 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.
Read More: How to Mirror Table in Excel
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 the 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 the 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: How to Extend Table in Excel
Method-3: Rename Multiple Tables in Excel
If you have several worksheets where there are 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 the 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 this method.
Read More: How to Make an Excel Table Expand Automatically
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.
Read More: How to Use Sort and Filter with Excel Table
Method-5: Rename a Table Using Keyboard Shortcut
If you are fond of keyboard shortcuts, then this method will help you rename 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.
Read More: How to Insert or Delete Rows and Columns from Excel Table
Download Workbook
Conclusion
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 contact us in the comment section.
Related Articles
- How to Remove Format As Table in Excel
- Excel Table Formatting Problems
- [Fix]: Formulas Not Copying Down in Excel Table
- How to Remove Table Functionality in Excel
- How to Remove Table in Excel
- How to Undo a Table in Excel
<< Go Back to Edit Table | Excel Table | Learn Excel