Learn how to Apply Remove filter shortcuts

Search
Generic filters

To apply a filter on the data column you need to use keyboard shortcut Control + Shift + L. When you press this particular keyboard shortcut, Excel applies the date filters to current columns and as well all the adjoin columns where you have data.

 

apply-reapply-remove-filters-shortcutmove-filters-shortcut

Apart from this, there’s one more shortcut key that you can use to apply data filters to the column and that’s Alt ➜ D ➜ F ➜ F.

This keyboard shortcut works same as the earlier one and you can use the same shortcut key to remove the filter as well.

Control + Shift + L

Free Excel Templates

US-census

US census form

For genealogical research, I’ve found it useful to have all …

Download Now
Absconding-Letter-Excel-Template

Absconding Letter

Absconding Letter in excel template helps to issue a notice …

Download Now
Cost-Per-Hire-Calculator

Cost Per Hire Calculator

Use this Online Cost Per Hire Calculator to get desire …

Download Now
GST-Debit-Note-Format

GST Debit Note Format

GST implement from 1st July 2017. As a register business …

Download Now

We Create Your Life Easy With Our Free Excel Templates & Spreadsheet Dashboards

Use free Excel Templates, Tools and Dashboards to create and draft a professional looking dashboards and computation sheet for your personal and business use. You can Explore Calendars, Activity Planners, Invoice Templates, Sales Forecast Sheets, Budget templates and various business information delivering Templates in Excel and Spreadsheet at XLSX Templates. 

These templates, dashboards and tools are useful in various occasions. You can also customize these templates as per your requirement. Modification of fields and data source helps in making the template more relevant.

Learn Microsoft Excel : Blogs and Articles

Learn about various tips and tricks in Microsoft Excel and Spreadsheet. Create best templates and dashboards using free tricks and tutorials in excel and spreadsheet. These tutorial posts are useful for everyone who wants to master the skills in excel and spreadsheet.