Excel 2007 filter

[josh_b]

I've been searching all over the web and can't seem to find a solution to my
problem. If you have any ideas please let me know.

I recently got a new computer to work on and it came with Excel 2007. On my
old computer I worked in Excel 2003 and I have a database I keep updated for
work. Unfortunately Excel 2007 isn't quite the same as 2003 as far as filters
go. We have all our data organized, for a hundred different jobs, by date. If
we go to a job we log/enter the day and month. This way I can sort easily and
jump between months and jobs quickly. However in 2007 when you Sort with a
filter there isn't a typical drop down box to select month, job, etc. You
have an actual checklist you have to check and un-check to get what you
want...Maybe for how everyone else uses Excel this is brilliant but for me
its sluggish and way too time consuming considering the amount of entries i
submit. To select say "March" I have to go un-check whatever month i was just
working in, so Excel doesn't bring up both months at once, then select what i
want. Maybe this doesn't seem that ridiculous for months but when i wanna
stay in March and we have 100 different jobs i have to move between its gets
old rather quickly. I can honestly see what microsoft was going for here but
for me its nearly doubled the time it takes to finish my work. Any help or
suggestions would be appreciated. I'm also willing to send examples to anyone
if my illustrations weren't very clear. I'd even be willing to switch back to
2003 if thats the only way.

 

[Bob I]

Double click "Select All" to clear your previous selection.

 

[josh_b]

Yes, that's what i currently do. Its still somewhat of a hassle compared to
how quick i was able to move through my data base in Excel 2003. thanks

 

[Bob I]

So you were exaggerating the difficulty? Perhaps consider using a
database instead of a spreadsheet?