Sort or filter a table in a workbook in Excel Online with a screen reader

You can sort and filter data in your tables in Excel Online by using a keyboard and a screen reader. Sorting and filtering can help you find and analyze data faster.

Note: Excel Online is a web-based application, so the keyboard shortcuts and navigation may be different from those in Excel 2016. To learn more, see Accessibility features in Excel Online.

In this topic

Sort data in a table

  1. If your data is just in a range of cells, start by placing it in a table:

    • Select the first cell of your data.

    • To create a table, press Ctrl+L and then Enter.

    Notes: If your data didn't have headers, Excel Online creates headers in your table with placeholder text, such as Column 1. To edit the placeholder text, select the column header and type the column header name that you want.

    Column headers include a Filter and Sort button. See also Create a table in Excel Online when using a screen reader .

  2. Select the table header cell of the column you want to sort.

  3. Press Alt+Down Arrow. The Filter and Sort context menu opens and you hear “Context menu, Sort ascending.” (In Narrator, you hear “Sort ascending, Menu item.”)

  4. On the context menu, use the Up and Down arrows to select the kind of sort you want (for example, Sort Ascending or Sort Descending.)

  5. Press Enter to sort the data.

Filter data in a table

  1. In your table, select the table header cell of the column you want to filter by.

  2. Press Alt+Down Arrow. The Filter and Sort context menu opens and you hear “Context menu, Sort ascending.” (In Narrator, you hear “Sort ascending, Menu item.”)

  3. On the context menu, use the Up and Down arrows to select one of the following filters and then press Enter.

    • Text filters. This option is available when the column contains text or a mix of text and numbers, and it lets you specify criteria to filter by.

    • Number Filters. This option is available when the column contains only numbers, and it lets you specify criteria to filter by.

    • Filter. This option enables you to select all cells or only the cells containing specific content.

    • Clear Filter from ‘Column.’ This option is available when the Filter option has been selected. To clear the filter, press Enter.

  4. If you select Text Filters or Number Filters:

    1. When you hear the filter you want, press Enter. The selected submenu opens and you hear “Equals ...” (In Narrator, you hear “Equals, Menu item.”)

    2. On the submenu, use the Up and Down arrows to select the option you want and then press Enter.

    3. In the Custom Filter dialog box, create your filter criteria or select the values to filter on.

    4. Tab to the OK button and press Enter.

  5. If you select Filter:

    1. The Filter dialog box opens with the (Select All) check box selected.

    2. Use the Up and Down arrows to move to the check box you want and clear or select it.

    3. Tab to the OK button and press Enter.

More information

Keyboard shortcuts in Excel Online

Create a table in Excel Online when using a screen reader

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×