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.

If Stock Data Types is not showing or missing in Excel, repairing Microsoft 365, or updating or reinstalling Office. Learn more.

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.