Re: Excel 2007 say row and column headers
- From: "Farfar Carlson" <dgcarlson@xxxxxxxxxxxxx>
- To: <jfw@xxxxxxxxxxxxx>
- Date: Wed, 11 Aug 2010 10:02:38 -0700
George,
I'm fascinated, but could not find anything in the JAWS Options menu
(Insert+V) that would set row and title reading to automatic. Can you dig
out what setting you have changed?
It sounds like something that could save a lot of time for me in the future.
Dave
----- Original Message -----
From: "George B" <gbmagoo@xxxxxxxxxxx>
To: <jfw@xxxxxxxxxxxxx>
Sent: Wednesday, August 11, 2010 08:30
Subject: RE: Excel 2007 say row and column headers
Dan,
They now in jaws 11 you can go to verbosity and there is a section for
reading and choices for auto reading collum and row when arrowing through
the sheet. I will look later and see how I set mine up then you do not have
to go through those other steps. It also lets you choose weather the first
cell is empty like in my explanation or if the cell has the first item in
the collum.
I found all of this last spring for someone in the jaws help for excel.
> -----Original Message-----
> From: jfw-bounce@xxxxxxxxxxxxx [mailto:jfw-bounce@xxxxxxxxxxxxx] On
> Behalf Of Farfar Carlson
> Sent: Wednesday, August 11, 2010 07:21
> To: jfw@xxxxxxxxxxxxx
> Subject: Re: Excel 2007 say row and column headers
>
> Ann and Bob,
>
> George's suggestion also didn't work for me with Excel 2007 and JAWS
> 11.0.1461. Don't know where that idea came from. However when
> spreadsheets
> are not being shared, I don't bother naming a range, I simply highlight
> (for
> this example under discussion) cell A1 to represent the column and row
> where
> the titles are to be read. Then press Alt+Ctrl+R and Alt+Ctrl+C to mark
> row
> and column.
>
> Done.
>
> Dave
>
> ----- Original Message -----
> From: "Bob Verity" <rtverity@xxxxxxxxxxxxx>
> To: <jfw@xxxxxxxxxxxxx>
> Sent: Wednesday, August 11, 2010 07:01
> Subject: Re: Excel 2007 say row and column headers
>
>
> Ann,
>
> Knowing you and that you are creating spreadsheets for your own use and
> not
> for distribution to others, this is what I use and will work for you.
>
> 1. Highlight the row(s) and column(s) that contain the headings you
> want
> spoken.
>
> 2. Create a name in this form:
> TitleRegionX.UL.LR.Sheet#
> Where: UL is the cell addres of the upper left and LR is thecell
> address
> of the lower right corner of the area and Sheet# is the number of the
> spreadsheet in the workbook.
> X in TitleRegionX is a unique number for the region you are defining.
> Note the capitals of T & R and the other parameters are separated by
> periods.
>
> I followed George's example using Excel 2007 and JFW 11 and it did not
> work.
>
> I will call you later.
>
> best.
>
> ----- Original Message -----
> From: "Ann Marie Medlar" <amedlar1@xxxxxxxxx>
> To: <jfw@xxxxxxxxxxxxx>
> Sent: Wednesday, August 11, 2010 7:27 AM
> Subject: Re: Excel 2007 say row and column headers
>
>
> George,
> I copied from my spreadsheet a1:e5 and pasted to another spreadsheet.
> I left A1 blank but when I went down to data on a3:e3 column titles
> were not
> read when I pressed the right or left arrow keys.
> I then tried to shift A1 left by using the application key but shift
> left
> was not available as follows
> Insert
> Insert
> Shift cells right
> Shift cells down
> Entire row
> Entire column
> OK Cancel
> So unsure how to accomplish this but it would be much easier as I get
> better
> with Excel 2007. What am I missing. Need to go out all morning but
> look
> forward to your help.
> Ann
>
> ----- Original Message -----
> From: "George B" <gbmagoo@xxxxxxxxxxx>
> To: <jfw@xxxxxxxxxxxxx>
> Sent: Tuesday, August 10, 2010 9:18 PM
> Subject: RE: Excel 2007 say row and column headers
>
>
> > With jaws 11 and excel 2007 all you need is a black cell in the upper
> left
> > corner of the area you wish to have the collums and rows red.
> >
> > Example
> > You have jan, feb, mar, apr, may, june as the collum titles in the
> first
> > row
> > and these all start on a1 and go through a6
> > Then you have going down the first collum under jan in the following
> rows,
> > 1
> > 2 3 4 5 6
> >
> > Now if you go in that area with the arrow keys you will hear the 1 2
> 3 4 5
> > 6
> > red as you arrow down the collums for each month, but you will not
> hear
> > any
> > months red when you arrow across a row for a date you are on. This
> is
> > because you do not have a blank cell in the upper left corner.
> >
> > In this example you would need to add a cell to the left of a1 which
> will
> > push all the months over to the right one cell and then a1 will be
> blank
> >
> > Then arrow through the example and you will hear jan feb as you go
> across
> > and 1 2 3 as yougo down.
> >
> > You were correct in 2003 and earlier jaws but if you have I think
> jaws 10
> > or
> > later and you structure the area of the spreadsheet in the mannor
> above
> > jaws
> > now automatically does those steps for you.
> >
> > Hth and if you have any questions just ask
> >
> >> -----Original Message-----
> >> From: jfw-bounce@xxxxxxxxxxxxx [mailto:jfw-bounce@xxxxxxxxxxxxx] On
> >> Behalf Of Ann Marie Medlar
> >> Sent: Tuesday, August 10, 2010 17:29
> >> To: jfw@xxxxxxxxxxxxx
> >> Subject: Re: Excel 2007 say row and column headers
> >>
> >>
> >> In Excel 2003 I could do the following to say headr columns
> regardless
> >> of
> >> speech software:
> >> > 1. Select the rows and columns that contain the headings
> >> > 2. press alt I for the insert menu
> >> > 3. press the letter N for names
> >> > 4. press the letter D to insert Defined names
> >> > 5. enter this:
> >> > TitleRegion1.A1.M25.3
> >> How do i do this in Excel 2007?
> >>
> >> --
> >> JFW related links:
> >> JFW homepage: http://www.freedomscientific.com/
> >> Scripting mailing list: http://lists.the-
> >> jdh.com/listinfo.cgi/scriptography-the-jdh.com
> >> JFW List instructions:
> >> To post a message to the list, send it to jfw@xxxxxxxxxxxxx
> >> To unsubscribe from this mailing list, send a message to jfw-
> >> request@xxxxxxxxxxxxx with the word unsubscribe in the subject line.
> >> Archives located at: //www.freelists.org/archives/jfw
> >> Alternative archives located at: http://n2.nabble.com/JAWS-for-
> Windows-
> >> f2145279.html
> >>
> >> If you have any concerns about the list, post received from the
> list,
> >> or the way the list is being run, do not post them to the list.
> Rather
> >> contact the list owner at jfw-admins@xxxxxxxxxxxxxx
> >
> > --
> > JFW related links:
> > JFW homepage: http://www.freedomscientific.com/
> > Scripting mailing list:
> > http://lists.the-jdh.com/listinfo.cgi/scriptography-the-jdh.com
> > JFW List instructions:
> > To post a message to the list, send it to jfw@xxxxxxxxxxxxx
> > To unsubscribe from this mailing list, send a message to
> > jfw-request@xxxxxxxxxxxxx with the word unsubscribe in the subject
> line.
> > Archives located at: //www.freelists.org/archives/jfw
> > Alternative archives located at:
> > http://n2.nabble.com/JAWS-for-Windows-f2145279.html
> >
> > If you have any concerns about the list, post received from the list,
> or
> > the way the list is being run, do not post them to the list. Rather
> > contact the list owner at jfw-admins@xxxxxxxxxxxxxx
> >
>
> --
> JFW related links:
> JFW homepage: http://www.freedomscientific.com/
> Scripting mailing list:
> http://lists.the-jdh.com/listinfo.cgi/scriptography-the-jdh.com
> JFW List instructions:
> To post a message to the list, send it to jfw@xxxxxxxxxxxxx
> To unsubscribe from this mailing list, send a message to
> jfw-request@xxxxxxxxxxxxx with the word unsubscribe in the subject
> line.
> Archives located at: //www.freelists.org/archives/jfw
> Alternative archives located at:
> http://n2.nabble.com/JAWS-for-Windows-f2145279.html
>
> If you have any concerns about the list, post received from the list,
> or the
> way the list is being run, do not post them to the list. Rather contact
> the
> list owner at jfw-admins@xxxxxxxxxxxxxx
>
> --
> JFW related links:
> JFW homepage: http://www.freedomscientific.com/
> Scripting mailing list:
> http://lists.the-jdh.com/listinfo.cgi/scriptography-the-jdh.com
> JFW List instructions:
> To post a message to the list, send it to jfw@xxxxxxxxxxxxx
> To unsubscribe from this mailing list, send a message to
> jfw-request@xxxxxxxxxxxxx with the word unsubscribe in the subject
> line.
> Archives located at: //www.freelists.org/archives/jfw
> Alternative archives located at:
> http://n2.nabble.com/JAWS-for-Windows-f2145279.html
>
> If you have any concerns about the list, post received from the list,
> or the
> way the list is being run, do not post them to the list. Rather contact
> the
> list owner at jfw-admins@xxxxxxxxxxxxxx
>
> --
> JFW related links:
> JFW homepage: http://www.freedomscientific.com/
> Scripting mailing list: http://lists.the-
> jdh.com/listinfo.cgi/scriptography-the-jdh.com
> JFW List instructions:
> To post a message to the list, send it to jfw@xxxxxxxxxxxxx
> To unsubscribe from this mailing list, send a message to jfw-
> request@xxxxxxxxxxxxx with the word unsubscribe in the subject line.
> Archives located at: //www.freelists.org/archives/jfw
> Alternative archives located at: http://n2.nabble.com/JAWS-for-Windows-
> f2145279.html
>
> If you have any concerns about the list, post received from the list,
> or the way the list is being run, do not post them to the list. Rather
> contact the list owner at jfw-admins@xxxxxxxxxxxxxx
--
JFW related links:
JFW homepage: http://www.freedomscientific.com/
Scripting mailing list:
http://lists.the-jdh.com/listinfo.cgi/scriptography-the-jdh.com
JFW List instructions:
To post a message to the list, send it to jfw@xxxxxxxxxxxxx
To unsubscribe from this mailing list, send a message to
jfw-request@xxxxxxxxxxxxx with the word unsubscribe in the subject line.
Archives located at: //www.freelists.org/archives/jfw
Alternative archives located at:
http://n2.nabble.com/JAWS-for-Windows-f2145279.html
If you have any concerns about the list, post received from the list, or the
way the list is being run, do not post them to the list. Rather contact the
list owner at jfw-admins@xxxxxxxxxxxxxx
--
JFW related links:
JFW homepage: http://www.freedomscientific.com/
Scripting mailing list:
http://lists.the-jdh.com/listinfo.cgi/scriptography-the-jdh.com
JFW List instructions:
To post a message to the list, send it to jfw@xxxxxxxxxxxxx
To unsubscribe from this mailing list, send a message to
jfw-request@xxxxxxxxxxxxx with the word unsubscribe in the subject line.
Archives located at: //www.freelists.org/archives/jfw
Alternative archives located at:
http://n2.nabble.com/JAWS-for-Windows-f2145279.html
If you have any concerns about the list, post received from the list, or the
way the list is being run, do not post them to the list. Rather contact the
list owner at jfw-admins@xxxxxxxxxxxxxx
Other related posts:
