Excel Tip: Generate a Defined Name from a Table 1 minute read Sometimes you may have a need to treat a column of data in an Excel table as a list – for example, to use the contents of that list as a drop-down somewhere ...