How to Rename a Table in Excel (5 Ways)

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.

Download Workbook

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.

How to Rename a Table in Excel


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.

Rename a Table in Excel using Tool Box

Read More: How to Edit a Pivot Table in Excel (5 Methods)


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.

Rename a Table in Excel Using Name Manager

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

Rename a Table in Excel Using Name Manager

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.

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

Read More: How to Sort Multiple Columns of a Table with Excel VBA (2 Methods)


Similar Readings


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: Excel VBA Code for Each Row in a Table (Add, Overwrite, Delete, etc.)


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.

Rename a Table in Excel using Keyboard Shortcut

Read More: Create Table in Excel Using Shortcut (8 Methods)


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 know us in the comment section.


Related Articles

Tags:

Afia

Afia

Hello, I am Afia Aziz Kona. I graduated in Naval Architecture and Marine Engineering from Bangladesh University of Engineering and Technology (BUET). I have an immense interest in technical writing and content development, therefore, I am working as a content developer at Exceldemy. In my spare time, I travel, watch movies, and cook different dishes.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo