Forum Discussion

Brass Contributor

Nov 10, 2021

Excel Official Tables

Hi All,

Is it possible to get list of all the table names in an excel column without a macro?

I am using macros currently, But need morer better thing if exists.

Thanks

developer

excel

Formulas and Functions

training

4 Replies

Riny_van_Eekelen
Platinum Contributor
Nov 10, 2021
yugal40 You could consider PowerQuery. A very simple example in the attached file. Add a table anywhere in the workbook (or delete one). Press Refresh all on the Data ribbon,and the list of table names (the green one) is updated instantly.
table_names.xlsx20 KB
- yugal40
  Brass Contributor
  Nov 12, 2021
  putting a code of power query takes a lot of space in a workbook?
  - Riny_van_Eekelen
    Platinum Contributor
    Nov 13, 2021
    yugal40 Not really!