training microsoft excel - excel formattingformular

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » training microsoft excel - Excel formatting/Formular

training microsoft excel - Excel formatting/Formular

resolvedResolved · 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 courses

 

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
What does 'Resolved' mean?

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 2010

Did you know the quickest and most simple way of working out the average or sum of a set of numbers?

Highlight numbers in cells or type some numbers in cells and then look at the status bar at the bottom of the window. Here you will see a display of the average of the numbers, as well as a count of the cells and the sum of these cells.

View all Excel hints and tips


Server loaded in 0.08 secs.