Show-Me Academy
Menu |
FAQ |
About |
Contact |
Show me how to sort data in Microsoft Excel 2007
Excel -> Microsoft Excel 2007Problem: I need to sort a table, alphabetically or numerically, based on any given column.
- Open Microsoft Excel 2007
- Right-click on a cell
- On the context menu, mouse over the "Sort" item
- On the pop-up menu to the right, click the "Sort Smallest to Largest" item
- Right-click on a cell
- On the context menu, mouse over the "Sort" item
- On the pop-up menu to the right, click the "Put Selected Cell Color on Top" item
- Right-click on a cell
- On the context menu, mouse over the "Sort" item
- On the pop-up menu to the right, click the "Put Selected Font Color on Top" item
- Right-click on a cell
- On the context menu, mouse over the "Sort" item
- On the pop-up menu to the right, click the "Custom Sort..." item
- On the "Sort" window, click the "Add Level" button
- Click the "Delete Level" button
- Click the "Options..." button
- On the "Sort Options" window, click the "Case sensitive" checkbox
- On the "Sort Options" window under the "Orientation" section, click the "Sort left to right" radio button
- Click the "OK" button
- On the "Sort" window, click the "My data has headers" checkbox
- Click the "OK" button