Saturday, July 16, 2011

How to Alphabetize an Excel Spreadsheet


1. Right-click on the Excel workbook you want to alphabetize. Click 'Open,' then click on the worksheet tab at the bottom of the workbook that contains the data that you want to organize.
2. Click the upper left corner of the spreadsheet, just above Row 1 and to the left of Column A, to select all of the cells in the sheet.
3. Click 'Sort and Filter' on the home tab (it is on the far right side of the window) and then select 'Custom Sort....'
4. Change the entry in the 'Sort by' drop-down menu to the column you want to alphabetize and click 'OK.' You can also arrange entries in reverse alphabetical order by changing the 'Order' setting to 'Z to A.'

Blogger news