Use as screen reader to create a table in Excel Online

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.

Use Excel Online with your keyboard and a screen reader such as Narrator, the built-in Windows screen reader, to create a table. Tables provide easy filtering, in addition to calculated columns and total rows, which simplify calculations. You can quickly insert a table in the default table style, or format your data as a table in a style that you choose.

Notes: 

  • If you use Narrator with the Windows 10 Fall Creators Update, you have to turn off scan mode in order to edit documents, spreadsheets, or presentations with Office Online. For more information, refer to Turn off virtual or browse mode in screen readers in Windows 10 Fall Creators Update.

  • 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.

Create a table

  1. In Excel Online, select the cells that you want to include in the table.

  2. Press Ctrl+L to open the Create Table dialog box.

  3. In the Create Table dialog box, press Shift+Tab until you hear: "Unchecked, My table has headers checkbox." Press Spacebar to check or uncheck the My table has headers box, depending on whether you want the top row to be used as the table header.

    Note: Table headers are required to make a table accessible for screen readers. Screen readers use header information to understand how to locate table cells.

  4. Press the Tab key until you hear "OK, button," and then press Enter.

  5. You can now enter your data. To enter or replace data in a cell, move to the cell you want and type the text, number, or formula.

    Tip: To learn more about adding or editing your data, refer to Basic tasks using a screen reader with Excel.

    Tip: Organizing your data in an Excel Online table allows you to easily sort and filter data. To learn how to sort or filter data in a table, refer to Sort or filter a table in a workbook in Excel Online with a screen reader

See also

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

Use a screen reader to find and replace data in Excel

Keyboard shortcuts in Excel Online

Basic tasks using a screen reader with Excel

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.

×