98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » training microsoft excel - Excel formatting/Formular
training microsoft excel - Excel formatting/Formular
Resolved · Low Priority · Version Standard
Mailin has attended:
Excel Intermediate course
Excel formatting/Formular
What can I do if my drop-down arrows don't include all information I want to see on my atuo-filter?
RE: Excel formatting/Formular
Hi Mailin
Thank you for your question.
The dropdown arrows for the autofilter will show each unique item in the column below.
If not all of the items in the column show in the dropdown list, it might be because there is a blank row or rows that occurs somewhere in the list area.
Otherwise if you are meaning that you want to be able to filter for more than one item in the column, you can use the Custom option in the dropdown list to do this.
Amanda
RE: Excel formatting/Formular
Brilliant, thanks very much for your quick reply! So all I need to do is avoiding blank rows on the spread sheet.
Luckily i have learnt about the Custom option yesterday on the course.
thanks again
Mailin
RE: Excel formatting/Formular
Hi Mailin
Good to hear there was a quick resolution to your problem.
Generally with a list it is best to make sure there are no blank rows, as this will affect sorting as well and also pivot tables if you use them.
Amanda
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:The Easiest Way to See a Sum or Average in Excel 2010Did you know the quickest and most simple way of working out the average or sum of a set of numbers? |