Re: Excel 2007 say row and column headers

  • From: "Ann Marie Medlar" <amedlar1@xxxxxxxxx>
  • To: <jfw@xxxxxxxxxxxxx>
  • Date: Wed, 11 Aug 2010 08:27:02 -0400

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

Other related posts: