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.
Notes: • New Office 365 features are released gradually to Office 365 subscribers, so your app might not have these features yet. To learn how you can get new features faster,. • To learn more about screen readers, go to. • When using Narrator, your keyboard will default to the Standard layout.
To change this in the Narrator settings, press the Windows logo key+Ctrl+N. Press the Tab key until you hear: 'Select keyboard layout, Standard.' To change the layout to Legacy, press the Down arrow key once. You hear: 'Legacy, selected.' The new Narrator commands will not be available in the Legacy keyboard layout if keystrokes for legacy commands conflict with those used in new Narrator features.
• This topic assumes you are using this app with a PC. Some navigation and gestures might be different for a Windows phone or tablet. In this topic • • • • • • • • • Keyboard shortcuts for sorting and filtering This table shows keyboard shortcuts for sorting and filtering. Note: Once you sort the data, you cannot restore the original order. If you haven't saved the file after sorting, you can use undo (Ctrl+Z) to go back. Sort text in a table or range Sort text in a table • Navigate to the header row in the table using the arrow keys. When you are on the header row, in Narrator, you hear 'Header item' after the cell location.
• Press the Right or Left arrow key to move to the column header for the data that you want to sort. • Press Alt+Down arrow key to open the filter menu, and then press the Tab key to move into the menu. In Narrator, you hear: 'Menu, Sort A to Z, unchecked menu item.' • The options that appear depend on the kind of data in the column.
For example, you can sort numeric data from Smallest to Largest or Largest to Smallest. You can sort alphanumeric data from A to Z, from Z to A, or by color. Use the Down arrow key to browse the options, and press Enter to select an option. In Narrator, you hear 'Sorted,' followed by the selected option. Sort text in a range • Use the arrow keys to navigate to a column of alphanumeric data in a range of cells, or to a table column containing alphanumeric data. • Press Alt+A. The Data tab opens, and you hear: “Upper ribbon, Group box, Data tab.” In Narrator, you hear: “Ribbon tabs, Selected, Data tab item.” Do one of the following: • To sort in ascending alphanumeric order (Sort A to Z), press S+A.
• To sort in descending alphanumeric order (Sort Z to A), press S+D. Make a case sensitive sort • Use the arrow keys to navigate to a column of alphanumeric data in a range of cells, or to a table column containing alphanumeric data. • Press Alt+H, S, U. The Sort dialog opens, and in Narrator you hear: “Sort, OK button.” In JAWS, you hear: “Sort dialog, OK button.” • Press Alt+O to open the Sort Options dialog. In Narrator, you hear: “Sort options.
Unchecked, Case sensitive check box.” In JAWS, you hear: “Sort options dialog, Case sensitive checkbox, not checked.” • Press Spacebar to select the Case sensitive check box. • Press Enter. The Sort Options dialog closes, and in Narrator you hear: “Sort, Options button.” In JAWS, you hear: “Sort dialog.” • To close the Sort dialog and apply your changes, press the Tab key until you hear 'OK button,' and press Enter. • Sort text as explained in. Tip: If the column you sort contains a mixture of numbers and text, you might have to format them all as text. 
Otherwise, Excel sorts the numbers as numbers first, and then sorts the text. To format the data, press Ctrl+Spacebar to select all the data in the column, and then press Alt+H, F, N.
Press the Left arrow key until you hear 'Selected, Number tab item,' press the Tab key once, and then press the Down arrow key until you hear: 'Text'. Press the Tab key once to move to the OK button, and press Enter. Tips: • When you import or copy data from a different location, it can have leading spaces inserted before data.
For example, the name 'Sue Lidman' might be entered as '(space)(space)Sue Lidman'. • If you use a screen reader, you might not know about the spaces, because JAWS doesn’t read empty space in cells.
• To help you find them, Excel places cells that have leading spaces at the top of a sorted column. Sort numbers • Use the arrow keys to navigate to a column of numeric data in a range of cells, or to a table column containing numeric data.