Show-Me  Academy Menu  |  FAQ  |  About  |  Contact  |  See all the latest video tutorials from Show-Me Academy with our RSS feed

Show me how to sort data in Microsoft Excel 2007

Excel -> Microsoft Excel 2007

Problem: I need to sort a table, alphabetically or numerically, based on any given column.



  1. Open Microsoft Excel 2007
  2. Right-click on a cell
  3. On the context menu, mouse over the "Sort" item
  4. On the pop-up menu to the right, click the "Sort Smallest to Largest" item
  5. Right-click on a cell
  6. On the context menu, mouse over the "Sort" item
  7. On the pop-up menu to the right, click the "Put Selected Cell Color on Top" item
  8. Right-click on a cell
  9. On the context menu, mouse over the "Sort" item
  10. On the pop-up menu to the right, click the "Put Selected Font Color on Top" item
  11. Right-click on a cell
  12. On the context menu, mouse over the "Sort" item
  13. On the pop-up menu to the right, click the "Custom Sort..." item
  14. On the "Sort" window, click the "Add Level" button
  15. Click the "Delete Level" button
  16. Click the "Options..." button
  17. On the "Sort Options" window, click the "Case sensitive" checkbox
  18. On the "Sort Options" window under the "Orientation" section, click the "Sort left to right" radio button
  19. Click the "OK" button
  20. On the "Sort" window, click the "My data has headers" checkbox
  21. Click the "OK" button

Menu  |  FAQ  |  About  |  Contact  |  Terms  |  Privacy  |  RSS
© Copyright 2008 by Show-Me Academy, Inc. - All rights reserved