98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » advanced.excel - Excel auto filter
advanced.excel - Excel auto filter
Resolved · Low Priority · Version Standard
Thu 30 Aug 2007, 10:36Delegate Sarah said...
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.
Sun 2 Sep 2007, 22:33Trainer Rajeev said...
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!!!
Mon 3 Sep 2007, 15:48Delegate Sarah said...
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.
Mon 24 Sep 2007, 13:13Trainer Rich said...
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
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Hide columns in an Excel 2010 WorksheetIf you don’t want part of the Excel worksheet to be visible or when you don’t want certain data to appear in print outs, then a simple solution is to temporarily hide a column or multiple columns. |
