Sarah has attended:
Excel Intermediate course
Excel auto filter
I have an auto filter on my spreadsheet, but when I click the arrow to choose one of the options to look at, it only gives me 2 different options (of which are listed in the column below), but there should be about 15 or so......
I've tried taking the auto filter off and on again, I've tried exiting out, I've tried everything! Is this a fault? (Its only happenening on 1 worksheet - others are ok).
Thanks.
RE: Excel auto filter
Hi Sarah!!
One of the possible problem could be that you might have more than one field for autofilter!!
If that is the case then you need to ensure that you get rid of all the autofilters. Simply check if you have any of the drop down arrow in blue colour.
Hope it works!!!
RE: Excel auto filter
Hi Rajeev,
No - we've checked and none of the filter arrows are blue.
We've made sure that each autofilter arrow is on "all". We've even removed the autofilter and put it back on again. Its still not coming up with all of the options.
Also, another strange thing, is that we have selected "wrap text", and on this worksheet, the cells are not 'wrapping'. The cells only show part of the sentence and even if we double click into the cell (which usually triggers it into wrapping the text), the cell stays the same size and does not wrap the text.
Please help!
Thanks.
RE: Excel auto filter
Hi Sarah,
Sorry for the delayed response.
It will be hard to diagnose the problem without looking at the file. You can send the excel file to forum AT stl-training.co.uk for me to have a look at. If you are not comfortable with sending private files information, you can always copy the offending sheet to a new excel file, save that and e-mail it.
Regards, Rich
