moderated excel - defining names
David Kingsbury
Hi again,
In that same edit box, you type rowtitle (one word, no spaces) if you only want to hear row titles. Type in columntitle (again, no spaces) if you only want to hear the column titles. If you ever get it messed up, hit Control F3 to bring you into the name manager where you can delete them and start over.
David
|
|
mike mcglashon
Mr. David:
Question for you regarding your “title” instructions: Block quote: 3. Type title in the edit box and press enter. Now you will hear column titles (the months) as you left and right arrow through the table, and row titles (the types of bills) as you up and down arrow. End block quote: What do I do differently in order to get only the row or the column titles to read, Instead of both? ;
Please advise as you like.
Mike M.
Mike mcglashon Email: Michael.mcglashon@... Ph: 618 783 9331
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of David Kingsbury
Sent: Friday, June 12, 2020 1:00 PM To: main@jfw.groups.io Subject: Re: excel - defining names
Hi,
This is much simpler to do using the Define Names command in Excel, rather than JAWS. 1. Go to the cell that is the intersection of the column and row titles you want read to you when navigating inside the table. For example, if you list bill items you want to pay down column A, and months you will be paying across row 2, start in cell A2. 2. Pres the applications key, up arrow ttwice to Define Names and press Enter. 3. Type title in the edit box and press enter.
Now you will hear column titles (the months) as you left and right arrow through the table, and row titles (the types of bills) as you up and down arrow.
David
|
|
David Kingsbury
Hi,
This is much simpler to do using the Define Names command in Excel, rather than JAWS. 1. Go to the cell that is the intersection of the column and row titles you want read to you when navigating inside the table. For example, if you list bill items you want to pay down column A, and months you will be paying across row 2, start in cell A2. 2. Pres the applications key, up arrow ttwice to Define Names and press Enter. 3. Type title in the edit box and press enter.
Now you will hear column titles (the months) as you left and right arrow through the table, and row titles (the types of bills) as you up and down arrow.
David
|
|
Joe
Hello, You almost got everything right but the syntax.
This was the method that Dan Clark suggested from Vispero. Picture of Owl with Mortar Board and Computer Dr. Joe L. Todd CVRT Phone: 616.951.2142
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Juan Hernandez
Sent: Thursday, June 11, 2020 6:01 PM To: main@jfw.groups.io Subject: excel - defining names
HI All,
I am trying to make my excel spreadsheet read the column names and row names when using the jaws+alt+shift+r or C commands that jaws provides.
So I did the following:
First I went to column a1, where it says product name Then I hit alt+m, m, d which loads the define names dialog box and typed product name. I then pressed ok, and when I go down the colllumn and hit jaws+alt+shift+c it says no column name
Can someone please advise me as to what I’m doing wrong?
Best,
juan
|
|
Juan Hernandez
HI All,
I am trying to make my excel spreadsheet read the column names and row names when using the jaws+alt+shift+r or C commands that jaws provides.
So I did the following:
First I went to column a1, where it says product name Then I hit alt+m, m, d which loads the define names dialog box and typed product name. I then pressed ok, and when I go down the colllumn and hit jaws+alt+shift+c it says no column name
Can someone please advise me as to what I’m doing wrong?
Best,
juan
|
|