These formulas so be sure your table is complete do not update when the table changes, first. This Complex tables will need to be simplified only works for a single level of headers. or restructured. One table per sheet: For sheets with one table only, select the cell in the (not the table upper-left corner of the table title). In select and the dialog opens. In select Windows, Formulas> Define Name New Name Mac, and the dialog opens. Insert> Name> Define Define Name In the field, replace the existing text with depending on Name one of the following 3 values, your table layout: If the table has enter column and row headers, Title If the table has enter row headers only, RowTitle If the table has enter column headers only, ColumnTitle Don't Confuse "Column" and "Row" headers. Remember that is for ColumnTitle vertical headers and is for headers. Also be sure to type or as RowTitle horizontal RowTitle ColumnTitle one word, without a space. After entering the correct value in the field, select Although the initial text is still Name Ok. visible, accessibility information has been added for a screen reader user. Only add a to the first cell in the table. for other header cells Name Do not repeat this step within the same table. Multiple tables per If a single has if the table has or if you want to specify an multiple tables, sortable columns, of a table, you need to use explicit beginning and end TitleRegion. Select the cell in the (not the table title). In select upper-left corner of the table Windows, and the dialog opens. In select Formulas> Define Name New Name Mac, Insert> Name> and the dialog opens. Define Define Name In the field, enter followed by the (no spaces, separated by Name TitleRegion following 4 values periods):
These formulas do not update when the table changes, so be sure your table is complete first. This only works for a single level of headers. Complex tables will need to be simplified or restructured. One table per sheet: For sheets with one table only, select the cell in the upper-left corner of the table (not the table title). In Windows, select Formulas> Define Name and the New Name dialog opens. In Mac, select Insert> Name> Define and the Define Name dialog opens. In the Name field, replace the existing text with one of the following 3 values, depending on your table layout: If the table has column and row headers, enter Title If the table has row headers only, enter RowTitle If the table has column headers only, enter ColumnTitle Don't Confuse "Column" and "Row" headers. Remember that ColumnTitle is for vertical headers and RowTitle is for horizontal headers. Also be sure to type RowTitle or ColumnTitle as one word, without a space. After entering the correct value in the Name field, select Ok. Although the initial text is still visible, accessibility information has been added for a screen reader user. Only add a Name to the first cell in the table. Do not repeat this step for other header cells within the same table. Multiple tables per If a single has multiple tables, if the table has sortable columns, or if you want to specify an explicit beginning and end of a table, you need to use TitleRegion. Select the cell in the upper-left corner of the table (not the table title). In Windows, select Formulas> Define Name and the New Name dialog opens. In Mac, select Insert> Name> Define and the Define Name dialog opens. In the Name field, enter TitleRegion followed by the following 4 values (no spaces, separated by periods):
Creating%20Accessible%20Spreadsheets%20in%20Microsoft%20Excel%202010.docx