SLNC logo
SPECIAL LEARNING NEEDS CONSULTANT
...Making learning and technology easy, accessible, affordable and available for everyone


ARTICLE PAGE

OPTIMIZING JAWS AND NVDA FOR ENHANCE EXCEL PERFORMANCE


Written by Olufemi S.A. Bayode on 25 July 2024 @ 11:59:55 with comments

Excel

Configuring your screen reader before using Microsoft Office Excel is crucial to unlock its full potential. As a JAWS or NVDA user, taking the time to set up your screen reader will significantly enhance your Excel experience. This includes adjusting settings for text visibility, cell coordinate announcement, and utilizing screen reader features for column and row headers indication. By doing so, you'll be able to navigate Excel with greater ease and efficiency, making the most out of this powerful software.


Configuring JAWS for Text Visibility

Configuring JAWS for text visibility is a crucial step in optimizing your Excel experience. When navigating an Excel worksheet, it's essential to detect hidden data in cells, which can be easily overlooked if your JAWS is not configured correctly. Hidden data can include text or numbers, that are not visible due to the cell size. By enabling JAWS to announce obscured data, you'll be able to identify and work on this hidden information, ensuring error-free output, accuracy and completeness in your worksheets.


  1. Press JAWS KEY+V to access the JAWS verbosity settings. This will open a new window with various options to customize your JAWS experience.
  2. Navigate to the "Cell text visibility detection" checkbox using the DOWN ARROW key or first letter navigation. This option allows JAWS to detect and announce hidden text in cells.
  3. Check the checkbox with the SPACE BAR key and press ENTER to close the verbosity settings. This will save your changes and enable text visibility detection.

You may also watch the video demonstration of enabling cell visibility with the JAWS screen reader here.

Configuring NVDA for Rows and Columns Header Announcement

NVDA's default settings may not provide the level of feedback you need to navigate Excel worksheets efficiently. Rows and columns headers, including cell coordinates are essential components of Excel worksheets, providing context and structure to your data. However, NVDA 2019.2 and later versions don't announce cell coordinates and these headers by default, which can make it challenging to understand the position of a data and layout of your worksheets. By configuring NVDA to announce cell coordinates, rows and columns headers, you'll be able to navigate and understand your worksheets more easily, even when dealing with complex data sets.


  1. Press CONTROL+NVDA KEY+D to access the "Document formatting" settings. This will open a new window with options to customize NVDA's behavior.
  2. Navigate to the "Rows/column header" checkbox using the TAB key and check it with the SPACE BAR. This will enable NVDA to announce rows and columns headers.
  3. Navigate to the "Cell coordinate" checkbox using the TAB key and check it also with the SPACE BAR. This will enable NVDA to announce cell coordinates, making it easier to navigate worksheets.
  4. Press ENTER to activate and close the dialogue box. This will save your changes and enable rows and columns header announcement.

Utilizing Screen Reader Features for Column and Row Headers

Screen readers like JAWS and NVDA offer powerful features to help you navigate and understand Excel worksheets. While sighted individuals rely on visual cues like freeze panes to keep column or row headers visible, screen reader users can leverage specific features to achieve similar results. By setting specific cells as column or row headers, you'll be able to identify your position within the worksheet and navigate with greater ease, even when dealing with large datasets or complex worksheet layouts. To set column or row headers using JAWS or NVDA:


  • Move to any of the cells serving as the title of the data in that column using your keyboard navigation keys.
  • Press CONTROL+JAWS KEY+ALT+C (JAWS) or NVDA KEY+SHIFT+C (NVDA) to set the column header announcement. This will enable your screen reader to announce the column header for the columns in the worksheet.
  • Locate any of the cells that holds data representing header of the data in the row.
  • Use CONTROL+JAWS KEY+ALT+R (JAWS) or NVDA KEY+SHIFT+R (NVDA) to set the row header announcement. This will enable your screen reader to announce the row header for the each of the rows in the worksheet.

"In conclusion, optimizing your screen reader settings for Excel can significantly enhance your productivity and efficiency. By following the steps outlined in this article, you'll be able to navigate Excel with greater ease and confidence. If you found this article helpful, please share it with your network on social media platforms like Twitter, Facebook, and LinkedIn. Don't forget to like and comment on this post to let us know how you're using these tips to improve your Excel experience.

For more in-depth guidance on mastering Excel, check out our comprehensive textbook, WORK IT OUT. This valuable resource is designed to help you unlock the full potential of Excel and streamline your workflow. With clear instructions and practical examples, WORK IT OUT is the perfect companion to this article and will take your Excel skills to the next level. Thanks for reading, and happy Excel-ing!


Time Uploaded: 25 July 2024 @ 11:59:55

Author: Olufemi S.A. Bayode