Browse » Home
Friday, September 14, 2012
How to Alphabetize an Excel Spread Sheet
1. Highlight the data you want alphabetized (including the headers). If the employee payroll spreadsheet has columns for 'First Name,' 'Last Name,' 'Hours Worked' and 'Pay Drawn,' and you want to sort data in an alphabetic order by 'Last Name,' then you will have to highlight data under 'Last Name' as well as 'First Name,' 'Hours Worked' and 'Pay Drawn.' If you don't highlight data in other columns, i.e. 'First Name,' 'Hours Worked' and 'Pay Drawn,' then the information in the 'Last Name' would be alphabetized, while information in other columns would not be sorted, and you'd end up jumbling all the data.
2. Select 'Data' from main menu bar and click 'Sort.'
3. Select 'Header Row' in the small new window, if your top row is a header row and you do not want it alphabetized with the other rows. Select 'No Header Row' if otherwise.
4. Select the column header you want to sort data by in the 'Sort by' list of the same window. Here, we want to sort all information by 'Last Name.'
5. Select 'Ascending' if you want to sort this information in an ascending order.
6. Click 'OK' at the bottom of the window. The spreadsheet will be sorted alphabetically.