Re: Reading Column titles in excel 2003

The following was taken from the JFW help for Excel.

This is the prefered method of defining row and column headings.  It works 
very well.



Excel Row and Column Title Reading
Defining Row and Column Titles
you can use Excel's naming function to specify which rows and columns 
contain cell titles. Using names instead of JAWS commands makes the 
spreadsheet accessible to any user of JAWS. There is no need to provide 
other users with the spreadsheet's .jsi file because the row and column 
title information is saved in the worksheet. This feature allows any 
spreadsheet author to define row and column titles without installing or 
using JAWS.

To use names to define row and column titles, do the following:

  1.. Move to the first cell in the column or row containing the titles. If 
the spreadsheet contains both row and column titles, move to the cell where 
these two intersect.
  2.. From the Insert menu, select Name and press RIGHT ARROW.
  3.. Select Define and press ENTER.
  4.. If the column contains row titles, type "RowTitle" and press ENTER. If 
the row contains column titles, type "ColumnTitle" and press ENTER. If the 
cell is the intersection of both row and column titles, type "Title" and 
press ENTER.

  If you are defining column/row titles for any worksheet other than 
worksheet 1, you must add the number of the worksheet after "RowTitle," 
"ColumnTitle," or "Title." For example, if you are defining a row containing 
column titles in worksheet 4, you would type "ColumnTitle4." To hear which 
worksheet you are in, press INSERT+F1.
Tip: You can define more than one row or column as a title range. For 
example, if you want to define rows 1 and 2 as column titles, select both 
rows and then assign the name "ColumnTitle" to them.

JAWS can now recognize the cell as the beginning of a range of row and/or 
column titles. If a particular worksheet within a workbook has title rows 
and/or columns defined using this feature, you cannot use the standard JAWS 
method for defining title rows and/or columns. However, if another worksheet 
in the same workbook does not have row and column titles defined using the 
Excel naming function, you can use the standard JAWS method.

Overriding Named Titles
Any JAWS user can override row and column title information provided by the 
spreadsheet author. To do this, press INSERT+V while you are in Excel to 
open the Adjust JAWS Options dialog box. Select "Define Name Column and Row 
Titles Override" and use the SPACEBAR to cycle through the available 
options. Choose "On for the current file" to override named titles only in 
the currently open spreadsheet. Choose "On for all files" to override named 
titles in all spreadsheets that you open in Excel. If you want to use the 
row and column title information provided by the author again, choose "Off."

Defining Row and Column Titles for Worksheets with Multiple Regions
You can define individual row and/or column titles for different regions in 
the same workbook. To define a row and/or column title for region, you use 
the same procedure described in Defining Row and Column Titles to assign a 
specific name to a cell in the heading row and/or column. However, you must 
use the following procedure when defining names for row and column titles 
that are specific to one region:

  1.. Type "TitleRegion," "RowTitleRegion," or "ColumnTitleRegion" depending 
on whether this cell is in the heading row, heading column, or both.
  2.. Type the region number. For example, you would type a "1" if the cells 
were in the first region. There should be no space between the previous text 
and this number.
  3.. Type a period followed by the coordinates of the top, left cell in the 
region (for example, "A1").
  4.. Type a period followed by the coordinates of the bottom, right cell in 
the region (for example, "N9").
  5.. Type a period followed by the worksheet number. For example, you would 
type a "1" if the cell was in worksheet 1.
For example, assume you have a spreadsheet with a region whose boundaries 
are row 1 at column A and row 9 at column N. It also has a second region 
with boundaries of row 10 at column C and row 14 at column D. Both regions 
are on worksheet 1. To define row 1 as the row containing column headers for 
the cells in the first region, you would assign the following name to cell 
A1: ColumnTitleRegion1.A1.N9.1. To define row 9 as the row containing column 
headers for the cells in the second region, you would assign the following 
name to cell C10: ColumnTitleRegion2.C10.D14.1.

Changing Title Reading Options
You can change how JAWS reads row and column titles you have defined in the 
Excel options. Press INSERT+V, and then press T to move to the "Title 
Reading Detection" option in the Title Reading group. Next, press the 
SPACEBAR to choose one of the following:

  a.. Off - JAWS does not announce row or column titles.
  b.. Read Row Titles - When you move to a different row, JAWS reads the row 
title. JAWS does not announce column titles.
  c.. Read Column Titles - When you move to a different column, JAWS reads 
the column title. JAWS does not announce row titles.
  d.. Read Both Titles - When you move to a different column, JAWS reads the 
column title. When you move to a different row, JAWS reads the row title.
Reading Columns and Rows Containing Totals
You can indicate which columns and/or rows contain the total of values in 
other cells. If the spreadsheet calculates column totals, move to the row 
containing these totals and press CTRL+INSERT+DELETE. If the spreadsheet 
calculates row totals, move to the column containing these totals and press 
CTRL+INSERT+ENTER.

Tip: You can also press INSERT+V to use the Adjust JAWS Options dialog box 
to specify which row and column contains totals.

After you have defined the row that contains column totals, you can press 
INSERT+DELETE to hear the total for the current column. Similarly, after you 
have defined the column that contains row totals, you can press INSERT+ENTER 
to hear the total for the current row.

JAWS only reads the value displayed in the totals row/column and does not 
automatically perform the necessary calculations. You must use Excel to 
insert a formula that will calculate the total of a given range of cells. 
For more information on using formulas, refer to Miscellaneous Excel Hints.

Reading Visible Rows and Columns of a Spreadsheet
JAWS provides keystrokes to read only the portion of the spreadsheet that is 
visible on the screen. If Title reading is enabled, pressing these 
keystrokes reads the appropriate title cells followed by the visible cells' 
contents.

      Description
     Keystroke

      Read visible row
     INSERT+UP ARROW

      Read visible row to current cell
     INSERT+HOME

      Read visible row from current cell
     INSERT+PAGE UP

      Read visible column
     INSERT+CTRL+UP ARROW

      Read visible column to current cell
     INSERT+CTRL+HOME

      Read visible column from current cell
     INSERT+CTRL+PAGE UP


Using One Settings File for Similar Spreadsheets with Different File Names
When you define settings like row and column titles and totals, you may want 
these settings to be available for other versions of the spreadsheet that 
have different names. For example, suppose that you define row and column 
totals for a spreadsheet named Sales1.xls. This spreadsheet is updated each 
month, and the name is changed accordingly. Therefore, next month's 
spreadsheet will be named Sales2.xls and so on. However, by default, JAWS 
only loads settings (.jsi) files for spreadsheets with the same file name. 
JAWS will not use settings you defined for Sales1.xls for Sales2.xls.

However, JAWS provides a feature that allows you to apply an existing 
settings file to a spreadsheet with a different name that is similar in 
design. To use this feature, open the spreadsheet in Excel, press INSERT+V, 
select the option "Workbook Settings," and press the SPACEBAR to choose 
"Best Match." JAWS searches for the closest matching settings file available 
and applies it to the current workbook. In the previous example, the 
spreadsheet Sales2.xls would use the settings file you created for 
Sales1.xls (excel_Sales1.xls.jsi). This feature makes it easy to apply your 
verbosity settings to subsequent versions of a spreadsheet without creating 
new a file each time the name changes.


      Back

     Next


----- Original Message ----- 
From: "Dave Carlson" <dgcarlson@xxxxxxxxxxxxx>
To: <jfw@xxxxxxxxxxxxx>
Sent: Thursday, January 28, 2010 10:01 PM
Subject: Re: Reading Column titles in excel 2003


Press Alt+Ctrl+Shift+C when you're on the row of column headings.

Dave

----- Original Message ----- 
From: "Brian and Denise Albriton" <autoharp@xxxxxxxxxxxxxx>
To: <jfw@xxxxxxxxxxxxx>
Sent: Thursday, January 28, 2010 19:20
Subject: Reading Column titles in excel 2003


I'm trying to read column titles in excel. I'm using jaws 10.
Brian

--
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: http://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: http://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: http://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: