Saturday, December 22, 2012

How to Sort Microsoft Excel Rows Alphabetically


1. Select the data you would like to sort alphabetically. Maybe it's just a small selection in a large worksheet, so simply select only the cells and any corresponding data; everything else remains the same.
2. Click on 'Data' from the main toolbar at the top of the worksheet and in the sub-menu that drops down, click on 'Sort.' The Excel program automatically selects the entire set of data and opens a new window.
3. Check to see that the data you select matches what you want to sort. If the program indicates that there isn't enough data or the data selection is too limited in some way, a 'Sort Warning' box appears. You can change the data selected before you continue.
4. Look at the choices in the 'Sort' sub-window and let the program know if your data has column headers or not. If you select 'Header Row' option, Excel will not sort that row of data. If you select 'No Header Row,' then all rows of data, including any header rows like Name, Address, City, State and Zip, will sort alphabetically in the process.
5. Decide how you want the data sorted. You can choose to only have one column sorted and all corresponding data will match up with it or have subsequent columns sorted after. For example, you can sort by last name from A to Z (ascending order) then sort the data alphabetically by first name, then again have the list alphabetically sorted by city.

Blogger news