Shortcut to open drop down filter in Excel

Follow by Email
Facebook
Facebook
Google+
http://www.exceltip.com/excel-filter/use-keyboard-shortcut-to-open-a-filter-dropdown-list-in-excel-2007.html">
SHARE




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

“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

Excel filter 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.

Please follow and like us:
25


2 thoughts on “Shortcut to open drop down filter in Excel

Leave a Reply

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


one × = 8

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>