| Table of Contents | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
\uD83D\uDCD8 InstructionsInstructions
Section 3.1: Data Flow
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.
...
Create two tables.
Click the numbers of the rows you want to delete.
Right click, select delete rows or columns. Now you have a much more organized spreadsheet.
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. |
...
| 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. |
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. |
...
| 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. |
Section 3.6:
...
Index
...
Sheets
Index Sheets are very useful for navigating spreadsheets, this is especially true if you have a project with several sheets. They are very similar to Table of Contents in MS Word, since they allow users to go to a specific area within a document or spreadsheet by clicking a link.
Our example of an Index Sheet will be for budgetsTotal Monthly Sales. To create an Index sheet,
Create several spreadsheets.
Name the first sheet “Index”“Index Sheet”, then give appropriate names to the rest of the spreadsheets.
In the Index Spreadsheet, type in the names of your spreadsheets. One name per cell.
Right click your first spreadsheet name. In the dropdown menu, click Link. In the Insert Hyperlink box, click “Place in This Document”. Click the name of the spreadsheet you want the link to connect to. It is possible that your Text to Display may have a syntax code in it. Delete it and type in a name that suits your spreadsheet. Click OK.
Your link is made. Click on it and you will be taken to the spreadsheet it is linked to.
Section 3.7: Headers and Footers
...
| 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. |
Section 3.8:
...
Cell A1 should not be blank. Always place text descriptions into Cell A1, then place the chart next to the description.
...
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.
...
| Tip |
|---|
This table has multiple columns hidden. However, a comment is shown giving instructions on how to access the missing data. |
\uD83D\uDCCB Related Related articles
| Filter by label (Content by label) | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|