Shortcut to Open a Filter dropdown list and the Filter in Ribbon in Microsoft Excel 2010





In this article, we will learn the shortcut to open a filter drop-down list and the filter in Ribbon in Microsoft Excel 2010.

“Auto Filter” option allows us to filter the data based on content of cells and conditions applied on them.

We can filter the according to the particular text, month, date, number, cell color, font color, etc. Even we can sort the data as per the number, text, cell colors, and font colors, etc.

This option is available in the Data Tab under the Sort & Filter group.
 
img1
 
Shortcut Key:- Press Ctrl+Shift+L on your keyboard.

Let’s take an example to understand how we can filter the data using shortcut keys.

We have data in range A1: C18. Column A contains Date, column B contains Agent name, and column C contains Revenue amount.
 
img2
 
Filter the data through Short cut key

Follow below given steps:-

  • Select the first cell of data.
  • Press the key Ctrl+Shift+L on your keyboard.

 
img3
 

  • If you want to put the data as per date.
  • Click on the filter with the mouse.
  • Drop down list will appear.

 
img4
 

  • Select any date from the list.

 
img5
 

  • Only selected date’s related data will be appear.
  • We can follow the same procedure for Agent Name list and Revenue list.

Filter the data through Short cut key

Follow below given steps:-

  • Select the first cell of data.
  • Go to the Data Tab, click on Filter from the Sort & Filter group.

 
img6

 
img7
 

  • If you want to put the data as per date.
  • Click on the filter with the mouse.
  • Drop down list will appear.
  • Select any date from the list.

 
img8
 

  • Only selected date’s related data will appear.

 
img9
 

  • We can follow the same procedure for Agent Name list and Revenue list.

These are the ways we can put the filter by using the shortcut key and from ribbon in Microsoft excel.
 
 



One thought on “Shortcut to Open a Filter dropdown list and the Filter in Ribbon in Microsoft Excel 2010

Leave a Reply

Your email address will not be published. Required fields are marked *


7 × = fourteen

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>