How to Rename a Table in Excel (5 Ways)

Get FREE Advanced Excel Exercises with Solutions!

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.

How to Rename a Table in Excel


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.

Rename a Table in Excel using Tool Box

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.

Rename a Table in Excel Using Name Manager

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

Rename a Table in Excel Using Name Manager

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.

Rename Multiple Table in Excel

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.

Rename a Table in Excel using VBA Code

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

Rename a Table in Excel using VBA Code

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.

Rename a Table in Excel using Keyboard Shortcut

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


<< Go Back to Edit Table | Excel Table | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Afia Kona
Afia Kona

Afia Aziz Kona, a graduate of Civil Engineering from Khulna University of Engineering & Technology, Bangladesh, serves as a technical content creator in the ExcelDemy project. Possessing a passion for innovation and critical thinking, she actively embraces challenges. Beyond her engineering background, Afia exhibits a keen interest in Excel, having authored numerous articles on Excel & VBA-related issues to simplify the experience for users facing obstacles in Excel. Apart from creating Excel tutorials, she is also... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo