Hey, Don,
Did you mean to refer to Brian as Brain? I love it!
At 11:02 PM 9/5/2009, you wrote:
Thanks a heap brain, this explanation was so much clearer than the
one I read about a year ago from FS. It works great!
Don Marang
----- Original Message ----- From: "Brian Lee" <[email protected]>
To: <[email protected]>
Sent: Saturday, September 05, 2009 11:07 PM
Subject: Re: [JAWS-Users] JAWS 11 beta not reading Titles in Excel!
Hello Don,
If you use the word "Title" for sheet one then you will need to use
"Title2" for sheet 2, Title3 for sheet 3 etc. The same is true for
using RowTitle and ColumnTitle. Excel doesn't let you use Title1
for sheet 2, instead the number at the end of Title, RowTitle or
ColumnTitle needs to correspond with the sheet it is being used
in. Remember also that there can be no spaces in or after the
words Title RowTitle or ColumnTitle, and of course no quotation
marks as I have shown above.
If you name a range of cells, the name applies to the sheet in
which it is created. If you call b1 through e1 "months" in sheet
1, you can call b1 through e1 of sheet 2 "months 1." So if you
were in sheet 3 and used the GoTo command to go to the range named
"months" you would go to sheet 1 at cell B1, which is the beginning
cell of the named range. If you were in sheet 3 and used GoTo to
move to "Months1" then you would be taken to sheet 2 at the
beginning of the named range. If you wanted to change the range
that applies to "months", you can choose it from the list after
doing CTRL+F3 and then use the edit button. Use tab to where you
can edit the absolute reference and press F2. You can designate
the range to a different sheet or a different absolute referenced
range in that edit box.
You are quite right, CTRL+F3 works in both Excel 2003 and Excel 2007.
Take care.
Brian Lee
[email protected]
----- Original Message ----- From: "Donald Marang" <[email protected]>
To: <[email protected]>
Sent: Saturday, September 05, 2009 12:08 PM
Subject: Re: [JAWS-Users] JAWS 11 beta not reading Titles in Excel!
Hi Brian,
After I rebooted and started JAWS 11 beta again, all of the
spreadsheets where I embedded the "Title" name to a cell now read
the column and row titles. The manual settings still does not
work. It will do what I want and I should not need to manually
set these again.
I have one more question. I have one spreadsheet with 5 sheets
(pages). How would I set a "Title" name separately for each
sheet? I set up the first page as you suggested. It is not
reading the Titles on that sheet and will not allow me to use the
same name on the other sheets. Some of the sheets need different
rows and columns to be spoken. I did notice that the Manage Names
dialog can be brought up with Control + F3.
Don Marang
----- Original Message ----- From: "Brian Lee" <[email protected]>
To: <[email protected]>
Sent: Friday, September 04, 2009 12:49 PM
Subject: Re: [JAWS-Users] JAWS 11 beta not reading Titles in Excel!
Hello Donald,
In Excel 2007 move to the intersection of column and row
titles. Press the application key and down arrow to the "name a
range" choice and press enter. In order to only hear column
titles as you arrow across a row type in "ColumnTitle" (without
the quotes and no spaces between the words. Use mixed case). In
order to hear only row titles as you use the down arrow key type
in RowTitle using mixed case and no spacing. If you want to hear
both row and column titles type in the word Title.
I am not at a system with Excel 2003 or earlier but the choice
should likely be under the insert menu and should have to do with
naming or defining a range.
Take care.
Brian Lee
[email protected]
----- Original Message ----- From: "Donald Marang"
<[email protected]>
To: <[email protected]>
Sent: Friday, September 04, 2009 8:57 AM
Subject: [JAWS-Users] JAWS 11 beta not reading Titles in Excel!
Hi list,
I started playing with the new JAWS 11 beta last night. Since
it is the beginning of the month, I attempted to update a few
spreadsheets. Of course, I needed to set my Title column and row
settings since this is a new installation of
JAWS. Unfortunately, the settings would not be saved and the
titles are never read! After setting to read both column and
row titles and set their cell in the verbosity dialog, JAWS
announces "spreadsheet settings saved". However, the settings
have not been saved and the titles are not read.
Has anyone else noticed this problem? I am following the same
procedure I have used for years, back to JAWS 4.7 I think. Are
there extra steps in JAWS 11?
I know there is a way to embed the title information directly
into the spreadsheet file. This would be handy. Does anyone
know how this is done?
Don Marang
For answers to frequently asked questions about this list visit:
http://www.jaws-users.com/help/
For answers to frequently asked questions about this list visit:
http://www.jaws-users.com/help/
For answers to frequently asked questions about this list visit:
http://www.jaws-users.com/help/
For answers to frequently asked questions about this list visit:
http://www.jaws-users.com/help/
For answers to frequently asked questions about this list visit:
http://www.jaws-users.com/help/
For answers to frequently asked questions about this list visit:
http://www.jaws-users.com/help/
