Traditional Ways to Adjust Column Widths (Manually) In this example, Excel's default column width isn't wide enough to show all the text in column A.

You can alphabetize data in an Excel spreadsheet by row or column using the "Sort" feature, or through the "Data" and "Home" tabs.

When you release your mouse button, Excel automatically fills the other cells with a sequential series of numbers. Drag your mouse across the data and number cells to select them.

If you wish to count the same or duplicate values in a column only once in Excel or the count of occurances of duplicate values, read this article.