You can also easily refer to the table in formulas. With the descriptive name, you can, for example, quickly jump to the table with the Go To command (Ctrl+G) or the Name Manager dialog box.
A meaningful table name like "EmployeeList" is more helpful than the generic "Table1." Name a tableīy default, Excel names the tables you create as Table1, Table2, Table3, and so on. To make it easier to refer to a table, give each table a descriptive name. It is also important to specify column header information and use a simple table structure to make sure that screen reader users can navigate the tables easily.
When you carefully name and format your table, you can be sure that everyone can understand your data. Tables can help you identify a set of data by name, and you can format the table using styles that make the data stand out. For more info, go to Accessibility Ribbon and Improve accessibility with the Accessibility Checker. The Accessibility ribbon contains all the tools you need to create accessible spreadsheets in one place. To manually launch the Accessibility Checker, select Review > Check Accessibility. The Accessibility pane and the Accessibility ribbon open, and you can now review and fix accessibility issues. In Excel, the Accessibility Checker runs automatically in the background when you're creating a document. If the Accessibility Checker detects accessibility issues, you will get a reminder in the status bar. The Accessibility Checker also suggests how you can resolve the issues that appear. It explains why each issue might be a potential problem for someone with a disability. The Accessibility Checker is a tool that reviews your content and flags accessibility issues it comes across. Top of Page Check accessibility while you work in Excel When you name cells and ranges, screen reader users can quickly identify the purpose of cells and ranges. Visually scan your workbook to see which cells and ranges would benefit from having a name. Screen readers read sheet names, which provide information about what is found on the worksheet, making it easier to understand the contents of a workbook and to navigate through it. To find out whether all sheets that contain content in a workbook have descriptive names and whether there are any blank sheets, use the Accessibility Checker. Give all worksheets unique names, and remove blank worksheets. If your spreadsheet has a high level of contrast between text and background, more people can see and use the content. You can also look for text in your spreadsheet that’s hard to read or to distinguish from the background. To find insufficient color contrast, use the Accessibility Checker. Use sufficient contrast for text and background colors. People who use screen readers sometimes scan a list of links. To determine whether hyperlink text makes sense as standalone information and whether it gives readers accurate information about the destination target, visually scan the workbook. To find all instances of missing alt text, use the Accessibility Checker.Īlt text helps people who can’t see the screen to understand what’s important in images and other visuals.Īdd meaningful hyperlink text and ScreenTips. Screen readers start reading any worksheet from cell A1. Screen readers also use header information to identify rows and columns. Screen readers keep track of their location in a table by counting table cells. Visually scan your tables to check that they don't have any completely blank rows or columns. To ensure that tables don’t contain split cells, merged cells, or nested tables, use the Accessibility Checker. Use a simple table structure for data only, and specify column header information.
Make it easy for everyone to read your spreadsheet. The following table includes key best practices for creating Excel spreadsheets that are accessible to people with disabilities.Īvoid common accessibility issues such as missing alternative text (alt text) and low contrast colors.
Test the accessibility of your worksheetsīest practices for making Excel spreadsheets accessible Best practices for making Excel spreadsheets accessibleĬheck accessibility while you work in ExcelĪdd accessible hyperlink text and ScreenTips
0 kommentar(er)
