How to Filter Using Keystrokes

Microsoft Excel
1. Open the saved Excel 2010 worksheet.
2. Click a cell in the column you wish to filter.
3. Press the “Alt” key to display the alphabetical labels over the command ribbon.
4. Press the “H” key to access the “Home” tab. Alphabetical labels display over the Home tab commands.
5. Press the “S” key to open the “Sort Filter” menu in the “Editing” group. The “Sort Filter” options are “Sort Oldest to Newest,” “Sort Newest to Oldest,” “Custom Sort” and Filter.”
6. Press the navigation arrow keys to select the row with the preferred “Sort Filter” option you wish to apply to the worksheet data. If you highlight “Filter” and press “Tab,” the column header displays an arrow. The filter is enabled, but requires you to click the drop-menu and click the menu option.
7. Press “Enter” to filter the data.
Microsoft Word
8. Open the Word 2010 document you wish to filter.
9. Press the “Alt” key to display the alphabetical labels over the command ribbon.
10. Press the “H” key to access the “Home” tab. Alphabetical labels display over the “Home” tab commands.
11. Press the “S” and “O” keys to open the “Sort Text” dialogue box.
12. Press the navigation arrow keys located on the right section of the keyboard to navigate the options in the screen’s dialogue box. Categories include 'Sort by,' 'Type,' and 'Ascending' and 'Descending.'
13. Press the “Tab” key to tab to the next category to the right. Continue pressing the navigation arrow keys to highlight the preferred option in each text box.
14. Press “Enter.” The Word document sorts.