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