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

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 sort and filter data in your tables in Excel Online by using a keyboard and a screen reader such as Narrator, the built-in Windows screen reader. Sorting and filtering can help you find and analyze data faster.

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 could get new features faster, visit When do I get the newest features in Office 2016 for Office 365?.

  • For keyboard shortcuts, go to Keyboard shortcuts in Excel Online.

  • This topic assumes that you are using the built-in Windows screen reader, Narrator. To learn more about using Narrator, go to Get started with Narrator.

  • This topic makes note of the JAWS functionality as well. To learn more about JAWS for Windows, go to JAWS for Windows Quick Start Guide.

  • This topic assumes you are using this app with a PC. Some navigation and gestures might be different for a Windows phone or tablet.

  • When you use Excel Online, we recommend that you use Microsoft Edge as your web browser. Because Excel Online runs in your web browser, the keyboard shortcuts are different from those in the desktop program. For example, you’ll use Ctrl+F6 instead of F6 for jumping in and out of the commands. Also, common shortcuts like F1 (Help) and Ctrl+O (Open) apply to the web browser – not 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.

See also

Create a table in Excel Online when using a screen reader

Keyboard shortcuts in Excel Online

Basic tasks in Excel Online with a screen reader

Learn how to navigate in Excel using accessible features

Technical support for customers with disabilities

Microsoft wants to provide the best possible experience for all our customers. If you have a disability or questions related to accessibility, please contact the Microsoft Disability Answer Desk for technical assistance. The Disability Answer Desk support team is trained in using many popular assistive technologies and can offer assistance in English, Spanish, French, and American Sign Language. Please go to the Microsoft Disability Answer Desk site to find out the contact details for your region.

If you are a government, commercial, or enterprise user, please contact the enterprise Disability Answer Desk.

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.

×