Data Types are a special kind of data in Excel with properties that can be accessed like fields.

Example Data Types include Stocks, Geography, and Currency.

Linked data types retrieve data from an external source and can be refreshed to show the latest available information.

Excel Data Type options

These should be values Excel can recognize as potential Data Types.

Next, select or bang out the fields you want to display.

In the example above, we selected the “Geography” Data punch in.

Excel Data Type options

Another option is to use the “Cities” Data punch in.

The fields available for each of these Data Types are different.

Excel Data Type options

Excel Data Type options

Excel Data Type options

Select cells and choose Data Type

Select field name for data type

Excel Data Type options