[BCAB] JAWS and Excel

David Griffith d.griffith at btinternet.com
Mon Feb 25 17:15:37 GMT 2013

I am not sure if this would work but you could try using the text Analyser
Tool which is supposed to identify changes in formatting and alert you. This
is in jaws 13 and a slightly better version in jaws 14. I cannot remember if
it is in Jaws 12.
Basically what it should do is work through a document and stop at format
change or inconsistency.
I just tried it in an Excel Spreadsheet and although it did not find
anything it simply reported no inconsistencies in document so did appear to
check it.
If it does not work properly in Excel it would definitely work in Word if
you copied and pasted the spreadsheet as a table in Word.
I was checking the formatting of spreadsheets  I had pasted into Word using
this method only yesterday.
You may have to turn Text Analyser on but I normally just hit Windows alt
and I to identify the next inconsistency.

David Griffith

-----Original Message-----
From: Bcab [mailto:bcab-bounces at lists.bcab.org.uk] On Behalf Of Chris Moore
Sent: 25 February 2013 16:47
To: access-uk at freelists.org
Cc: BCAB Discussion List
Subject: [BCAB] JAWS and Excel

Hi JAWS users,

I am using a spreadsheet which contains lots of different coloured rows.
The colours visually indicate the status of a web page being reviewed.

One of the colours is rose, which indicates that the content is no longer
live or has been deleted.  Another colour is yellow which indicates the page
should not be touched.  

The problem I am having is working my way through the spreadsheet.
Currently I have to read the colour attributes of every row by pressing
insert + 5, and this can be quite time consuming, especially when there
could be blocks of yellow or rose (100s of rows of the same colour).

I would like the ability to find the next colour change/skip past all the
rose that have the same colour, until the colour changes to a different
colour.  It would also be useful if JAWS would then read out the row colour
automatically when it jumps to a new colour/no colour.

Is this possible in Excel? I am using JAWS 12 and Excel 2003.

If anyone can come up with a solution, or know of a script that indeed
performs this task, I would be very grateful.



To find out more about BCAB and the benefits that membership can bring,
please visit our website:

To manage your subscription to the BCAB mailing list, please visit our

To discuss matters relating to the mailing list, please email
moderator at bcab.org.uk.

More information about the Bcab mailing list