Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint-registration/
In this video, I share some quick tips & shortcuts for applying filters based on a cell’s value, font or fill color or icon. These tips include both mouse and keyboard shortcuts and will save you time when applying a filter to a column.

When we are applying a filter for a single item, it can be time-consuming to find the item in the list box of the filter drop-down menu. It also requires several clicks. The techniques I share in this tutorial make it much faster and easier to apply a filter.

Related posts & Videos:
The best keyboards for Excel and the one I use that has a Menu Key: https://www.excelcampus.com/keyboard-shortcuts/best-keyboards-for-excel-keyboard-shortcuts/

Menu Key post: https://www.excelcampus.com/tips-shortcuts/excel-keyboard-shortcuts-convert-text-to-numbers-ignore-errors/

5 Keyboard Shortcuts to Paste Values in Excel: https://youtu.be/jd9PZd7Itzs

Shortcuts for the Menu Key to Convert Text to Numbers, Ignore Errors: https://youtu.be/wXHVIksBgyI

#MsExcel #ExcelCampus
00:00 Introduction
00:26 Select All
00:45 Filter by Value
01:30 Keyboard Shortcuts