Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » advanced.excel - Excel auto filter

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

advanced.excel - Excel auto filter

Resolved · Low Priority · Version Standard

Reply 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.

For upcoming training course dates see: Pricing & availability

Reply 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!!!

Reply 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.

Reply 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 microsofttraining.net 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

Excel articles

· Flexible uses for Excel at Home
· How To Avoid The Embarrassment Of Dirty Data
· Jazzing Up Excel With Graphics
· Microsoft Excel can ensure you keep on top of your finances
· Save time with Microsoft Excel

Excel tip:

Using the Quick Access Toolbar in Excel2010

The Quick Access Toolbar is included in virtually every Office product, including Outlook 2010, Word 2010, Excel 2010, and PowerPoint 2010.

You will find the Quick Access Toolbar in the top-left side of the window. To begin, click the Customize button (it's the little black arrow at the end of the toolbar).

Simply click the commands you want to include.

Virtually any command can be added to the Quick Access Toolbar. Click the More Commands option and a new window will open from where you can browse the commands including those not on the ribbon.

View all Excel hints and tips