Highline Excel Class 17: Filter, Filtering 8 Examples

See these 8 Filtering Examples:
1. Keyboard shortcut: Ctrl + Shift + L
2. See that Filtering hides rows whereas, sorting does not hide rows
3. Filter by Color
4. Checkboxes to show and hide certain items
5. Amazing new Date Filters in the field is filled with Dates
6. Amazing new Text Filters in the field is filled with Texts
7. Amazing new Number Filters in the field is filled with Numbers
8. Custom Filter
This is a beginning to advanced Excel class taught at Highline Community College by Mike Gel excelisfun Girvin Busn 214 BTech 109

Category:

Science & Technology

Tags:

• Excel
• Filter
• Filtering
• by
• color
• date
• text
• number
• Custom
• excelisfun
• Mike
• Gel
• Girvin
• Highline
• Community
• College

[kingcolz]

this rocks !

[ExcelIsFun]

I am glad that it helped!

[ishaqyazdani]

thanx for the explanation.........its helpful to me

[ExcelIsFun]

I am glad that it helped!

[michielmons]

Dude, you saved my ass yesterday. I had a pretty important exam and I just couldn't figure out how to Vsearch. My book was just not clear enough, but your video was. Thanks a lot.

[ExcelIsFun]

You are welcome!

[rayroh69]

Wow, very helpful

Thank you!

[prudhvirajreddyable]

niceee

[drdavidge]

Excel 2003's autofilters were so quick to use.. all you would have to do is click the dropdown and then you could use your keyboard to select the data you wanted to filter on, or press a keyboard key to jump to items starting with "S" for example. In 2007+, you have to use the mouse, and you have to unselect "select all", scroll down manually, and then click on whatever item you want to filter on. Is there a faster way to do this in 2007+ that is like the previous versions?

[ExcelIsFun]

Dear rayroh69,

I am glad that it was helpful!

--excelisfun