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

Select the range of cells in which you want to enter the same data. Type the data. The entry appears in the first selected cell. Press "Ctrl-Enter" on the keyboard. Excel fills the other cells in ...