Rename a Table eg VLOOKUP

[alangibson12]

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

[#2 · Accepted solution]

@alangibson12 

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.

[#3]

@Hans Vogelaar 

Hans thank you.