Hi

Maybe I'm not phrasing the problem correctly, but I can't seem to find any solutions to this on google.

I use a spread sheet in which the columns have filters where you can filter out certain values by unticking the boxes. For example, the choices might be "red", "blue", and "yellow". If I click on the little filter box on the column header then I can untick "yellow", so that only columns containing "red" and "blue" values for that column are displayed on the spreadsheet. I can then apply filters to other columns, eventually filtering down the products (listed row by row, from top to bottom.

This works fine, but when my colleague opens the exact same spreadsheet on his computer and clicks on the little filter button at the top of the column, he can't filter values out by unticking the little boxes,, as the little boxes don't appear (as doesn't the "select all" option. Instead, the values are just displayed as a list of which he can choose only one to be displayed (so in the above example he could only choose "red" OR "blue" OR "yellow", and not two at the same time).

I'm sure that this is just a little setting on my colleague's excel that I need to tweak, but I can't seem to work out what to do.

Any help would be greatly appreciated.