Launch Excel and open the spreadsheet that contains the list that you want to sort. Click to select a range of data, such as A1 through A20, or click the header to select the entire column of data.

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.

The automatic conversion function of Excel, Microsoft's spreadsheet software, automatically converts some inputs, such as numbers and dates, into specific types of data. Although this feature is ...