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.