Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Table of Contents
minLevel1
maxLevel6
outlinefalse
stylenone
typelist
printablefalse

\uD83D\uDCD8 InstructionsInstructions

Section 4.1: Table Formats

...

  1. To create a standard table format, highlight the rows and columns you want formatted into a table.

    A spreadsheet with cells A1 to C4 highlighted
  2. Go to the Insert Tab and click the Table Button.

    Insert button in ExcelTable button in Microsoft Excel
  3. In the Create Table Box, click “My Table has Headers”, then click OK. Your standard table will be created. You can expand it or shrink it as much as you want. Also, you can write out the text in each cell then format it as a table by doing the same steps.

    Create table panel with your table cells entered, and my table has headers is checked.Cells A1 to C4 are now a table.

Rules for Accessible Tables

...

Rule 1: Every

...

table should have a clear title.

...

Warning

This table has no title. Anyone who reads this table will want to know that the table is about. While the data will help give hints, it simply is not enough. Always include a title.

...

Tip

A title is included above the table. All readers will now know what the table and data is about.

Rule 2: There

...

Should Only be

...

One table

...

Per Worksheet

...

Warning

This spreadsheet has two tables. This is unnecessary, and one of these tables has to be moved to another spreadsheet. Seeing two tables would confuse the screen readers in how to give the information to the readers.

...

Tip

Now the tables are on separate spreadsheets and the data is much more organized. Screen readers and readers in general will have a lot less trouble reading the data on the spreadsheets.

Rule 3: If

...

Multiple Tables are

...

Placed in the

...

Same Worksheet, There Should Only be One Row of Separation.

...

Warning

There is no separation between the tables. Screen readers will not have any gap to slow down. If there is no gap or “breathing room”, the reader will be confused on when one table ends or starts.

...

Tip

A space has been added in between the two tables. Though it may look like a small difference, this small change makes a huge impact on people who use screen readers. Now they will know when a table starts and finishes.

Rule 4: All

...

Tables Must Have Headers, and Must Have Meaningful Names

...

Warning

This table has a header, but there are no meaningful names. Column1 does not mean anything and would be unhelpful to people trying to learn the information.

...

Tip

The headers have good labels that tell readers exactly what the content in that row will about.

Rule 5: Each

...

Table Can Only Have One Header Row and/or

...

One Header Column

...

Warning

Due to this table having two different header rows, the screen reader will read the rows off in an asemantic order. A person using a screen reader will struggle to know what data belongs to the individual categories.

...

Tip

This table has only 1 header row. The information is very organized and told in a semantic order.

Rule 6: Complex

...

Tables Must be Broken Down into Simple Tables

...

Warning

This complex table is very complicated to read. It would be very difficult to readers with visual disabilities to know the categories and the data within them.

...

Tip

The same chart has been simplified. Now it is much easier to read and there are no unnecessary headers or data.

Rule 7: Table

...

Headers and the

...

Data Itself Must Not be Separated by Blank Rows or Columns

...

Warning

There is a space between the headers and the data. This is unneeded and does not look very presentable.

...

Tip

There is no space between the headers and the data. This will make reading it much easier and improves the overall look of the table.

Rule 8: No

...

Merged Cells. Instead,

...

Write the

...

Same Data in Multiple Cells.

...

Warning

This table shows the states column having merged cells. This is table would be very difficult for some readers.

...

Tip

This table shows the state names repeated next to their major cities. This is much easier for students to read when using screen readers.

Rule 9: If

...

Conditional Formatting is

...

Used, the

...

Same Information Must be Available to Read in Text Format.

...

Warning

This table uses conditional formatting, by making all of the restaurants with more than 23,000 location glow green. This is not accessible because screen readers will not tell the student the color of the cell.

...

Tip

This table is created separately for restaurants that fulfill the requirement. This is much easier to read and understand.

Filter by label (Content by label)
showLabelsfalse
max5
spacescom.atlassian.confluence.content.render.xhtml.model.resource.identifiers.SpaceResourceIdentifier@82d
sortmodified
showSpacefalse
reversetrue
typepage
labelskb-how-to-article
cqllabel = "kb-how-to-article" and type = "page" and space = "AN"