Forum Discussion
Solved
Rename a Table eg VLOOKUP
Hi
how do you rename a table? eg
When you have a range of Data in a table, and you highlight the data and Name the CELL range.
How do you rename that table
- If you change your mind.
- If you copy the table, excel will choose a random name, and you want to rename
Click anywhere in the table.
Activate the Design tab of the ribbon, under Table Tools.
You'll see a box labeled Table Name on the left hand side. You can edit the name here; press Enter to confirm.
2 Replies
Click anywhere in the table.
Activate the Design tab of the ribbon, under Table Tools.
You'll see a box labeled Table Name on the left hand side. You can edit the name here; press Enter to confirm.
Hans thank you.
