This tutorial shows the steps to use Automatic Data Type in Microsoft Excel. It allows you to insert details of cities, food items, music, animals, persons, etc, automatically.

For some data types, such as a date or a percentage, Excel will change a cell's number format automatically as soon as you type it into a cell.

The Food Data Type converts cells with food to nutrition details. Learn how to use Food Data Type in Excel to get calorie & nutrition facts.