Filters on spreadsheets

Hi Katie,

Thank you for your question and welcome to the forum.

The first step is to make sure the your data has column headings and there are no blank rows between your headings and the data.

Highlight the headings and go to the Data Menu and then Filter and finally choose AutoFilter.

Filter buttons should appear to the bottom right of each heading. Click on the button and you will be able to filter a value from the column to show the results in the rest of the sheet relating to the option chosen.

I hope this helps.

Regards

Simon