Shortcut for filter in Excel

Short Cut for putting Filter on table header in Excel!!!! Simplified!!!

Alt+A+T

The same combination can be used for removing the same.......

Remember: if there is a break in between the table, then we need to select the entire table before using the combination to put filter on the entire table or else the filter will work only uptill the break.

Example: as illustrated

If we only select the header and use the combination the filter will work up till the break; in this case up till row no 7

for putting effective filter on the entire table with breaks, we need to select the entire table first, in this case select table up till row no 13 and thereafter use the combination.

Hope its simplified!!!

Happy Reading!!