WebAIM - Web Accessibility In Mind

E-mail List Archives

Re: Help needed in making the Excel files accessible

for

From: Wee, Kim (MNIT)
Date: Sep 27, 2016 7:24AM

1. We need to know three things about our table:
a. Is this the first (or only) table on this worksheet? (table#)
b. What are the addresses of the top left and bottom right cells in the table? (upperleft, lowerright)
c. Is this worksheet the first (or only) worksheet in this workbook? (worksheet#)
Example: TitleRegion#.upperleft.lowerright.worksheet#

2. Put your cursor in the top-left cell in the table. Don't count the table titles, but you do count all row and column headers as part of the table
3. Go to the Formulas tab in the Ribbon, and choose Name Manager in the Defined Names group. Choose New in the top left corner. A new dialog box opens
4. Type TitleRegion then add the (table#), then a period.
5. Next add the range of cells in your table from top left to bottom right, like this - (upperleft) 'period- (lowerright) 'period-
6. Then the worksheet number (worksheet#). Your Title code should look like this:
TitleRegion1.a2.g45.1
7. Select Ok and Close

If you create these titles and then make a simple change, such as moving your worksheet tabs around or adding or deleting rows, you will have to recode the titles to match your spreadsheet. It is best to save this step for when you are ready to publish.

Kim Wee
Webmaster and Accessibility Coordinator | Operations Team

Minnesota IT Services | Minnesota Department of Education
1500 Highway 36 West
Roseville, MN 55113
651-582-8548
Information Technology for Minnesota Government | mn.gov/mnit