Excel 2007

Hi Shereen,

Excel 2007 is excellent for filtering as they have made it alot better than the older versionsFiltering has changed and is more like pivot tables now.

Filtering is best used with lists of information and yes you can sort columns but filtering is alot better in the sence that it only shows you what you want to see. Filtering is on the home tab, in the editing section. Click on the Sort & Filter button which gives you a few options and choose filter. If you have not highlighted anything it guesses the area you want to filter and puts a small square on the heading(s) with an arrow in it. When you click on the square it shows you all the individual fields and you just need to either de-select the ones you don't want or click on select all to de-select all of them and choose what you want. To reset the filtered column choose Select all.

Hope this helps
Kind Regards
Martin