Re: Setting up Rows and Columns to be read by JFW
- From: "Bob Verity" <rtverity@xxxxxxxxxxxxx>
- To: <jfw@xxxxxxxxxxxxx>
- Date: Fri, 7 May 2010 16:45:48 -0500
Yes Dave, I have used the summary feature from time to time but in most of my
uses of Excel it isn't particularly useful.
I understand if you are having workbooks sent to you it would be a bit
impractical to use the method I described. So we all have to do what we have
to do to get the job done.
----- Original Message -----
From: Dave Carlson
To: jfw@xxxxxxxxxxxxx
Sent: Friday, May 07, 2010 4:12 PM
Subject: Re: Setting up Rows and Columns to be read by JFW
Bob,
Yes, true enough. However in my job, I received spreadsheets pushed out to a
large number of sales engineers, and each time it arrives it's not going to
have that nice feature included. So I have to use the old method of either
using a JSI file previously created, or assign the titles on-the-fly.
I agree that the use of Names is much more elegant and transportable. I also
like the summary feature in Excel. Have you used that?
Dave
From: Bob Verity
To: jfw@xxxxxxxxxxxxx
Sent: Friday, May 07, 2010 14:02
Subject: Re: Setting up Rows and Columns to be read by JFW
An advantage of setting up the row and column title reading as I described
is that if you send the workbook to someone else the title reading is already
set up and they have to do nothing.
----- Original Message -----
From: Bob Verity
To: jfw@xxxxxxxxxxxxx
Sent: Friday, May 07, 2010 3:23 PM
Subject: Re: Setting up Rows and Columns to be read by JFW
Using the JAWS verbosity menu is not the prefered way to have row and
column titles spoken. You can find a detailed explaination of the better way
to do this in the JAWS help for Excel.
Here is how it should be done.
In the Excel INSERT menu choose name and then define and enter this with
your cursor in cell A6:
Title.a6.W17.X
Where X is the number of the worksheet in the work book.
There are other options when there are multiple regions on a worksheet.
In the above example note the capital in Title.
HTH
----- Original Message -----
From: Lafond, Eileen
To: jfw@xxxxxxxxxxxxx
Sent: Friday, May 07, 2010 12:16 PM
Subject: RE: Setting up Rows and Columns to be read by JFW
That was the first thing that I tried and it said that these were
already defined, yet it was not working. I tried to manually do it again to
get it started and that did not work. Is there a command or something to make
it do what is already defined?
Thanks,
Eileen La fond
From: jfw-bounce@xxxxxxxxxxxxx [mailto:jfw-bounce@xxxxxxxxxxxxx] On
Behalf Of Lisle, Ted (CHFS DMS)
Sent: Friday, May 07, 2010 9:59 AM
To: jfw@xxxxxxxxxxxxx
Cc: gbmagoo@xxxxxxxxxxx
Subject: RE: Setting up Rows and Columns to be read by JFW
If you mean what I think you mean, you set using the first row and the
first column. Hitting the spacebar will either define a value, or supersede
what is already there. The headings are row values to column range, and column
values to row range.
Ted
From: jfw-bounce@xxxxxxxxxxxxx [mailto:jfw-bounce@xxxxxxxxxxxxx] On
Behalf Of Lafond, Eileen
Sent: Friday, May 07, 2010 12:52 PM
To: jfw@xxxxxxxxxxxxx
Cc: gbmagoo@xxxxxxxxxxx
Subject: Setting up Rows and Columns to be read by JFW
Hi,
I had a computer crash at work and I am trying to get everything set
back up. The problem that I have right now is setting the rows and columns for
my timesheet to be read as I go across and down the spreadsheet entering my
hours.
In the past, I went into the insert v window and went to Title
Reading and set it according to what I thought was correct for reading the
columns from A6 to W6. For the rows I wanted the A6 through A17 to be read as
I went across and filled in the hours.
I have been able to get this to work in the past, but now I have
gotten myself very confused and it seems that everything that I try does not
work.
Can someone tell me the exact items that I need to change to achieve
the above settings?
I am using JFW version 11 and Excel version 2003.
Thanks for any help,
Eileen La Fond
Work phone: (206 386-0011
email: eileen.lafond@xxxxxxxxxxx
Other related posts:
