Use a screen reader to filter data in a range or table

Read out loud symbol with the label Screen reader content. This topic is about using a screen reader with Office

This article is for people who use a screen reader program with the Office products and is part of the Office Accessibility content set. For more general help, see Office Support home.

You can filter data in a range or table Excel 2016 using a keyboard and a screen reader. Filtering data helps you focus on a particular set of data, which is especially useful in large worksheets.

In this topic:

Filter data in a table

When you put your data in a table , Excel automatically adds an AutoFilter drop-down menu to each column header. You can open this menu to filter quickly. To remove the AutoFilter drop-down menu from a column heading, select the header and then press Ctrl+Shift+L

  1. In the table header of the column you want to filter, press Alt+Down Arrow. The AutoFilter drop-down menu opens, and you hear “Type words to search for, Menu.” (In Narrator, you hear “Group.”)

  2. On the AutoFilter menu, if the column has numbers, use the Down Arrow key to move to Number Filters and press Enter. If the column has text entries, move to Text Filters and press Enter. The submenu opens, and you hear “Equals.”

  3. To move to the filtering option you want, use the arrow keys and press Enter. The Custom AutoFilter dialog box opens, and you hear “Custom AutoFilter dialog.” (In Narrator, you hear “Custom AutoFilter window.”)

  4. Type or select your filtering conditions.

    For example, to show numbers above a certain amount, select Greater Than Or Equal To and then enter the number you have in mind in the next combo box.

    To filter by two conditions, enter filtering conditions in both sets of edit combo boxes, and then pick And for both conditions to be true, or pick Or for either of the conditions to be true.

  5. To close the dialog box, tab to the OK button and press Enter.

Filter data in a range

  1. Select the cells you want to filter.

  2. Press Ctrl+Shift+L. Excel adds an AutoFilter drop-down menu to the first cell in the range.

  3. Select the cell with the AutoFilter drop-down menu.

  4. Press Alt+Down Arrow. The AutoFilter drop-down menu opens, and you hear “Type words to search for, Menu” (In Narrator, you hear “Group.”)

  5. Use the arrow keys and the Tab key to move to the filtering options you want.

  6. When you’ve made your selections, tab to the OK button and then press Enter.

To clear the filter, select any cell in the range and then press Ctrl+Shift+L.

See also

Use a screen reader to insert a table in an Excel 2016 worksheet

Use Excel for Mac 2016, your keyboard, and Mac’s built-in screen reader VoiceOver to filter data in a range or table.

In this topic

Filter data in a table

When you filter data in a table, the filtering controls automatically get added to the table headers.

  1. Navigate to the first cell in the data range you want to filter.

  2. Press Fn + F8 to turn on the capability to extend your selection using the arrow keys. Then, use the arrow keys to select all the data needed for your range.

    Notes: Alternatively, you may use these keyboard shortcuts to select specific portions of your worksheet:

    • Press Command + A to select the entire worksheet.

    • Press Command + A + * to select only the visible cells.

    • Press Control + Spacebar to select an entire column.

    • Press Shift + Spacebar to select an entire row.

  3. Press Fn + F6 to begin navigating through the ribbon tabs.

  4. Use the Left and Right Arrow keys to toggle through the tabs until you hear “Home tab.” Then, press VO + Down Arrow to access the Home tab options.

  5. Press Tab to scroll through the options until you hear “Format as a table,” then, press Return.

  6. You’ll hear the range of cells included in the table you’re creating. Then, you'll hear “My table has headers, unchecked checkbox.” Press Spacebar to check the checkbox if you want Excel for Mac 2016 to add placeholder headers above the data in your table. You can rename the headers later.

  7. Press Tab once. You should hear “Okay, button.” Press Return. You should hear “Table created.”

  8. To apply a filter, press Fn + F6 until you hear “Worksheet.”

  9. Use the arrow keys to navigate to the header of the column data you want to filter.

  10. Press Spacebar. You should hear “Filter, popup menu.”

  11. Use the Up and Down Arrow keys to toggle through the main filter options. Press VO + Down Arrow to select a filter and open the popup menu for that option.

  12. Use the Up and Down Arrow keys to toggle through your options. Press Spacebar to make a selection.

  13. Press Tab once. Enter your filter criteria in the text box or select the appropriate checkbox or radio button by pressing Spacebar.

  14. Press Return. You should hear “Filter applied.”

Filter data in a range

It is also possible to filter data in a range. For the best results, each column should have a header.

  1. Navigate to the first cell in the range of data you want to filter by using the arrow keys until you hear the data in the cell needed.

  2. Press Fn + F8 to turn on the capability to extend your selection using the arrow keys. Then, use the arrow keys to select all the data needed for your range.

    Notes: Alternatively, you may use these keyboard shortcuts to select specific portions of your worksheet:

    • Press Command + A to select the entire worksheet.

    • Press Command + A + * to select only the visible cells.

    • Press Control + Spacebar to select an entire column.

    • Press Shift + Spacebar to select an entire row.

  3. Press Fn + F6 to open the ribbon tabs.

  4. Press Left or Right Arrow until you hear, “Data tab.” Then, press VO + Down Arrow to open the Data tab options.

  5. Press Tab to move forward through the options until you hear “Filter.” Then, press Spacebar to open the Filter dialog box.

  6. Press Tab to toggle through the filter options. Press Spacebar to make a selection and open the Custom Filter dialog box.

  7. Press Tab to toggle through the options available for the filter you selected — enter necessary criteria or use Spacebar to check/uncheck checkboxes or select/unselect radio buttons as needed.

  8. Press Tab until you hear “Okay, button.” Press Return. You should hear “Filter applied.”

Filtering options for ranges and tables

Excel for Mac 2016 lets you apply a general filter option, which then lets you customize the filter to meet your needs.

When you choose a main filter type, you hear the Custom Filter options available for that specific filter. You hear number ranges and options for Number Filters, color options for Color Filters, and text for Text Filters. (The numbers, colors, or text options come from the data you’re filtering.)

Text Filters options

  • Equals/Does Not Equal: Filters column data to display or hide the exact text you type in the Custom Filter dialog box.

  • Begins With/Ends With: Filters column data to display data that begins with or ends with the exact text you type in the Custom Filter dialog box.

  • Contains/Does Not Contain: Filters column data to display or hide data that includes the exact text you type in the Custom Filter dialog box.

Number Filters options

  • Equals/Does Not Equal: Filters column data to display or hide the exact number you type in the Custom Filter dialog box.

  • Greater Than/Less Than: Filters column data to display all numbers with a greater or lesser value than the number you type in the Custom Filter dialog box.

  • Between: Filters column data to display all numbers within a specific numerical range typed into the two text boxes provided in the Custom Filter dialog box.

    Note: To use this option, input the beginning number for your range, press Tab once, then enter the end number for your range.

  • Top 10: Filters the column data to display the top 10 (highest or lowest) numerical values or percentages. To use this filter, press Spacebar to select the Top 10 filter. When the dialog box opens, you hear “Focus on editing 10.” This option automatically filters the highest numbers.

    Note: If you want to filter the lowest numbers or percentages, press Tab until you hear “Top editable combo box.” Press VO + Down Arrow to open the popup menu. Press Down Arrow until you hear “Bottom.” Then, press Spacebar.To filter percentages instead of numerical values, press Tab until you hear “Percentage, radio button.” Then, press Spacebar.

  • Above/Below Average - Filters column data to display numerical values that are above or below the average value of all the numbers in the column.

Color Filters options

  • Filter by Font Color: Filters the column data to include the cells containing data written in the specific font colors you’ve selected. When you open the dialog box, you hear the numerical value (RGB value) of the first font color displayed in your column. Use the Up and Down Arrow keys to toggle between the available colors, pressing Control + Spacebar to select the colors you want.

  • Filter by Cell Color: Filters the column data to include the cells that are filled with specific colors. When you open the dialog box, you hear the RGB value of the first cell color displayed in your column. Use the Up and Down Arrow keys to toggle between the available colors, pressing Control + Spacebar to select colors.

  • Automatic: Choose the Automatic option to display cells containing data written in Excel for Mac 2016’s default font color, black.

  • No Fill: Choose the No Fill option to display cells without a custom background color — this displays cells featuring the default white background.

In Excel for iPhone use VoiceOver, the built-in screen reader for iOS, with your iPhone or iPod Touch to place and filter data in a range or table.

In this topic

Filter data in a range

  1. Use two fingers to select the data you want to filter.

  2. Locate the More Options button near the top of the screen on your iOS device. You hear "More Options" once the button is selected. Double tap your screen.

  3. A Tab menu opens, and you hear "Tab menu home selected." Scroll down on this menu until you hear "Sort and filter menu." Double tap the screen to reveal the menu.

  4. Sort data alphabetically or numerically by selecting and double tapping Sort Ascending or Sort Descending from the Sort and Filter menu. If the active column contains text only or a combination of text and numbers, your data is sorted alphabetically. If the active column contains numbers only, your data is sorted by value. Data sorts from smallest to largest if you choose Sort Ascending and from largest to smallest if you choose Sort Descending.

  5. Select Show Filter Buttons from the Sort and Filter menu to add a drop-down menu arrow to the first row of each column. Double tap the drop-down arrow in the column you want to work with. Once the menu opens, proceed to step 2 in the "Filter data in a table" section below.

    Note: If your data does not contain headers, you must place the data in a table first before you can use the Sort and Filter menu to successfully filter all of the data in each column. If the data does not contain headers and you do not put the data in a table, the first cell of each column selected is treated as a header.

Place data in a table

  1. Select the data you want to filter and locate the More Options button near the top of the screen on your iOS device. Double tap to reveal the Tab menu.

  2. Once the Tab menu opens, Home is the default selection. You hear "Home tab selected." Directly beneath the Home tab is the Insert tab. Double tap Insert.

  3. The first option on the Insert menu is the Table button. It is located directly beneath the Insert tab. Select the Table button, then double tap your screen. Excel for iPhone places your selected data into a table and includes headers as placeholders in the first row.

  4. A small dialog box containing a Table has Header checkbox appears on top of your table. You hear "Unchecked headers checkbox." To keep the header placeholders Excel created, simply press Back to clear the dialog box.

  5. If your table already has headers, select the Table has Headers checkbox, and double tap to place a checkmark in the box. Once you hear "Checked," press Back on your device to clear the dialog box. Excel will now use the headers included in your table.

Filter data in a table

  1. If your table did not include headers, the default placeholder header text created by Excel are Column 1, Column 2, Column 3, etc, and each column header already includes the Sort and Filter drop-down menu arrow. Select the drop-down menu arrow, which is located to the far right of the header cell. You hear the cell information and "No filter applied" once it's selected. Double tap to reveal the Sort and Filter menu.

  2. You hear "Sort and Filter" when the menu opens. Go to Filter Items on the menu, then double tap. A Filter Items window appears, and the Edit box is selected by default. You hear "Column search edit box." Below the Edit box is a Select All button. Below the Select All button is a list of all the data in the column you selected.

  3. Double tap the Edit box to begin typing in the exact information you want to filter. At any moment you can select the data you want to filter from the provided list by double tapping it. VoiceOver reads the name of each selection you make. You can also select all of the data in a column by double tapping the Select All button.

  4. Once you make a selection, the Select All button is replaced by a Clear All button. Select Clear All if you make an error or want to start over.

  5. After making your filter selections, press the Done button located at the top right corner of the screen, then double tap. You are routed to your Excel workbook, and the filter is applied.

  6. Clear an applied filter by first selecting the Filter icon located in the header of the column you wish to reset. Once the icon is selected, you hear the column header information and "Filter applied." Double tap to reveal the drop-down menu. The last option in the menu is Clear Filter. Select, then double tap this option to reset the column.

    Note: Sort text only or alphanumeric data in your table alphabetically in ascending or descending order in the Sort and Filter menu by selecting and double tapping the A to Z or Z to A options. VoiceOver confirms when either option is active in your column.Sort columns containing numeric data only in ascending or descending order in the Sort and Filter menu by selecting and double tapping Smallest to Largest or Largest to Smallest option. VoiceOver confirms when either option is active in your column.

In Excel for Android, use TalkBack, Android's built-in screen reader, with your Android phone to place and filter data in a range or table.

In this topic

Select data

  1. Select the first cell of the data you want to filter. TalkBack reads the column letter, row number, and content within the cell. Next, you hear "Double tap to activate." Double tap the cell to make it active. TalkBack reads the cell information again, then you hear "Selected."

  2. Use two fingers to select the exact cells you want to filter. After making the selection, release your fingers from the screen. A horizontal menu immediately pops up directly below your selected cells. Simply turn your Android phone from the portrait position to the landscape position (or vice versa) to clear this menu from your screen. After you clear the menu, TalkBack reads the column letter, row number, and cell content of the last cell in your selection.

    Notes: 

    • TalkBack requires two fingers for scrolling through Excel worksheets or selecting cells on an Android phone.

    • Change the position of your phone to portrait or landscape whenever a menu you don't need appears on your screen; this clears it instantly. You can also use your phone's Back button to clear these menus. When you press the Back button, you hear "Back button, double tap to activate, double tap and hold to long press." Double tap to clear the unwanted menu.

Filter data in a range

  1. Locate the More Options button at the top of the screen on your Android phone. You hear "More Options button. Double tap to activate, double tap and hold to long press." Double tap More Options to make the menu active, when it opens, you hear "Tab menu Home selected."

  2. Use two fingers to scroll down until you reach the Sort and Filter menu. When you tap it, you hear "Sort and Filter menu. Double tap to activate, double tap and hold to long press." Double tap this option. You hear "Sort and Filter" when the menu is active.

  3. Sort data alphabetically or numerically by selecting and double tapping Sort Ascending or Sort Descending from the menu. If the active column contains text only or a combination of text and numbers, your data is sorted alphabetically. If the active column contains numbers only, your data is sorted by value; from smallest to largest if you choose Sort Ascending, or from largest to smallest if you choose Sort Descending.

  4. The procedure for filtering your data varies depending on the document's header status:

    • If the columns you want to filter already contain headers, select the Show Filter Buttons option from the Sort and Filter menu to add a drop-down menu arrow to each header. Double tap the arrow in the column you want to work with to reveal the drop-down menu. Once the menu opens, go to step 2 in the "Filter data in table" section below to proceed.

    • If your data does not contain headers, you must place the data in a table first before you can use the Sort and Filter menu to successfully filter all of the data in each column. If the data does not contain headers and you do not put the data in a table, the first cell of each column selected is treated as a header.

Place data in a table

  1. Locate the More Options button at the top of the screen on your Android phone. You hear "More Options button. Double tap to activate, double tap and hold to long press." Double tap More Options to make the menu active.

  2. A menu appears, and you hear "Tab Menu Home selected. Double tap to activate, double tap and hold to long press." Double tap Home.

  3. A new menu appears, and you hear "Selected Home tab." Right below the Home tab is the Insert tab. Select the Insert tab, and double tap to make it active.

  4. A new menu appears, and you hear "Tab menu insert selected." Right below Insert is the Table button. Select Table, and double tap the button to make it active. Excel for Android places your selected data into a table and includes headers as placeholders in the first row.

  5. A small dialog box containing a Table has headers checkbox appears on top of your table. You hear "Not checked table has headers checkbox." To keep the header placeholders Excel created, simply shift your phone into the portrait or landscape position to clear the dialog box.

  6. If your table already has headers, select the Table has headers checkbox. Once selected, you hear "Table has headers checkbox; double tap to toggle." Double tap to place a checkmark in the box. Once you hear "Checked," shift your phone into the portrait or landscape position to clear the dialog box. Excel now uses the headers included in your table.

Filter data in a table

  1. If your table did not include headers, the default placeholder header text created by Excel are Column 1, Column 2, Column 3, etc. Each column header already includes the Sort and Filter drop-down menu arrow. Select the small down-facing arrow in the header of the column you want to work with. You hear the cell information and "No filter applied, double tap to activate." Double tap the arrow to reveal the drop-down menu.

  2. You hear "Sort and Filter" when the menu opens. Go to Filter Items on the menu, and double tap to activate. A Filter Items window appears, and the Edit box is selected by default. You hear "Column search edit box." Below the Edit box is a Select All button. Below the Select All button is a list of all the data in the column you selected.

  3. Double tap the Edit box to begin typing in the exact information you want to filter. At any moment, you can select the data you want to filter from the provided list by double tapping it. TalkBack reads the name of each selection you make. You can also select all of the data in a column by double tapping the Select All button.

  4. Once you make a selection, the Select All button is replaced by a Clear All button. Select Clear All if you make an error or want to start over.

  5. After making your selections, press the Done button at the top of the screen, and double tap to activate it. You are then routed to your Excel workbook, and the filter is applied.

  6. Clear an applied filter by first selecting the Filter icon located in the header of the column you wish to reset. Once the icon is selected, you hear the column header information and "Filter applied." Double tap to reveal the drop-down menu. The last option in the menu is Clear Filter. Select and then double tap this option to reset the column.

  7. The process of sorting your data depends on the type of data in the cells:

    • If the data in the column you wish to filter contains text only or text and numbers, you can sort the column alphabetically in ascending or descending order. Do this in the Sort and Filter menu by selecting and double-tapping the A to Z or Z to A options. TalkBack confirms when either option is active in your column.

    • If the data in the column you wish to filter contains numbers only, you can sort the numbers by value. Do this in the Sort and Filter menu by selecting and double-tapping Smallest to Largest or Largest to Smallest option. TalkBack confirms when either option is active in your column.

Use Excel 2016, your Windows PC, and the Windows Narrator or JAWS (Job Access With Speech) screen reader to place and filter data in a range or table.

In this topic

Filter data in a range

  1. Select the range of data you want to filter.

  2. Press Ctrl+Shift+L to place a Filter and Sort drop-down menu arrow in the first row of each column you selected. Once the drop-down menu arrow appears, you hear the column letter and row number of the active cell and "No filter applied."

  3. The process of filtering your data varies depending on the document's header status:

    • If each column you selected contains header text, proceed to the first step in the "Filter data in a table" section below to filter your data.

    • If the columns you selected do not contain header text, you must first place the data in a table before using the Filter and Sort menu to filter the data in each column.

    Note: If the data you select does not contain headers and you do not put the data in a table, the first cell of each column is treated as a header, and the filter does not include the data in those cells.

Place data in a table

  1. Select the data you want to filter.

  2. Press Ctrl+L to open the Create Table dialog box. You hear "Create table" and the range of cells you selected. Verify that the range of selected cells is correct.

  3. The process of placing data in the table depends on the document's header status:

    • If your data does not have headers, simply press Enter after opening the Create Table dialog box to place your data.

    • If your data has headers, press Tab until you hear "Unchecked my table has headers checkbox." Press Spacebar to check the box, then press Enter to place your data.

    Note: If a table does not have headers, Excel 2016 creates them by inserting placeholder texts in the first row. Default placeholder text are Column 1, Column 2, Column 3, etc. Change the name of the header text by using the arrow keys to move to the appropriate cell and typing the new header name.

Filter data in a table

  1. Select the header cell of the column you want to filter. You hear the column letter, row number, "selected, editable," the cell content, "no filter applied, menu item."

  2. Press Alt+Down Arrow to reveal the Filter and Sort drop-down menu. You can also select the arrow in the far right corner of the header cell to access the menu. You hear "Custom control" when the menu opens.

  3. Press Down Arrow in the submenu until you hear the filter you want to apply to your data, then press Enter. A Custom Filter dialog box opens with filter options. Press Tab to move between fields in the Custom Filter dialog box.

  4. To filter your data, press Down Arrow in the Filter and Sort menu until you hear "Text Filters" or "Number Filters." If the data in the active column contains text only or a combination of text and numbers, a Text Filters option is available on the menu. If the data in the column contains numbers only, there is instead a Number Filters option on the menu. You can also choose Filter by Color or Sort by color if the data you want to sort or filter contains a colored font or if your cells feature different colors. A submenu opens once you make your selection.

    Note: To sort data in a column alphabetically in ascending order, press Down Arrow until you hear "Sort A to Z," then press Enter. Sort the data alphabetically in descending order by pressing Down Arrow until you hear "Sort Z to A," then press Enter. You have the option to sort alphabetically if the active column contains text only or a combination of text and numbers.To sort numeric column data in ascending order, press Down Arrow until you hear "Smallest to Largest," then press Enter. Sort numeric data in descending order by pressing Down Arrow until you hear "Largest to Smallest," then press Enter. You have the option to sort numerically if the active column contains numbers only.

Filtering options for tables

Text Filters options

  • Equals - Filters column to display the exact text you type in the Custom Filter dialog box.

  • Does Not Equal - Filters column to display everything except the text you type in the Custom Filter dialog box.

  • Begins With - Filters column to display data that begins with the exact text you type in the Custom Filter dialog box. The text can have any ending.

  • Ends With - Filters column to display data that ends with the exact text you type in the Custom Filter dialog box. The text can have any beginning.

  • Contains - Filters column to display data that includes the exact text you type in the Custom Filter dialog box.

  • Does Not Contain - Filters column to display data that does not include the text you type in the Custom Filter dialog box.

  • Custom Filter - Allows you to choose the filter you want to apply to your data from a drop-down menu. To use this option, you must first type the text you want to filter. Next, press Tab until you hear "Editable combo box." Press Alt+Down Arrow to view the drop-down menu. Use Down Arrow to select your desired filter, then press Enter. You hear "Filter applied" once the action is complete.

Number Filters options

  • Equals - Filters column to display the exact number you type in the Custom Filter dialog box.

  • Does Not Equal - Filters column to display all numbers except the exact number you type in the Custom Filter dialog box.

  • Greater Than - Filters column to display all numbers with a greater value than the number you type in the Custom Filter dialog box.

  • Less Than - Filters column to display all numbers with a lesser value than the number you type in the Custom Filter dialog box.

  • Between - Filters column to display all numbers within a specific numerical range. Input the range in the two provided Custom Filter dialog boxes.

  • Top 10 - Filters column to display numbers with the highest or lowest numerical values or percentages. You hear the name of the active cell and "Focus on editing 10" when the dialog box opens. The dialog box defaults to the top 10 numbers (called items), but you can change this number to any value. To filter percentages instead of numbers, press Tab until you hear "Items," then press Alt+Down Arrow. Press Down Arrow. When you hear "Percentage," press Enter. To filter bottom numbers or percentages, Tab until you hear "Top editable combo box." Press Alt+Down Arrow. Then, press Down Arrow to select "Bottom," then press Enter.

  • Above Average - Filters column to display the numbers that are above the average value of all numbers in the column.

  • Below Average - Filters column to display the numbers that are below the average value of all numbers in the colu

  • Filter by Font Color - Filters active column to display the font color you select from the submenu. When the menu opens, you immediately hear the RGB value of the first font color in your column. Press Enter to choose this color, or press Down Arrow until you hear the RGB value of the color you want.

  • Filter by Cell Color - Filters active column to display the cell color you select from the submenu. When the menu opens, you immediately hear the RGB value of the first cell color in your column. Press Enter to choose this color, or press Down Arrow until you hear the RGB value of the color you want.

  • Automatic - Filters active column to display cells containing Excel's default font color, black.

  • No Fill - Filters active column to display cells without color. These cells feature Excel's default white background and black font.

Sort by Color options

  • Sort by Cell Color - Sorts active column by cell color. This option places cells featuring the color you select from the submenu first in the column.

  • Sort by Font Color - Sorts active column cell by font color. This option places cells featuring the font color you select first in the column.

  • Automatic - Places cells with Excel's default font color, black, first in the column.

  • Custom Sort - Use this option to sort data however you wish. For example, you can sort alphabetically first, then by numeric value, then by font color, then by cell co

In Excel Online, use the Windows Narrator or JAWS (Job Access With Speech) screen reader to filter data in a range or table.

In this topic

Place data in a table

  1. Select the data you want to filter.

  2. Press Ctrl+L to open the Create Table dialog box. You should hear "Dialog create table focus on OK button."

  3. If your table contains no headers, simply press Enter after opening the Create Table dialog box.

  4. If your table has headers, press Tab until you hear "Unchecked my table has headers checkbox." Hit Spacebar to check the box, then press Enter.

    If your table contains no headers, Excel Online creates them by inserting placeholder texts in the first row. Default placeholder text are Column 1, Column 2, Column 3, etc. Change the name of the header text by clicking on it and entering the name you want.

Filter data in a table

  1. Select the header cell of the column you want to filter.

  2. Press Alt+Down Arrow to open the Filter and Sort drop-down menu. You can also select the arrow to the right of the header cell to access the menu.

  3. Press the Down Arrow key until you hear "Text Filters" or "Number Filters,"then press Enter to access the submenu. You hear "Text Filters" if the column contains only text or a combination of text and numbers. You hear "Number Filters" if the column only contains numbers.

  4. Press the Down Arrow key in the submenu until you hear the name of the filter you want to apply to your data, then press Enter. A Custom Filter dialog box opens for each filter option. You hear "Dialog custom filter focus on editing" when the dialog box opens, and you hear "Filter applied" once the action is complete.

    Press the Tab key to move between fields in the Custom Filter dialog, including the And/Or radio buttons.

  5. Clear an applied filter by first selecting the header cell of the column you want to reset. If you select cell A1, for example, press Alt+Down Arrow to expose the drop-down menu, then press the Down Arrow button until you hear "Clear filter from Column 1." Press Enter. You hear "No filter applied" when the action is complete. If you renamed the header text for cell A1, you hear the name of the header instead of "Column 1."

Filtering options for tables

Number Filters options

  • Equals - Filters column to display the exact number you type in the Custom Filter dialog box.

  • Does Not Equal - Filters column to display all numbers except the exact number you type in the Custom Filter dialog box. 

  • Greater Than - Filters column to display all numbers with a greater value than the number you type in the Custom Filter dialog box. 

  • Less Than - Filters column to display all numbers with a lesser value than the number you type in the Custom Filter dialog box. 

  • Between - Filters column to display all numbers within a specific numerical range. Input the range in the two provided Custom Filter dialog boxes. 

  • Top 10 - Filters column to display numbers with the highest or lowest numerical values or percentages. You hear the name of the active cell and "Focus on editing 10" when the dialog box opens. The dialog box defaults to the top 10 numbers (called items), but you can change this number to any value. To filter percentages instead of numbers, press the Tab key until you hear "Items," then press Alt+Down Arrow. Press the Down Arrow. When you hear "Percentage," press Enter. To filter bottom numbers or percentages, Tab until you hear "Top editable combo box." Press Alt+Down Arrow. Then, press the Down Arrow to select "Bottom," then press Enter.

  • Above Average - Filters column to display the numbers that are above the average value of all numbers in the column.

  • Below Average - Filters column to display the numbers that are below the average value of all numbers in the column.

  • Custom Filter - Use this option to choose the filter you want to apply to your numerical data from a drop-down menu. To use this option, you must first type the number you want to filter into the dialog box. Next, press Tab until you hear "Editable combo box." Press Alt+Down Arrow to view the drop-down menu. Use the Down Arrow to select your desired filter, then press Enter. You hear "Filter applied" once the action is complete.

Text Filters options

  • Equals - Filters column to display the exact text you type in the Custom Filter dialog box.

  • Does Not Equal - Filters column to display everything except the text you type in the Custom Filter dialog box.

  • Begins With - Filters column to display data that begins with the exact text you type in the Custom Filter dialog box. The text can have any ending.

  • Ends With - Filters column to display data that ends with the exact text you type in the Custom Filter dialog box. The text can have any beginning.

  • Contains - Filters column to display data that includes the exact text you type in the Custom Filter dialog box.

  • Does Not Contain - Filters column to display data that does not include the text you type in the Custom Filter dialog box.

  • Custom Filter - Allows you to choose the filter you want to apply to your data from a drop-down menu. To use this option, you must first type the text you want to filter. Next, press Tab until you hear "Editable combo box." Press Alt+Down Arrow to view the drop-down menu. Use the Down Arrow to select your desired filter, then press Enter. You hear "Filter applied" once the action is complete.

Expand your skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×