Filtering a Column of Numbers

The video shows how to filter a column of numbers by applying a filter to an individual column and choosing whether to include numbers greater than or less than some sort of threshold. Excel lets you apply a filter across multiple columns at the same time so the filter could have been applied to columns A and B, allowing a user to find all organisations of a certain size with a certain name.

The disadvantage of applying a filter across a lot of columns is that you may lose track of all the filters you've applied. You can always click the Clear option next to Filter in the Sort & Filter bar if you just want to see all your data again.

If you are happy to allow filtering across multiple columns, an alternative way to apply the filter is simply to select any cell in the table, such as A6, and click Filter. Microsoft Excel can typically work out where the data is that you want to filter as long as you don't have any empty rows or columns. If your data does not start in row 1 and Excel is failing to detect where your table is then you would have to select a rectangle of all the cells you wished to filter instead of just being able to select an entire column as in the video.

An alternative to applying a traditional filter is to create an Excel table from the Insert ribbon. This would allow you to filter using slicers and style the table to increase readability. If you are looking to aggregate filtered numerical data, you can also use your raw data to build pivot tables which come with a variety of filtering options.