Using Excel – Sorting

If you are working on an Excel sheet and you have a column with many categories (i.e. every row has a different category or type or value). You can add a “sorting” or filtering to the column.  Ensure the row directly on top of the first category entry is the Title of the column. Next place the cursor on the title of the column you wish to have this filtering feature. Go to Data on the menu bar and click “Filter”. That’s it. If you wish to remove this feature, just place the cursor on the title of the column and press the “Filter” one more time. By the way, I am using Excel 2007 to explain this. The following exercise is good for the teachers. You are entering the marks of every student and their performance in every subject. You can, by sorting, find out which student is all-rounder the strong/weak or some students are good in a few subjects and particularily weak in certain subjects.

For those using XP operating system and Excel 2003, the only step different  is from “Go to Data” – click “Filter” then one more step – click “Autofilter”.  Happy computing!

Advertisement