Re: Printing in Excel
- From: "Terrill Reynolds" <terrill1@xxxxxxxx>
- To: <jfw@xxxxxxxxxxxxx>
- Date: Wed, 6 Jun 2007 12:09:18 -0400
Hi:
I have not used Excel for quite a while, but I found the below in the jaws help
files for Excel, hope something in here can help you <smile>.
Informational Keystrokes for Rows
List cells in current row (Excel 2007)
INSERT+SHIFT+R
List cells in current row (Excel 2003)
CTRL+SHIFT+R
Read row total
INSERT+DELETE
Say row title
ALT+SHIFT+R
Set row titles to column
ALT+CTRL+SHIFT+R
Set current row to the row containing column totals
CTRL+INSERT+DELETE
Informational Keystrokes for Columns
List cells in current column (Excel 2007)
INSERT+SHIFT+C
List cells in current column (Excel 2003)
CTRL+SHIFT+C
Read column total
INSERT+NUM PAD ENTER
Say column title
ALT+SHIFT+C
Set column titles to row
ALT+CTRL+SHIFT+C
Set current column to the column containing row totals
CTRL+INSERT+ENTER
Miscellaneous Informational Keystrokes
Describe cell border
ALT+SHIFT+B
Lists cells at page break
CTRL+SHIFT+B
List cells with comments
CTRL+SHIFT+APOSTROPHE
Read cell comment
ALT+SHIFT+' (APOSTROPHE)
List Visible cells with data
CTRL+SHIFT+D
List defined monitor cells
CTRL+SHIFT+M
List worksheets
CTRL+SHIFT+S
Say range of cells visible in active window
ALT+SHIFT+V
Read hyperlink
ALT+SHIFT+H
Report gridline status
ALT+SHIFT+G
Say active cell coordinates
INSERT+C
Says the last numeric value or word that appears in the Formula bar
CTRL+NUM PAD 5
Say Excel version
CTRL+INSERT+V
Say cell font and attributes
INSERT+F
Say formula
CTRL+F2
Read spelling error and suggestion
INSERT+F7
Display detailed cell appearance information
INSERT+TAB twice quickly
Excel Row and Column Title Reading
Defining Row and Column Titles
Before JAWS can read the titles of cells within a spreadsheet, you must specify
which columns and/or rows contain those titles. To define row titles, move
to the column containing the row titles and press ALT+CTRL+SHIFT+R. To define
column titles, move to the row containing the column titles and press
ALT+CTRL+SHIFT+C.
Tip: You can also press INSERT+V to use the Adjust JAWS Verbosity dialog box to
define row and column titles.
Alternatively, 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 6.10 or later. 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:
list of 4 items
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.
list end
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 Verbosity dialog box. Select "Override Named Titles" 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:
list of 5 items
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.
list end
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 verbosity options. Press INSERT+V, select "Title Reading," and press the
SPACEBAR to choose one of the following:
list of 4 items
. Off - JAWS does not announce row or column titles.
. Read Row Titles - When you move to a different row, JAWS reads the row title.
JAWS does not announce column titles.
. Read Column Titles - When you move to a different column, JAWS reads the
column title. JAWS does not announce row titles.
. 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.
list end
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 Verbosity 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.
table with 2 columns and 7 rows
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
table end
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.
Navigation Keystrokes
Move to prior screen in spreadsheet
ALT+PAGE UP
Move to next screen in spreadsheet
ALT+PAGE DOWN
Next Sheet
CTRL+PAGE DOWN
Prior Sheet
CTRL+PAGE UP
Move down to the edge of current data region
CTRL+DOWN ARROW
Move up to the edge of current data region
CTRL+UP ARROW
Move left to the edge of current data region
CTRL+LEFT ARROW
Move right to the edge of current data region
CTRL+RIGHT ARROW
Selection Keystrokes
Select column
CTRL+SPACEBAR
Select hyperlink
INSERT+F7
Select region
CTRL+SHIFT+8
Select row
SHIFT+SPACEBAR
Select worksheet objects
CTRL+SHIFT+O
Collapse selection to current cell
SHIFT+BACKSPACE
Configuration Keystrokes
Set monitor cell
INSERT+SHIFT+1 through 0
Read monitor cell
ALT+SHIFT+1 through 0
Formula input mode
= (EQUALS)
AutoFilter
CTRL+SHIFT+A
AutoSum
ALT+= (EQUALS)
Date stamp
CTRL+; (SEMICOLON)
Time stamp
CTRL+SHIFT+; (SEMICOLON)
Close Office Assistant
CTRL+INSERT+F4
table end
Warmest Regards,
Terrill Reynolds
Regular Email:
terrill1@xxxxxxxx
MSN Messenger: terrillreynolds36@xxxxxxxxxxx
AOL Messenger: terrill 36
Yahoo! Messenger: terrillreynolds
--------------------------------------------------------------------------------------
----- Original Message -----
From: Jill Kline
To: jfw@xxxxxxxxxxxxx
Sent: Wednesday, June 06, 2007 10:42 AM
Subject: Printing in Excel
Does anyone know if there is an easier way to determine what rows and/or
columns are in print range in an Excel spreadsheet other than going into print
preview and switching to JAWS cursor to read what's in view??
Thanks for any info!
Jill
Other related posts:
