[AI] Excel Help

Vicky Singh ask.champs at gmail.com
Fri May 28 01:24:03 EDT 2010


Hey,

recently there was an email query regarding reading column heading in
MS Excel. The query was regarding some JAWS settings. I am unable to
answer the query but can provide a solution for reading column
headings.

This is an extract from Stafee bleaks website :

Alt 1 through 4.
This keystroke will read cells located in the 1st, 2nd, 3rd, and 4th
rows of the current column. this is useful if you want to glance up
and see what is in those cells (usually titles).
Alt Ctrl, 1 through 4.
These keystrokes will read the cells in the first 4 columns of the current row.
Alt, Ctrl, Shift, C.
Set column titles to row range.
Move to the row within the table where the column titles are located
and use the above keystroke command.
This will set the column title association to each cell within the
table and will allow JAWS to automatically speak the title of the cell
while you navigate the table.
This will, of course, offer valuable contextual reference to each cell
especially with larger, more complex tables.
Note: Yes, this keystroke consists of 4 keys. Hold down the Alt, Ctrl
and Shift keys and tap the letter C.
Note: You will want to use this keystroke when you encounter a table
where the title row is located below the 4th row.
Alt, Ctrl, Shift, R.
Set row titles to column range.
Move to the column within the table where the row titles are located
and use the above keystroke command.
This will set the row title association to each cell within the table
and will allow JAWS to speak the title of the cell while you navigate
the table.
This will, of course, offer valuable contextual reference to each cell.
Note: A very useful trick is to move to the cell that intercects both
the row and column titles and then perform both the Ctrl Alt Shift R,
and Ctrl Alt Shift C keystrokes.
This will allow JAWS to speak the row and column titles as you
navigate through the table.

Hope that helps

Regards,

VS




More information about the AccessIndia mailing list