Versions Compared

Key

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

...

Frozen rows and columns should be avoided whenever possible. Making a row or column always visible while scrolling can be accomplished through freezing panes. While this feature can be helpful to sighted users, it should be avoided when creating an accessible workbook as it can cause navigation issues for screen reader users. Users should also be alerted of any frozen rows.

...

Warning

This worksheet only has frozen rows and there is no alert.

A table of the longest flights in the world with multiple rows hidden. There are indicators or warnings that they are hidden.Image Removed

...

Tip

This worksheet shows all rows and columns. This is an accessible table.

The longest flights in the world table with all rows and columns visible.Image Removed

Section 10.5: Using Data Filters

If data filters are used, the user must be alerted in the Excel Document. Data filters can be applied to display information within specific parameters, which can be helpful especially if you ware using lots of data. JAWS announces the data filter drop-down controls, but NVDA cannot do this.

...

Warning

This data filter does not have an alert.

A table of Sales Totals. The Value header has a filter icon.Image Removed

...

Tip

This data filter shows a comment. The comment is explaining why certain cells are hidden.

Sales Total table with a comment for the value header. It says that this cell has a data filter. Only showing values above 70000.Image Removed

Section 10.6: Table Names

The names of Cells in Excel make it easier to understand the purpose of the cell. It also helps with navigating the workbook.

To name your table,

  1. Highlight your full table.

    A table called Sales Totals fully highlighted.Image Added
  2. Go to the Table Design Tab.

    The Table Design tab in Microsoft ExcelImage Added
  3. In the Table Name box, type in the name of your table. Make sure the table name starts with a letter or underscore, does not include a space or character that is not allowed or conflict with an existing name.

    The Table Name box with the name SalesTotals.Image Added

...

Warning

The name of the current cell selected is A2. To make things easier for readers, we should change the name of the cell to the information within the cell.

Sales Totals table with Month and Year header highlighted. The cell name is A2.Image Removed

...

Tip

Now the table has its name.

Sales Totals Table named Sales_Totals_2018_TableImage Removed

Section 10.7: Protecting and Locking

...