Forum home » Delegate support and help forum » Microsoft Excel Training and help » training microsoft excel - Excel formatting/Formular
|
|
|
The UK's most regular 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. |
training microsoft excel - Excel formatting/Formular
Resolved · Low Priority · Version Standard
Reply Thu 2 Aug 2007, 15:10Delegate Mailin said...
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?
For upcoming training course dates see: Pricing & availability
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
Reply Fri 3 Aug 2007, 15:21Delegate Mailin said...
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
|