microsoft-excel-courses - Excel

Hi Christine,

Thank you for your question.

You can filter a table by clicking within the table and using the AutoFilter menu. This can be found under Data > Filter > AutoFilter. This is where you get the drop down options to pick from a selection. There are other filters as well, but this is the easiest and quickest one to use. Have a go see if it works and if you get stuck just get back to me!

Tracy