Topics

moderated JAWS And Excel


Hicks Steven (CORNWALL IT SERVICES)
 

Hi,

 

My spread sheet has column headers along the top, can someone remind me how to ask JAWS to read these column headers as I navigate around please?

 

Many thanks in anticipation,

 



********************************************************************************************************************

This message may contain confidential information. If you are not the intended recipient please inform the
sender that you have received the message in error before deleting it.
Please do not disclose, copy or distribute information in this e-mail or take any action in relation to its contents. To do so is strictly prohibited and may be unlawful. Thank you for your co-operation.

NHSmail is the secure email and directory service available for all NHS staff in England and Scotland. NHSmail is approved for exchanging patient data and other sensitive information with NHSmail and other accredited email services.

For more information and to find out how you can switch, https://portal.nhs.net/help/joiningnhsmail


John Doering
 

Go to the row with your headers.

Then hit alt, JAWS key, Control, and c at the same time.

 

HTH,

 

 

John Doering
Pricing Analyst

Office: 4147783040 Extn:4063
Mobile:
445 S Curtis Rd West Allis, WI 53214
https://ibvi.org

Industries for the Blind & Visually Impaired accepts no liability for the content of this email, or for the consequences of any actions taken on the basis of the information provided, unless that information is subsequently confirmed in writing. If you are not the intended recipient, you are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited.

From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Hicks Steven (CORNWALL IT SERVICES) via Groups.Io
Sent: Thursday, December 19, 2019 12:36 PM
To: main@jfw.groups.io
Subject: JAWS And Excel

 

Hi,

 

My spread sheet has column headers along the top, can someone remind me how to ask JAWS to read these column headers as I navigate around please?

 

Many thanks in anticipation,

 



********************************************************************************************************************

This message may contain confidential information. If you are not the intended recipient please inform the
sender that you have received the message in error before deleting it.
Please do not disclose, copy or distribute information in this e-mail or take any action in relation to its contents. To do so is strictly prohibited and may be unlawful. Thank you for your co-operation.

NHSmail is the secure email and directory service available for all NHS staff in England and Scotland. NHSmail is approved for exchanging patient data and other sensitive information with NHSmail and other accredited email services.

For more information and to find out how you can switch, https://portal.nhs.net/help/joiningnhsmail


Ann Byrne
 

alternatively:

1. Go to the row with your headers.
2. Press alt+m, then m. JAWS will say "define name, dot dot dot."
3. Press enter to get into the edit field.
4. To have JAWS speak row titles only, type "rowtitle" and press enter.
5. To have JAWS speak column titles only, type "columntitle" and press enter.
6. To have JAWS speak both row and column titles, type "title".

These are Word commands interpreted by JAWS, so if you save the workbook and move it, the titles move too. If you use save-as to create another worksheet, the titles move too. More detailed instructions are available in the JAWS training materials.


John Doering
 

Ann:
Thanks, I will try this sometime.
The key combinations can be difficult sometimes.

Regards,



John Doering
Pricing Analyst
Office: 4147783040 Extn:4063
Mobile:
445 S Curtis Rd West Allis, WI 53214
https://ibvi.org
Industries for the Blind & Visually Impaired accepts no liability for the content of this email, or for the consequences of any actions taken on the basis of the information provided, unless that information is subsequently confirmed in writing. If you are not the intended recipient, you are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited.

-----Original Message-----
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Ann Byrne
Sent: Thursday, December 19, 2019 2:38 PM
To: main@jfw.groups.io
Subject: Re: JAWS And Excel

alternatively:

1. Go to the row with your headers.
2. Press alt+m, then m. JAWS will say "define name, dot dot dot."
3. Press enter to get into the edit field.
4. To have JAWS speak row titles only, type "rowtitle" and press enter.
5. To have JAWS speak column titles only, type "columntitle" and press enter.
6. To have JAWS speak both row and column titles, type "title".

These are Word commands interpreted by JAWS, so if you save the workbook and move it, the titles move too. If you use save-as to create another worksheet, the titles move too. More detailed instructions are available in the JAWS training materials.


Hicks Steven (CORNWALL IT SERVICES)
 

Fantastic, thanks so much for your help.

Is there a way to reverse that setting and turn it off or is it a toggle?

 

 

From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of John Doering
Sent: 19 December 2019 18:41
To: main@jfw.groups.io
Subject: Re: JAWS And Excel

 

Go to the row with your headers.

Then hit alt, JAWS key, Control, and c at the same time.

 

HTH,

 

 

John Doering
Pricing Analyst

Office: 4147783040 Extn:4063
Mobile:
445 S Curtis Rd West Allis, WI 53214
https://ibvi.org

Industries for the Blind & Visually Impaired accepts no liability for the content of this email, or for the consequences of any actions taken on the basis of the information provided, unless that information is subsequently confirmed in writing. If you are not the intended recipient, you are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited.

From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Hicks Steven (CORNWALL IT SERVICES) via Groups.Io
Sent: Thursday, December 19, 2019 12:36 PM
To: main@jfw.groups.io
Subject: JAWS And Excel

 

Hi,

 

My spread sheet has column headers along the top, can someone remind me how to ask JAWS to read these column headers as I navigate around please?

 

Many thanks in anticipation,

 



********************************************************************************************************************

This message may contain confidential information. If you are not the intended recipient please inform the
sender that you have received the message in error before deleting it.
Please do not disclose, copy or distribute information in this e-mail or take any action in relation to its contents. To do so is strictly prohibited and may be unlawful. Thank you for your co-operation.

NHSmail is the secure email and directory service available for all NHS staff in England and Scotland. NHSmail is approved for exchanging patient data and other sensitive information with NHSmail and other accredited email services.

For more information and to find out how you can switch, https://portal.nhs.net/help/joiningnhsmail



********************************************************************************************************************

This message may contain confidential information. If you are not the intended recipient please inform the
sender that you have received the message in error before deleting it.
Please do not disclose, copy or distribute information in this e-mail or take any action in relation to its contents. To do so is strictly prohibited and may be unlawful. Thank you for your co-operation.

NHSmail is the secure email and directory service available for all NHS staff in England and Scotland. NHSmail is approved for exchanging patient data and other sensitive information with NHSmail and other accredited email services.

For more information and to find out how you can switch, https://portal.nhs.net/help/joiningnhsmail


Jim Pursley
 

If you are running JAWS 18 and above you would probably be better served, unless you just want a one time read of your spreadsheet, to use the Excel functionality that JAWS now recognizes.

 Hit control/end to find the bottom right corner of your spreadsheet.  remember this cell address.                                                                                                                                                                                                                                                                 Place the PC cursor at the upper left intersection of your row/column headers.


Hit the applications key and arrow up a few slots to Define Name.


You can specify  different headers for regions on your spreadsheet if you wish by naming the headers titleregion 1..n.   Or you can use any name you wish so long as all names for regions are unique  Mostly, though, you'll find simple spreadsheets with just one region.  If so, type titleregion1..(ending cell address or greater (or your name for the region plus ..and end cell.  and tab to the end and hit OK.


Your headers will be read AND can be saved with your spreadsheet.


The "Excel" way is now the only permanent way to save headers for JAWS-speak.


You can also go to define name by using the name manager in the Formulas menu.  You will need to use the name manager to revise or to delete your named headers.

On 12/19/2019 3:40 PM, John Doering wrote:

Go to the row with your headers.

Then hit alt, JAWS key, Control, and c at the same time.

 

HTH,

 

 

John Doering
Pricing Analyst

Office: 4147783040 Extn:4063
Mobile:
445 S Curtis Rd West Allis, WI 53214
https://ibvi.org

Industries for the Blind & Visually Impaired accepts no liability for the content of this email, or for the consequences of any actions taken on the basis of the information provided, unless that information is subsequently confirmed in writing. If you are not the intended recipient, you are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited.

From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Hicks Steven (CORNWALL IT SERVICES) via Groups.Io
Sent: Thursday, December 19, 2019 12:36 PM
To: main@jfw.groups.io
Subject: JAWS And Excel

 

Hi,

 

My spread sheet has column headers along the top, can someone remind me how to ask JAWS to read these column headers as I navigate around please?

 

Many thanks in anticipation,

 



********************************************************************************************************************

This message may contain confidential information. If you are not the intended recipient please inform the
sender that you have received the message in error before deleting it.
Please do not disclose, copy or distribute information in this e-mail or take any action in relation to its contents. To do so is strictly prohibited and may be unlawful. Thank you for your co-operation.

NHSmail is the secure email and directory service available for all NHS staff in England and Scotland. NHSmail is approved for exchanging patient data and other sensitive information with NHSmail and other accredited email services.

For more information and to find out how you can switch, https://portal.nhs.net/help/joiningnhsmail


 

I have never been able to make these commands work.

-----Original Message-----
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of John Doering
Sent: Thursday, December 19, 2019 12:41 PM
To: main@jfw.groups.io
Cc: doering@...
Subject: Re: JAWS And Excel

Ann:
Thanks, I will try this sometime.
The key combinations can be difficult sometimes.

Regards,



John Doering
Pricing Analyst
Office: 4147783040 Extn:4063
Mobile:
445 S Curtis Rd West Allis, WI 53214
https://ibvi.org
Industries for the Blind & Visually Impaired accepts no liability for the content of this email, or for the consequences of any actions taken on the basis of the information provided, unless that information is subsequently confirmed in writing. If you are not the intended recipient, you are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited.
-----Original Message-----
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Ann Byrne
Sent: Thursday, December 19, 2019 2:38 PM
To: main@jfw.groups.io
Subject: Re: JAWS And Excel

alternatively:

1. Go to the row with your headers.
2. Press alt+m, then m. JAWS will say "define name, dot dot dot."
3. Press enter to get into the edit field.
4. To have JAWS speak row titles only, type "rowtitle" and press enter.
5. To have JAWS speak column titles only, type "columntitle" and press enter.
6. To have JAWS speak both row and column titles, type "title".

These are Word commands interpreted by JAWS, so if you save the workbook and move it, the titles move too. If you use save-as to create another worksheet, the titles move too. More detailed instructions are available in the JAWS training materials.