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
brianl...@charter.net
----- Original Message -----
From: "Donald Marang" <donald.mar...@gmail.com>
To: <jaws-users-list@jaws-users.com>
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" <brianl...@charter.net>
To: <jaws-users-list@jaws-users.com>
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
brianl...@charter.net
----- Original Message -----
From: "Donald Marang" <donald.mar...@gmail.com>
To: <jaws-users-list@jaws-users.com>
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/
