Tom’s Tutorials For Excel: Filtering Columns
Free and safe downloadable workbook to filter by columns
As you know, Excel only provides a built-in method of filtering for rows by individual columns.
If you want to filter columns by their row headers, here are two methods: one with Data Validation and the other with a UserForm interface. The code is in this free workbook example.
There are two worksheets in the downloadable workbook. One sheet is named Filter Columns Data Validation, where drop-down lists in column A contain the items for each row.
For example, May is selected in A2, which filters columns to show cells in row 2 that contain May.
The other sheet in the downloadable workbook is named Filter columns with userform. As directed by the pop-up screen tip, double-click a row header cell in column A to call the userform.
In this example, cells along row 4 are filtered that only contain “Sat”.
The filtered result for row 4, exposing only columns whose cells contain “Sat”.
In this example, the more advanced filter options are utilized. Here, row 4 is filtered for items less than the letter S.
The filtered result for row 4, exposing only columns whose cells contain items alphabetically less than the letter S.