This post will explain 7 keyboard shortcuts for the filter drop-down menus. This includes my new favorite shortcut, and it's one that I think you will really like! The Filter drop-down menus (formerly known as Auto Filters in Excel 2003) are an extremely useful tool for sorting and filtering your data.

When the Filters are applied you will see small drop-down icon images in the header (top) row of your data range. These menus can be accessed with keyboard shortcuts, which makes it really fast to apply filters and sorting to different columns in your table. So let's take a look at these shortcuts. #1 – Turn Filters On or Off Ctrl+Shift+L is the keyboard shortcut to turn the filters on/off. You can see this shortcut by going to the Data tab on the Ribbon and hovering over the Filter button with the mouse. The screen tip will appear below the button and it displays the keyboard shortcut in the top line. This works with a lot of buttons in the ribbon and is a great way to learn keyboard shortcuts.

Adding a drop-down list to a cell or range using Data Validation is a simple matter. Manually entering the source data for the Excel 2010 drop down list is. B&B booking database from Appleworks 6.0 to Excel for Mac 2011, version 14.1.4. To add Excel tables to a data model, click the drop-down to the right of the “Add” button in the “Workbook Connections” dialog box. From the drop-down menu that appears, select the “Add to the Data Model” command. Media player for mac os x free download pc.

See the image below. To apply the drop down filters you will first need to select a cell in your data range. If your data range contains any blank columns or rows then it is best to select the entire range of cells. Once the data cell(s) are selected, press Ctrl+Shift+L to apply the filters. 32 bit emulator for mac.

The drop down filter menus should appear in the header row of your data, as shown in the image below. #2 Display the Filter Drop Down Menu Alt+Down Arrow is the keyboard shortcut to open the drop down menu. To use this shortcut: • Select a cell in the header row.

The cell must contain the filter drop down icon. • Press and hold the Alt key, then press the Down Arrow key on the keyboard to open the filter menu.

Once the drop down menu is open, there are a lot of keyboard shortcuts that apply to this menu. These shortcuts are explained next. Bonus Tip: If you are using, and I highly recommend you do, you can press Shift+Alt+ Down Arrow from any cell inside the table to open the filter drop-down menu for that column. This shortcut was introduced in Excel 2010 for Windows, and works in all newer versions as well.

#3 Underlined Letters & Arrow Keys The underlined letters in the drop-down menu are the shortcut keys for each command. For example, pressing the letter “S” on the keyboard will Sort the column A to Z. You must first press Alt+Down Arrow to display the drop down menu. So here are the full keyboard shortcuts for the filter drop down menu: • Alt+Down Arrow+ S – Sort A to Z • Alt+Down Arrow+ O – Sort Z to A • Alt+Down Arrow+ T – Sort by Color sub menu • Alt+Down Arrow+ I – Filter by Color sub menu • Alt+Down Arrow+ F – Text or Date Filter sub menu #4 Check/Uncheck Filter Items The up and down arrow keys will move through the items in the drop down menu. You can press the Enter key to perform that action. This requires the drop down menu to be open by first pressing Alt+Down Arrow.

See the image in #3 above for details. Starting in Excel 2007, a list of unique items appears at the bottom of the filter drop down menu with check boxes next to each item. You can use the up/down arrow keys to select these items in the list.

When an item is selected, pressing the space bar will check/uncheck the check box. Then press Enter to apply the filter. #5 Search Box – My New FAVORITE Starting in Excel 2010 a Search box was added to the filter drop-down menu. Excel 2011 for Mac users also get this feature. This search box allows you to type a search and narrow down the results of the filter items in the list below it. When the filter drop down menu is open, you can press the letter “E” on the keyboard to jump to the search box. This places the cursor in the search box and you can begin typing your search.

Alt+Down+Arrow+E is the shortcut to open the filter drop down menu and jump directly to the search box. I just learned this shortcut and it is my new favorite because it makes it so fast to type and filter exactly what you are looking for in the list. Prior to learning this I was using the down arrow key to get to the search box.

This required me to press the down arrow key 7 times to get to the search box. Now I can do the same thing in one step by pressing the letter “E”. What a time saver! #6 Clear Filters in Column Alt+Down Arrow+C will clear the filters in the selected column. Again, this is a combination of the Alt+Down Arrow to open the filter menu, then the letter “C” to clear the filter.