Autofilter

Have you ever spent time sorting items so that you could group like items together? Ever been just not satisfied spending your time that way? Try this instead:

Put your cursor on cell A2, and then choose Data-->Filter-->Autofilter

This will apply put a drop down on all columns that contain data.

Now, click on one of those drop downs:
Now, choose a specific value from the list, or select custom, and then create a custom autofilter.


You can use this custom autofilter to choose a date range (Is greater than or equal to your first date AND less than or equal to your end date). Or, you can use it to limit another column to all items that begin, contain or end with a character of your choosing.

Play with it. I think you'll really like it! And, SOON, I'll show you how to do a quick summary of filtered data.

Happy filtering!!