...
"RowLiner will not draw lines in split windows or frozen panes."
"RowLiner will not draw lines when worksheets are grouped. This is by design."
"RowLiner will disable the Undo feature. This is a limitation imposed by the basic design of Excel and cannot be changed."
"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.
Section 10.2: Using Comments
...
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.  |
...
| Tip |
|---|
This worksheet shows all rows and columns. This is an accessible table.  |
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.  |
...
| Tip |
|---|
This data filter shows a comment. The comment is explaining why certain cells are hidden.  |
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,
Highlight your full table.
Go to the Table Design Tab.
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.
...
| 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.  |
...
| Tip |
|---|
Now the table has its name. |
Section 10.7: Protecting and Locking
You can protect your spreadsheet in three different levels:
File Level: A security feature that involves setting a password to restrict access to an Excel file, preventing others from opening or modifying it. It’s important to remember that Microsoft cannot recover passwords if they are lost or forgotten.
Workbook Level: Safeguards the structure of a workbook by restricting actions like adding, moving, deleting, hiding, or renaming worksheets.
Worksheet Level: Helps maintain data integrity by controlling how users interact with a worksheet. For instance, it ensures that critical formulas are not accidentally altered or deleted due to unintentional actions.
To protect your sheet or workbook,
Go to the Review Tab.
In the Protect section, click Protect Sheet or Protect Workbook.
If you want to protect your worksheet, the option for selecting locked and unlocked cells needs to be checked. The effects of doing this are the same for sighted and screen reader users. Both groups will be able to do or not do the same things based on what is protected and locked. The only exception is that if you protect a worksheet and do not allow a user to select locked or unlocked cells, screen readers cannot access those cells. Fortunately, the option is checked by default so try to avoid checking it by accident.
...
Section 10.8: NVDA Keyboard Navigation Shortcuts
Here are some keyboard shortcuts for NVDA and what they do.
NVDA + T: Read the file title
NVDA + End: Read the status bar
NVDA + Tab: Read the item with focus
NVDA + Up Arrow: Read the contents of the current cell again
NVDA + Shift + Up Arrow: Read the currently selected text
NVDA + C: Read the contents of the clipboard
NVDA + Shift + C: Set current row as header row
NVDA + Shift + C (twice quickly): Clear set current row as header row
NVDA + Shift + R: Set current column as header column
NVDA + Shift + R (twice quickly): Clear set current column as header column
NVDA + Delete (laptop): Report review cursor location
NVDA + Shift + Up Arrow (laptop): Read worksheet name
NVDA + F7: Open elements list
NVDA + Control + D: Open document formatting dialog
NVDA + Alt + C: Read a comment
Related articles
| Filter by label (Content by label) | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|