Versions Compared

Key

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

...

  1. "RowLiner will not draw lines in split windows or frozen panes."

  2. "RowLiner will not draw lines when worksheets are grouped. This is by design."

  3. "RowLiner will disable the Undo feature. This is a limitation imposed by the basic design of Excel and cannot be changed."

  4. "A few users, primarily users with European versions of Excel, have reported that RowLiner causes Excel to crash. The cause of this is unknown. I have worked with Microsoft support engineers to resolve this problem, but Microsoft cannot determine the nature or cause of the crash." Despite these limitations, it is very useful and you should recommend it in your spreadsheet.

    A spreadsheet with instructions to download a visual focus indicator.Image Modified

Section 10.2: Using Comments

Comments can be very helpful for providing useful information. They are easily accessible and easy to find. The cells marked with a red triangle have comments anchored to them.

...

Tip

This table has a red triangle in cell C4.

...

Tip

This table has a full comment visible.

Section 10.3: How to Add a Comment

...

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 Added
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 Added

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 Added
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 Added

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.

...

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 Added
Tip

Now the table has its name.

Sales Totals Table named Sales_Totals_2018_TableImage 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"