Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

When creating text for a table, always try to make it easily readable and have good flow. Have the text go left to right and up and down. Each table has sections to keep in account, the title, headings, and data. The title of the table must always be at the top. Underneath the title is where the headings would go. They describe what the data will represent. The data itself will go inside the table in a cell next to or under the headings.

...

Warning

This table has a poor layout with each word in a different cell. A screen reader could read this, but it would be very difficult to navigate from word to word.

...

A spreadsheet with data filling random cells.Image Added
Tip

This table has a good layout with all of the data organized.

An accessible table for college attendance by year and grade level.Image Added

Section 3.2: Naming Worksheets

...

  1. To rename your worksheet, go down to the sheet tabs at the bottom of the screen.

  2. Double click them, and give them a new name.

...

Warning

Sheet 3 does not tell readers anything about what could be in the sheet. Many readers would skip the sheet and not get any possible information.

...

Worksheet names with the third sheet named Sheet 3.Image Added
Warning

These worksheet names tell readers nothing about what the tables could be about.

...

Worksheet names with the third worksheet named Data Table 3Image Added
Tip

While these have short names, Expenses, Income, and Totals explain the purpose of each sheet.

Spreadsheets with new meaningful names. Expenses, Income, and TotalsImage Added

Section 2.3: Deleting Worksheets

...

  1. Create two tables.

    Two tables about the population of countries. The top 5 biggest counties are at the top, the top 5 smallest countries are at the bottom. There are multiple lines of separation between the tables.
  2. Click the numbers of the rows you want to delete.

    Rows 8 and 9 are highlighted.
  3. Right click, select delete rows or columns. Now you have a much more organized spreadsheet.

    Two tables on country population with only one row of separation between them.
  4. For tables that have blanks in them, just type in simple words or abbreviations. Examples of these include, N/A, or “No Data.”

...

Warning

This table leaves the main exports of Japan, Germany, and the Netherlands completely blank. If a screen reader were to read this, it would completely skip the blank cells and confuse the reader.

...

Table of the Countries of the World and their exports. There are blank cells for the main exports of Japan, Germany, and NetherlandsImage Added
Tip

This table shows the main exports of Japan, Germany, and the Netherlands have no data. If an item is unknown, N/A, or there is no data, just say so. The screen reader will read no data and the reader can move on to the next section with ease.

A table of countries and their main exports. No Data is placed in the cell of the nation where data does not exist yet.Image Added

Section 3.5: Using Cell A1

Cell A1 is very important for your projects structure and navigation. Never leave Cell A1 blank. You can use it in multiple ways. Cell A1 can be used as a space for your projects title, or it can be used for providing insight to your project's content. This would be very beneficial for a project with several spreadsheets. Tables, Charts, or Graphs should never be in Cell A1. They should be next to it.

...

Warning

The pie chart is located in Cell A1 without a description or title or any information on the chart.

...

A pie chart of the most popular sports in the USA located in Cell A1.Image Added
Tip

This pie chart is next to Cell A1. Cell A1 has a long description of the pie chart. The screen reader will read the long description and provide the reader the information they need.

A pie chart of the most popular sports in the USA with a long description in Cell A1.Image Added

Section 3.6: Index Sheets

...

When creating a header and footer, they must not have any important information. All important information for the readers must be inside the spreadsheet itself. The best place for important warning on a spreadsheet is in cell A1.

...

Warning

This header includes very important information. Screen readers might not read this to a student which would cause a lot of confusion when the spreadsheet is changed.

...

A header with important information telling the reader that the spreadsheet is a draft.Image Added
Tip

This header does not have anything important inside it. All of the important information is placed in Cell A1. The text will be the first thing the screen reader reads and the reader will be aware the warning.

Spreadsheet with a draft warning in Cell A1.Image Added

Section 3.8: Hidden Rows and Columns

Hidden rows and columns should not be used. Many users struggle to unhide rows and columns. The best way to help all people unhide rows and columns is to use an alert. You can do this by adding a comment to the excel file with instructions.

...

Warning

This table has multiple columns hidden, but there are no instructions telling the reader how to make them visible. This will confuse readers who would want to know why they are hidden and want to know about the data.

...

A table of test scores for five different students. Columns D, E, and F hidden. No warning was given.Image Added
Tip

This table has multiple columns hidden. However, a comment is shown giving instructions on how to access the missing data.

A table of test scores for five different students. Cell A1 has a comment that provides instructions to view the hidden columns.Image Added

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"