Forum home » Delegate support and help forum » Microsoft Excel Training and help » Filter problem
|
|
|
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. |
Filter problem
Resolved · Medium Priority · Version 2007
Reply Wed 13 Apr 2011, 17:17Delegate Jess said...
Jess has attended:
Excel Intermediate course
Excel Advanced course
Filter problem
Hi there
I've got a spreadhseet with over 1000 rows. In the first column, some rows have an office name, the others don't. I would like to filter, so it shows all the rows with one office name, however, when i do this, it just filters the first few rows, and includes all the rest of the rows, even those with no data. I'm not sure what I'm doing wrong!
Thanks
For upcoming training course dates see: Pricing & availability
RE: Filter problem
Hello Jess,
Thank you for your question regarding Filter.
I have tried your problem on my excel, and it works fine. In the autofilter dropdown menu above the column you wish to filter, select from the text filter option, equals and type the name of the office required.
If this does not work please send a sample over. thanks
I hope this resolves your question. If it has, please mark this question as resolved.
If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?
Have a great day.
Regards,
Mark
Microsoft Office Specialist Trainer
Reply Thu 14 Apr 2011, 10:00Delegate Jess said...
RE: Filter problem
Hi Mark
I tried what you suggested and it didn't make any difference (it only filtered the first few rows again), however, I have just unhidden the first 3 columns, and tried filtering again, and it seems to have worked this time. Curious!
Thanks
Jess
|