RE: Excel 2007 say row and column headers

  • From: "George B" <gbmagoo@xxxxxxxxxxx>
  • To: <jfw@xxxxxxxxxxxxx>
  • Date: Wed, 11 Aug 2010 10:17:04 -0700

Dan,

In a spreadsheet I did the following and it does not matter if the top left
cell is empty or not.

Insert v
Arrow to   Title reading open
Arrow down once and change to all files
Arrow down once and I made it for single sheet
Arrow down once again amd I made it for both collums and rows.

That was it
hth

> -----Original Message-----
> From: jfw-bounce@xxxxxxxxxxxxx [mailto:jfw-bounce@xxxxxxxxxxxxx] On
> Behalf Of Farfar Carlson
> Sent: Wednesday, August 11, 2010 10:03
> To: jfw@xxxxxxxxxxxxx
> Subject: Re: Excel 2007 say row and column headers
> 
> 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

--
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: