Saturday, 25 April 2020

How to rename the Table Name



How to rename the Table Name

Excel assigns a name to every table (Table1, Table2,…) that is created. To rename or modify the table name there are two methods
Method 1:
1.     Open Microsoft Excel.
2.     Open excel sheet which contain a table.
3.     Click any cell in the table. “Table Tools” appears in the menu bar.



4.     Click “Design” and Table Tools appear in the ribbon for Table design and table modification.


5.       You can see Your Table Name (Table 1) in the Table Name box under Properties group.
6.      Edit Table Name. (Example Table1 to MARK_SHEET)

Method 2:
1.     Open Microsoft Excel.
2.     Open excel sheet which contain a table.
3.     Click “Formulas” then Click “Name Manager”
4.     “Name Manager” dialog box appears.
5.     Select The Table Name (example Table1) you want to rename.


6.      Click on “Edit” or Press alt+e
7.      Edit Name dialog box pop-up.
8.      Edit the table name and click “Ok”

9.      You can see table name is changed. (example Table1 changed MARK_SHEET)
10.      Click  “Close”.


No comments: