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.

Say I have an Excel worksheet with 100 rows. Each row in column 1 has the name of a manager and each product has 10 employees. I want to use Excel to group those so I can just see 10 rows, and ...