Video: Create more accessible tables in Excel

Transform data into a table

1. Enter the data that will become part of the table.

2. Select any cell within the data, and then select Insert > Table.

3. Make sure the highlighted cells or range reference is correct.

   

4. Make sure the My table has headers check box is selected, and select OK.

Add a descriptive table name

1. Select anywhere in the table.

2. Under Design > Table Name, replace the generic name with a more meaningful one.

Apply an accessible design

1. Select anywhere in the table, and then go to Design.

2. Select the design features you want, for example, Header Row, Banded Rows, and First Column.

3. To show all available table styles, select More.

   

4. From the Medium styles, select a style with strong contrasting colors.

Increase the font size

1. Select the entire table.

2. Go to Home > Font Size, and select a font size of 12 points or larger.

Increase space between rows

1. Select the entire table.

2. Select Home > Format > Row Height.

3. Increase the row height to, for example, 30 or 40, and then select OK.

Adjust the column width to fit the text

1. Select the entire table.

2. Select Home > Format > AutoFit Column Width.
   The width of the selected columns adjusts to fit the longest text in each column.

Left-align text

1. Select the cells, columns, or rows that you want to align.

2. Select Home > Left .

Want more?

Make your Excel documents accessible for people with disabilities

Download free, pre-built templates

Save a file

Excel training

Word help & learning

PowerPoint training

Tables can help you identify a set of data by name, or apply a more polished format that makes that data stand out.

By carefully naming and formatting your table, you can be sure that everyone—including those with a reading or vision disability—can understand your data.

My data’s already arranged in the rows and columns I want. Now I want to turn it into a table.

I select any cell within my set of data,…

…select Insert, and then Table.

In the highlighted box I can see the cells that will be included.

If I want to adjust the selection, I just drag to redefine the cell range.

I select My table has headers. This is important for accessibility, because screen readers use table headers to navigate.

Now I want to give my table a descriptive name.

I select anywhere in my table, and then select Design

Under Table Name, I replace the generic name with a more descriptive one.

With the descriptive name, I can now quickly jump to the table using the Go To command or the Name Box. I can also easily refer to the table in formulas.

A meaningful name like “EmployeeList” is more helpful than the generic “Table1” or a table reference code like $A$3:$D$16.

VO INSTRUCTION: (Voice as “Dollar A Dollar One Colon Dollar D Dollar Sixteen”.)

Now that I have my table, I want to optimize the design for accessibility.

Certain table formats can be hard on people with reading or vision disabilities,…

…so I want to be sure to choose a format with good contrast and readability.

I select anywhere in my table, and then select the Design tab.

I see that Header Row is already selected. Excel includes headers by default, because they’re so essential for accessibility.

But I also want the customer names in the first column to stand out, so I select First Column.

Next, I select Banded Rows. This makes the separation between rows more visible.

Now I’ll choose a table style that works well for people with low vision or reading disabilities.

There are lots of table styles to choose from.

Lighter colored tables with LOW contrast can be hard for anyone to read, but it’s even harder for people with a reading or vision disability.

On the other hand, styles that alternate between white and a dark color—such as black, dark gray, or dark blue—provide a strong contrast that makes a table more accessible.

To make sure the text INSIDE my table is readable, I can adjust my font, as well as my row and column size.

With the table selected, I select Home, and then Font Size.

I bump the font size from 11 up to 14. I’ll adjust the column width in a minute.

I also want to make sure there’s enough space AROUND my text to keep it from looking crowded. Users with dyslexia can find crowded text especially tough to read.

Under Format, I select Row Height, and increase it to 30. This makes my rows a little taller.

But the text is still too big to fit in my cells. So I select the columns...

Now I select Format again, and then AutoFit Column Width. That’s better…

…but I’ll add a little more white space manually to get the look I want.

Now I can take advantage of this extra space. In the Alignment group, I select Left Align. This adds more space between columns.

We’ll increase the font size and bold the title of our table.

One last thing: Don’t merge or split cells, because that might trip up a screen reader.

That’s it! My new table is done, and ready for EVERY reader.

For more on accessibility, go to aka.ms/OfficeAccessibility