Re: list of key strokes for Excel

• From: "Adrian Spratt" <Adrian@xxxxxxxxxxxxxxxx>
• To: <jfw@xxxxxxxxxxxxx>
• Date: Sat, 6 Feb 2010 14:41:49 -0500

Hi, Dave. I don't have NBP's guide to Excel key commands, but I've just looked through their guide to commands for several media players. Nowhere is there a copyright notice. As Soronel said, it is unlikely that a list of key commands can be copyrighted, but even Anna Dresner's introduction shows no claim to copyright. The question of copyright is a red herring raised by another lister. there doesn't appear to be any infringement here.

The only point I meant to make is that as visually impaired consumers, it is in our best interests to keep resource producers such as NBP in good financial shape. I know Dave Carlson agrees. I'll repeat NBP's website address so that people can look at all the guides NBP sells at reasonable prices: www.braille.com

My apologies to Bruce and Caroline for prolonging this thread, but I don't want to be the cause of any misinformation.

----- Original Message -----
From: "Dave Durber" <d.durber@xxxxxxxxx>
To: <jfw@xxxxxxxxxxxxx>
Sent: Saturday, February 06, 2010 1:19 PM
Subject: Re: list of key strokes for Excel

It is more than likely, that is, beyond the bounds of certainty and probability, any publication produced by organizations such as National Braille press, are copyrighted to those organizations, and therefore are subject to the terms and conditions of any applicable copyright laws, including liability to prosecution under such laws for infringement of such laws.

So, when we see something like "produced by" or "copyright", all of us should strenuously reframe from posting on any list, any copyrighted material.

sincerely:

Dave Durber

----- Original Message -----
From: "Adrian Spratt" <Adrian@xxxxxxxxxxxxxxxx>
To: <jfw@xxxxxxxxxxxxx>
Sent: Saturday, February 06, 2010 7:59 AM
Subject: Re: list of key strokes for Excel

In fairness to the National Braille Press, this keystrokes guide undoubtedly comes from one of their publications that typically cost $5. It would be unfortunate if NBP and Anna Dresner were discouraged from putting together these valuable booklets by having their contents copied and widely circulated for free. I mean no criticism. Dave apologized for having posted this list in error instead of sending it directly to Tom, and his intent was to help a fellow lister. I'm just urging people who benefit from such keystrokes lists to obtain them directly from NBP to keep them motivated to continue producing their useful computer and other publications. The website is: www.braille.com

----- Original Message -----
From: "tom behler" <tombehler@xxxxxxxxx>
To: <jfw@xxxxxxxxxxxxx>
Sent: Friday, February 05, 2010 8:09 PM
Subject: Re: list of key strokes for Excel

This is very much appreciated!

Tom Behler

----- Original Message -----
From: "Dave Carlson" <dgcarlson@xxxxxxxxxxxxx>
To: <jfw@xxxxxxxxxxxxx>
Sent: Friday, February 05, 2010 4:17 PM
Subject: Re: list of key strokes for Excel

Tom,

Not sure if this is copyrighted, since there is no copyright declarations in this version I received from one of many lists to which I subscribe, so here goes:

Excel 2007 Keyboard Commands With JAWS 9.0, Window-Eyes 7.0, and System Access 2.4

Compiled by Anna Dresner

Published and produced in braille by National Braille Press
88 St. Stephen St.
Boston, MA 02115
800-548-7323
www.nbp.org

Contents
Introduction 1
General Keyboard Commands for Office 2007 1
Keyboard Shortcuts for Using the Help Window 1
Display and Use Windows 3
Undo and Redo Actions 4
Use Dialog Boxes 4
Use Edit Boxes within Dialog Boxes 5
Use the Open and Save As Dialog Boxes 6
Access and Use Task Panes, Galleries, and Toolbars 6
Close a Task Pane 7
Move a Task Pane 7
Resize a Task Pane 8
Resize a Toolbar 8
Move a Toolbar 8
Access and Use Smart Tags 9
Smart Tag Tips 9
Navigating the Office Fluent Ribbon and Finding Access Keys 10
Working in a Different Language and Typing Special Characters 11
Insert Special Characters 11
Keyboard Shortcuts for International Characters 12
Adding a Keyboard Layout 13
Selecting Keyboard Layouts, and Handwriting Recognition 14
Keyboard Shortcuts for Working with Shapes, Text Boxes, and WordArt 15
Accessibility Tips when Working with a SmartArt Graphic 15
Create a SmartArt Graphic 16
Add Alternative Text to a SmartArt Graphic 17
General Keyboard Shortcuts 17
Use the Text Pane 17
Work with Shapes in a SmartArt Graphic 18
Move and Resize Shapes in a SmartArt Graphic 18
Work with Text in a SmartArt Graphic 19
Apply Character Formatting 20
Copy Text Formatting 21
Apply Paragraph Formatting 21
Select Chart Elements 22
Microsoft Clip Organizer Shortcuts 22
Keys for Using the Toolbar 23
Keys for Finding or Selecting Clips 23
Customize Keyboard Shortcuts 24
Assign a Keyboard Shortcut 24
Remove a Keyboard Shortcut 25
The Quick Access Toolbar 25
Move the Quick Access Toolbar 26
Add a Command to the Quick Access Toolbar 26
Remove a Command from the Quick Access Toolbar 27
Learning More about Office 2007 27
Keyboard Commands for Excel 28
Access Keys for the Main Tabs on the Ribbon 28
Basic File and Worksheet Commands 28
Navigating 29
Selecting Text and Other Elements 30
Formatting Text in a Worksheet 32
Formatting Cells 32
Editing and Deleting Text 33
Copying and Moving Text 34
Inserting Text Automatically 35
Performing Calculations and Working with the Formula Bar 36
Displaying and Hiding Spreadsheet Elements 36
Miscellaneous Commands 37
Changing the Size and Position of Workbook Windows 37
JAWS Commands for Excel 38
Getting Help 38
Informational Keystrokes for Columns 39
Informational Keystrokes for Rows 39
Commands for Reading Only Information Visible on Screen 39
Miscellaneous Informational Keystrokes 40
Navigation Keystrokes 41
Selection Keystrokes 41
Configuration Keystrokes 42
Window-Eyes Commands for Excel 42
Getting Help 43
Reading Cell Information 43
Charts and Objects 44
Element Properties Dialog 44
Additional Commands 46
System Access Commands for Excel 46
Appendix: Descriptions of SmartArt Graphics 48
List 48
Process 50
Cycle 52
Hierarchy 54
Relationship 55
Matrix 58
Pyramid 59

Introduction

Compiling a reference card is a less exact science than it used to be. At one time, I could simply go to the help system for each program, gather up all the keyboard commands, put them into tables, reorganize them a bit, and declare myself done. Not anymore. In many parts of Office 2007, commands are scattered throughout several parts of help, sometimes in lists in which almost, but not quite, all the commands are the same as those in another list. Occasionally a basic command is missing from help. So finding the commands is a bit like one of those computer games where you wander through mazes looking for treasure. I hope I've found all the treasure you need, and that you will find this reference card useful.

General Keyboard Commands for Office 2007

The keyboard shortcuts that are described throughout this reference guide refer to the U.S. keyboard layout. Keys on other layouts might not correspond exactly to the keys on a U.S. keyboard.

For keyboard shortcuts in which you press two or more keys simultaneously, the keys to press are separated by a plus sign. For keyboard shortcuts in which you press one key immediately followed by another key, the keys to press are separated by a comma.

Keyboard Shortcuts for Using the Help Window

The Help window provides access to all Office Help content. It displays topics and other Help information.

Command Keystroke Open the Help window F1 Close the Help window ALT+F4 Switch between the Help window and the active program ALT+TAB Go to the home page for the currently open Help system ALT+HOME Select the next item in the Help window TAB Select the previous item in the Help window SHIFT+TAB Perform the action for the selected item ENTER In the Browse Help section of the Help window, select the next or previous item TAB or SHIFT+TAB In the Browse Help section of the Help window, expand or collapse the selected item ENTER Select the next hidden text or hyperlink, including Show All or Hide All at the top of a Help topic TAB Select the previous hidden text or hyperlink SHIFT+TAB Perform the action for the selected Show All, Hide All, hidden text, or hyperlink ENTER Move to the previous Help topic (Back button) ALT+LEFT ARROW or BACKSPACE Move to the next Help topic (Forward button) ALT+RIGHT ARROW Scroll small amounts up or down within the current Help topic UP/DOWN ARROW Scroll larger amounts up or down within the current Help topic PAGE UP/PAGE DOWN Change whether the Help window appears connected to (tiled) or separate from (untiled) the active program ALT+U Display a menu of commands for the Help window Context key or SHIFT+F10 Stop the last action (Stop button) ESC Refresh the window (Refresh button) F5 Print the current Help topic CTRL+P Switch among areas in the Help window; for example, switch between the toolbar, Type words to search for box, and Search list F6 Change the connection state F6 to the proper location, TAB, DOWN ARROW Type text in the Type words to search for box F6 to the proper location In a Table of Contents in tree view, select the next or previous item UP/DOWN ARROW In a Table of Contents in tree view, expand or collapse the selected item RIGHT/LEFT ARROW

Display and Use Windows

Command Keystroke Close the active window CTRL+W or CTRL+F4 Move to a task pane from another pane in the program window (clockwise direction) F6, possibly multiple times. If pressing F6 doesn't display the task pane that you want, try pressing ALT to place focus on the menu bar or the Ribbon, and then press CTRL+TAB to move to the task pane. Move to a task pane from another pane in the program window (counterclockwise direction) SHIFT+F6, possibly multiple times Switch to the next item on the Task bar ALT+TAB Switch to the previous Task bar item ALT+SHIFT+TAB When more than one window is open, switch to the next window CTRL+F6 Switch to the previous window CTRL+SHIFT+F6 Maximize or restore a selected window CTRL+F10 Restore the size of the active window after maximizing it ALT+F5 Minimize a window to an icon (works for only some Microsoft Office programs) CTRL+F9 When a document window is not maximized, perform the Move command (on the Control menu for the window) CTRL+F7. Use the arrow keys to move the window, and, when finished, press ESC. When a document window is not maximized, perform the Size command (on the Control menu for the window) CTRL+F8. Press the arrow keys to resize the window, and, when finished, press ESC. Copy a picture of the screen to the Clipboard PRINT SCREEN Copy a picture of the selected window to the Clipboard ALT+PRINT SCREEN

Undo and Redo Actions

Command Keystroke Cancel an action ESC Undo an action CTRL+Z Redo or repeat an action CTRL+Y

Use Dialog Boxes

Command Keystroke Move to the next option or option group TAB Move to the previous option or option group SHIFT+TAB Switch to the next tab in a multi-page dialog box CTRL+TAB or CTRL+PAGE DOWN Switch to the previous tab in a multi-page dialog box CTRL+SHIFT+TAB or CTRL+PAGE UP Move between options in an open drop-down list, or between options in a group of options Arrow keys Run the selected command, or press the default button ENTER Perform the action assigned to the selected button; select or clear the selected check box SPACEBAR Select an option; select or clear a specific check box ALT+the letter underlined in an option Open the selected drop-down list ALT+DOWN ARROW Select an option from a drop-down list First letter of an option in a drop-down list Close a selected drop-down list; cancel a command and close a dialog box ESC Move from an open dialog box back to the document, for dialog boxes such as Find and Replace that support this behavior ALT+F6

Use Edit Boxes within Dialog Boxes

An edit box is a blank in which you type or paste an entry, such as your user name or the path to a folder.

Command Keystroke Move one character to the left/ right LEFT/RIGHT ARROW Move one word to the left/right CTRL+LEFT/RIGHT ARROW Move to the beginning/end of the entry HOME/END Select or unselect one character to the left/right SHIFT+LEFT/RIGHT ARROW Select or unselect one word to the left/right CTRL+SHIFT+LEFT/RIGHT ARROW Select from the insertion point to the beginning/end of the entry SHIFT+HOME/END

Use the Open and Save As Dialog Boxes

Command Keystroke Display the Open dialog box CTRL+O or CTRL+F12 Display the Save As dialog box F12 Move between options or areas in the dialog box TAB Go to the previous folder ALT+1 Go up a level ALT+2 Delete the selected folder or file DELETE Create a new folder ALT+4 Switch among available

folder views ALT+5 Display a shortcut menu for a selected item such as a

folder or file Context key, or SHIFT+F10 Show the Tools menu ALT+L Open the Look In list F4 or ALT+I Update the file list F5 Close the dialog box and open your Web search page ALT+3

Access and Use Task Panes, Galleries, and Toolbars

Command Keystroke Move to a task pane from another pane in the program window F6, possibly multiple times. If pressing F6 doesn't display the task pane that you want, try pressing ALT to place focus on the menu bar, and then press CTRL+TAB to move to the task pane. Move to a task pane when a menu is active CTRL+TAB, possibly multiple times Select the next or previous option in the active task pane TAB or SHIFT+TAB Display the full set of commands on the task pane menu CTRL+SPACEBAR Perform the action assigned to the selected button SPACEBAR or ENTER Open a drop-down menu for the selected gallery item Context key or SHIFT+F10 Select the first or last item in a gallery HOME or END Scroll up or down in the selected gallery list PAGE UP or PAGE DOWN Move to the top or bottom of the selected gallery list CTRL+HOME or CTRL+END Open the Research task pane ALT+Click (This keyboard shortcut does not work in Microsoft Office PowerPoint or Microsoft Office SharePoint Designer.) Open the Clipboard ALT+H, F, O

Close a Task Pane

1. Press F6 to move to the task pane, if necessary.
2. Press CTRL+SPACEBAR.
3. Use the arrow keys to select Close, and then press ENTER.

Move a Task Pane

1. Press F6 to move to the task pane, if necessary.
2. Press CTRL+SPACEBAR.
3. Use the arrow keys to select Move, and then press ENTER.
4. Use the arrow keys to move the task pane, or use CTRL+the arrow keys to
resize one pixel at a time, and then press ENTER.

Resize a Task Pane

1. Press F6 to move to the task pane, if necessary.
2. Press CTRL+SPACEBAR.
3. Use the arrow keys to select Size, and then press ENTER.
4. Use the arrow keys to resize the task pane, or use CTRL+the arrow keys
to resize one pixel at a time, and then press ENTER.

Resize a Toolbar

1. Press ALT to select the menu bar.
2. Press CTRL+TAB repeatedly to select the toolbar that you want.
3. Press CTRL+SPACEBAR to display the Toolbar Options menu.
4. Down arrow to Size, and then press ENTER.
5. Use the arrow keys to resize the toolbar. Press CTRL+ the arrow keys to
resize one pixel at a time. 6. Press ESC when finished.

Move a Toolbar

1. Press CTRL+SPACEBAR to display the Toolbar Options menu.
2. Down arrow to Size, and then press ENTER.
3. On the toolbar, press CTRL+SPACEBAR to display the Toolbar Options
menu.
4. Click the Move command, and then press ENTER.
5. Use the arrow keys to position the toolbar. Press CTRL+ the arrow keys

to move one pixel at a time. To undock the toolbar, press DOWN ARROW repeatedly. To dock the toolbar vertically on the left or right side, press LEFT ARROW or RIGHT ARROW when the toolbar is all the way to the left or right side. 6. Press ESC when finished.

Access and Use Smart Tags

Command Keystroke Display the shortcut menu for the selected item Context key or SHIFT+F10 Display the menu or message for a smart tag, the AutoCorrect Options button, or the Paste options button; if more than one smart tag is present, switch to the next smart tag and display its menu or message ALT+SHIFT+F10 Select the next/previous item on a smart tag menu DOWN/UP ARROW Perform the action for the selected item on a smart tag menu ENTER Close the smart tag menu or message ESC

Smart Tag Tips

You can ask to be notified by a sound whenever a smart tag appears. To hear audio cues, you must have a sound card. You must also have Microsoft Office Sounds installed on your computer. If you have access to the World Wide Web, you can download Microsoft Office Sounds from the Microsoft Office Online Web site. After you install the sound files, do the following in Microsoft Office Access 2007, Microsoft Office Excel 2007, Microsoft Office PowerPoint

2007, or Microsoft Office Word 2007:
1. Press ALT+F to open the menu under the Microsoft Office Button, and
then press I to open Program Options.
2. Press A to select Advanced.
3. Press ALT+S twice to move to the Provide feedback with sound check box,

which is under General, and then press SPACEBAR. 4. Press TAB repeatedly to select OK, and then press ENTER. Note that when you select or clear this check box, the setting affects all Office programs that support sound.

Navigating the Office Fluent Ribbon and Finding Access Keys

Access keys, also called KeyTips, provide a way to quickly use a command by pressing a few keys, no matter where you are in the program. Every command in Word, Excel, and PowerPoint 2007 can be accessed by using an access key. You can get to most commands by using two to five keystrokes. To explore the ribbon and find out the access key for the feature you want to use, do the following:

1. Press ALT to go to the Ribbon.
2. Press the LEFT and RIGHT arrow keys to move between the tabs on the

ribbon, such as Home, Insert, and Page Layout. Most screen readers read the KeyTip associated with each tab when you arrow to it. 3. Press TAB or SHIFT+TAB to move through the items on the current tab. As you tab to each item, most screen readers tell you the KeyTips you need to access it. 4. The items within a tab are arranged in smaller groups. You can move between these with SHIFT+LEFT OR RIGHT ARROW, except when you land on an edit box. In that case, press TAB or SHIFT+TAB until you're not in an edit box, and then press SHIFT+LEFT or RIGHT ARROW. 5. When you find the item you want, note the KeyTip you need to reach that item; you can use it in the future to access it quickly. 6. Press SPACEBAR or ENTER to execute the command, or press ALT or ESC to leave the ribbon without executing a command.

You can access many commands that were in the File menu in previous versions of Office--as well as the Options dialog where you can change options like AutoCorrect, automatic formatting, and whether all Word documents open in separate windows or the same window--from the Office menu, located IN THE upper left corner of the screen. Press ALT+F to open this menu.

One type of control on the Ribbon and the Office menu is the split button. Press Enter to activate the main function of the button, or SPACEBAR to open a menu related to the button. For example, pressing ENTER on the Print split button opens the Print dialog, while pressing SPACEBAR opens a menu of additional printing choices.

Press F1 to get help with the item that has focus on the ribbon. If no help is available for that specific item, a more general help topic will open.

Working in a Different Language and Typing Special Characters

Insert Special Characters

To insert this Press A field CTRL+F9 A line break SHIFT+ENTER A page break CTRL+ENTER A column break CTRL+SHIFT+ENTER An em dash ALT+CTRL+MINUS SIGN An en dash CTRL+MINUS SIGN An optional hyphen CTRL+HYPHEN A nonbreaking hyphen CTRL+SHIFT+HYPHEN A nonbreaking space CTRL+SHIFT+SPACEBAR The copyright symbol ALT+CTRL+C The registered trademark symbol ALT+CTRL+R The trademark symbol ALT+CTRL+T An ellipsis ALT+CTRL+PERIOD A single opening quotation mark CTRL+GRAVE ACCENT, GRAVE ACCENT A single closing quotation mark CTRL+APOSTROPHE, APOSTROPHE Double opening quotation marks CTRL+ GRAVE ACCENT, SHIFT+APOSTROPHE Double closing quotation marks CTRL+'APOSTROPHE, SHIFT+APOSTROPHE An AutoText entry Start typing a word or phrase that has AutoText associated with it, and press ENTER when a ScreenTip appears or is read by your screen reader

Keyboard Shortcuts for International Characters

To type a lowercase character by using a key combination that includes the SHIFT key, hold down the CTRL+SHIFT+symbol keys simultaneously, and then release them before you type the letter.

To insert this Press à, è, ì, ò, ù, À, È, Ì, Ò, Ù CTRL+GRAVE ACCENT, the letter á, é, í, ó, ú, ý, Á, É, Í, Ó, Ú, Ý CTRL+APOSTROPHE, the letter â,

ê,
î, ô, û, Â, Ê, Î, Ô, Û CTRL+CARET, the letter ã, ñ, õ, Ã, Ñ, Õ CTRL+TILDE,

the letter ä, ë, ï, ö, ü, ÿ, Ä, Ë, Ï, Ö, Ü, Y CTRL+SHIFT+COLON, the letter å, Å CTRL+AT SIGN, a or A

æ, Æ

CTRL+AMPERSAND, a or A o, O CTRL+AMPERSAND, o or O ç, Ç CTRL+COMMA, c or C ð, Ð CTRL+APOSTROPHE, d or D ø, Ø CTRL+SLASH, o or O

¿
ALT+CTRL+QUESTION MARK ¡ ALT+CTRL+EXCLAMATION POINT
ß

CTRL+AMPERSAND, s The Unicode character for the specified Unicode (hexadecimal) character code The character code, ALT+X. For example, to insert the euro currency symbol, press 20AC, and then hold down the ALT key and press X. Find out the Unicode character code for the selected character ALT+X The ANSI character for the specified ANSI (decimal) character code ALT+the character code (on the numeric keypad). For example, to insert the euro currency symbol, hold down the ALT key and press 0128 on the numeric keypad. Make sure that NUM LOCK is on before you type the character code.

Note: ANSI character set: An 8-bit character set used by Microsoft Windows that allows you to represent up to 256 characters (0 through 255) by using your keyboard. The ASCII character set is a subset of the ANSI set.

Note: If you type extensively in another language, you may prefer to switch to a different keyboard layout instead.

Adding a Keyboard Layout

When you switch the keyboard layout to a different language, the position of letters, numbers and punctuation may change, and any special characters used in that language will be readily available. The text you type is automatically identified as being written in that language, and if your screen reader detects languages and has the one you are typing in installed, it will read what you type in that language. A wide variety of layouts is available within Windows.

If your default language is U.S. English and you switch to French or Spanish, you can check the spelling and grammar of the text you type simply by running a spelling or grammar check. If you want to be able to check spelling or grammar for other languages, you must purchase language packs for each one from Microsoft at office.microsoft.com/en-us/suites/FX102113661033.aspx. The current cost is US$24.95 apiece. Multiple language packs are also available.

Here's how to install a keyboard layout:
1. Go to the Start menu and open Control Panel.
2. Press ENTER on Regional and Language Options.
3. Press CTRL+TAB to go to the Languages page in this multi-page dialog.
4. Press Enter on the first choice in this dialog, the Details button.
5. You are now on a combo box where you can decide which language is your

default. This box also shows which layouts are already installed. If you explore this box, be sure to arrow to the layout you want to be your default before leaving the combo box.

6. Tab to the ADD button and press ENTER.
7. Arrow to the language you want to install and press ENTER.
8. Press ENTER to click the OK button and exit the Details dialog.
9. Tab to OK and press ENTER to close the regional and Languages dialog.
10. Press ALT+F4 to close Control Panel.

Selecting Keyboard Layouts, and Handwriting Recognition

Command Keystroke Switch between languages or keyboard layouts Left ALT+SHIFT Display a list of correction alternatives Windows key+C Turn handwriting on or off Windows key+H Turn Japanese Input Method Editor (IME) on 101 keyboard on or off ALT+~ Turn Korean IME on 101 keyboard on or off Right ALT Turn Chinese IME on 101 keyboard on or off CTRL+SPACEBAR

Note: You can choose the key combination for switching between languages or keyboard layouts in the Advanced Key Setting dialog box. To open the Advanced Key Setting dialog box:

1. Go to the Start menu and open Control Panel.
2. Press ENTER on Regional and Language Settings.
3. Press CTRL+TAB to go to the Languages page in this multi-page dialog.
4. Press ENTER on the first option, the Details button.
5. Tab to the Key Settings button and press ENTER.

Keyboard Shortcuts for Working with Shapes, Text Boxes, and WordArt

Accessibility Tips when Working with a SmartArt Graphic

2007 Microsoft Office System programs are designed to be used by people with different abilities. If you use an assistive aid, such as a screen reader or screen magnifier, the following tips may help you to work with your SmartArt graphic:

The Text pane is an outline representation of the information in your SmartArt graphic. You can open the Text pane and work directly in it to create and manipulate the shapes in your SmartArt graphic. The first time you insert a SmartArt graphic, the Text pane opens automatically and you can immediately start typing your text. Most screen readers give you the level and hierarchy of the information in your shapes. If you prefer to work directly in your SmartArt graphic rather than in the Text pane, press CTRL+SHIFT+F2 to switch between the Text pane and your SmartArt graphic. When you enter text in the Text pane, corresponding shapes are added to your SmartArt graphic and sized based on the amount of text that you enter. If necessary, the font size is automatically reduced so that all of your text fits into the shape. You can also resize the shape manually. The table at the end of this article lists the keyboard shortcuts for resizing shapes.

Create a SmartArt Graphic

1. Insert a SmartArt graphic in one of the following ways: a. Press ALT+N, M to click SmartArt in the Illustrations group on the Insert tab. b. In Microsoft Office PowerPoint 2007 only, select text on a slide, and then on the Home tab, in the Paragraph group, click Convert to SmartArt Graphic. 2. Press UP ARROW or DOWN ARROW to select the type of graphic that you want.

3. Press TAB to move to the Layout task pane.
4. Press the arrow keys to select the layout that you want.
5. Press ENTER to insert the selected layout.
6. Enter your text in the Text pane in outline form. You can modify the

Text pane just like you can modify any outline or bulleted list. 7. Press CTRL+SHIFT+F2 to move from shape to shape and to hear more information.

To select multiple shapes by using the keyboard, select a line of text in the Text pane, and then press SHIFT+DOWN ARROW to select the additional shapes. You cannot select nonadjacent shapes (lines of text) in the Text pane, nor can you select only connecting lines from the Text pane.

Note: The Select Multiple Objects box and toolbar button are no longer available in the 2007 Office release.

Add Alternative Text to a SmartArt Graphic

1. Right-click the border of the SmartArt graphic, and then do one of the following:

a. In Microsoft Office Excel 2007, click Size and Properties.
b. In Microsoft Office Outlook 2007 and Microsoft Office Word 2007, click

Size. c. In Microsoft Office PowerPoint 2007, click Size and Position. 2. Click the Alt Text tab, and then in the Alternative text box, enter your text.

General Keyboard Shortcuts

Command Keystroke Insert a new SmartArt graphic ALT+N, M After you add a SmartArt graphic, open the layout gallery, where you can view and change all layouts ALT, C, S, L, M

Use the Text Pane

Command Keystroke Open the SmartArt graphics Help topic CTRL+SHIFT+F1 Indent text in the Text pane TAB Outdent text in the Text pane SHIFT+TAB Add a tab character to text in the Text pane CTRL+TAB Merge two lines of text DELETE at the end of the first line of text Select multiple contiguous shapes in the Text pane Select a line of text in the Text pane, and then press SHIFT+DOWN ARROW as needed to select the additional shapes Display the shortcut menu Context key or SHIFT+F10 Switch between the Text pane and the drawing canvas CTRL+SHIFT+F2 Switch the focus from the Text pane to the border of the SmartArt graphic ESC Move from the Text pane to the Ribbon CTRL+SHIFT+F2 to move to the SmartArt graphic, and then press ALT to move to the Ribbon Close the Text pane ALT+F4

Work with Shapes in a SmartArt Graphic

Command Keystroke Select the next element in a SmartArt graphic TAB Select the previous element in a SmartArt graphic SHIFT+TAB Select all shapes CTRL+A Remove focus from the selected shape ESC Edit text in the selected shape ENTER or F2 Delete the selected shape DELETE or BACKSPACE Cut the selected shape CTRL+X or SHIFT+DELETE Copy the selected shape CTRL+C Paste the contents of the Clipboard CTRL+V Undo the last action CTRL+Z

Move and Resize Shapes in a SmartArt Graphic

Command Keystroke Enlarge the selected shape horizontally SHIFT+RIGHT ARROW Reduce the selected shape horizontally SHIFT+LEFT ARROW Enlarge the selected shape vertically SHIFT+UP ARROW Reduce the selected shape vertically SHIFT+DOWN ARROW Resize the shape in very small increments CTRL+SHIFT+UP ARROW, DOWN ARROW, RIGHT ARROW, or LEFT ARROW Move the shape in the direction that you want UP ARROW, DOWN ARROW, RIGHT ARROW, or LEFT ARROW Move or "nudge" the shape in very small increments CTRL+UP ARROW, DOWN ARROW, RIGHT ARROW, or LEFT ARROW Rotate the shape in the desired direction 15 degrees ALT+RIGHT or LEFT ARROW Rotate the shape 1 degree CTRL+ALT+RIGHT or LEFT ARROW

Note: These keyboard shortcuts apply to multiple selections as if you selected each item individually.

Work with Text in a SmartArt Graphic

Command Keystroke Move one character to the left/right LEFT/RIGHT ARROW Move up/down one line UP/DOWN ARROW Move one word to the left/right CTRL+LEFT/RIGHT ARROW Move one paragraph up/down CTRL+UP/DOWN ARROW Move to the beginning/end of a line HOME/END Move to the beginning/end of a text box CTRL+HOME/END Cut selected text CTRL+X Copy selected text CTRL+C Paste selected text CTRL+V Undo the last action CTRL+Z Delete one character to the left BACKSPACE Delete one word to the left CTRL+BACKSPACE Delete one character to the right DELETE Delete one word to the right CTRL+DELETE Promote the selected text ALT+SHIFT+RIGHT ARROW Demote the selected text ALT+SHIFT+LEFT ARROW Check the spelling (not available in Microsoft Office Word 2007) F7

Apply Character Formatting

Command Keystroke Open the Font dialog box CTRL+SHIFT+F or CTRL+D Open the Font dialog box with focus on point size CTRL+SHIFT+P Increase the font size of the selected text CTRL+SHIFT+ GREATER THAN Decrease the font size of the selected text CTRL+SHIFT+ LESS THAN Switch the case of selected text (lower case, Title Case, UPPER CASE) SHIFT+F3 Apply bold formatting to the selected text CTRL+B Apply an underline to the selected text (not available in Office Word 2007) CTRL+U Apply italic formatting to the selected text CTRL+I Apply subscript formatting to the selected text CTRL+EQUALS Apply superscript formatting to the selected text CTRL+PLUS SIGN Adjust the superscript/subscript offset up CTRL+ALT+GREATER THAN Adjust the superscript/subscript offset down CTRL+ALT+LESS THAN Remove all character formatting from the selected text CTRL+SPACEBAR

Copy Text Formatting

Note: The following functionality is not available in Microsoft Word.

Command Keystroke Copy formatting from the selected text CTRL+SHIFT+C Paste formatting to the selected text CTRL+SHIFT+V

Apply Paragraph Formatting

Command Keystroke Center a paragraph CTRL+E Justify a paragraph CTRL+J Left align a paragraph CTRL+L Right align a paragraph CTRL+R Demote a bullet point TAB or ALT+SHIFT+RIGHT ARROW Promote a bullet point SHIFT+TAB or ALT+SHIFT+LEFT ARROW

Select Chart Elements

You can select the next or previous sheet in a chart by pressing CTRL+PAGE DOWN or CTRL+PAGE UP until the chart sheet that you want is selected. After you select a chart, you can use the keyboard to select individual chart elements as follows:

Command Keystroke Select the previous group of elements in a chart DOWN ARROW Select the next group of elements in a chart UP ARROW Select the next element within a group. If the current element is the last element in the group, the next group is selected; Press RIGHT ARROW again to select the first element in the next group. RIGHT ARROW Select the previous element within a group. If the current element is the first element in the group, the previous group is selected; press LEFT ARROW again to select the last element in the previous group. LEFT ARROW Cancel a selection ESC Navigate between the chart and any objects or shapes outside of the chart by selecting the next object or shape TAB Navigate between the chart and any objects or shapes outside of the chart by selecting the previous object or shape SHIFT+TAB

Microsoft Clip Organizer Shortcuts

Keys for Using the Toolbar

Command Keystroke Open Help ALT+H Move forward/backward one word in the Search text box CTRL+LEFT/RIGHT ARROW Display the Collection List task pane ALT+C Display the Search task pane ALT+S

Keys for Finding or Selecting Clips

Command Keystroke Move left and right, up and down, among collections or clips ARROW KEYS Select additional clips after one clip has been selected SHIFT+ARROW KEYS Select all clips on the current page CTRL+A Copy (select a clip and move it to the clipboard) CTRL+C Paste (paste from the clipboard to Clip Organizer) CTRL+V Delete selected clip or category DELETE Move to the beginning of a row and select the first item HOME Move to the end of a row and select the last item END Open the shortcut menu of a dialog box ALT+SPACEBAR

Customize Keyboard Shortcuts

You can customize keyboard shortcuts by assigning keyboard shortcuts (or shortcut keys) to a command, macro, font, style, or commonly used symbol. You can also remove keyboard shortcuts. To select a command to assign a shortcut to or remove a shortcut from, do the following:

1. Press ALT+F to press the Office button.
2. Press I; or up arrow to Options and press ENTER.
3. Type C to move to Customize in the list of option types.
4. Press SHIFT+TAB until you reach the Customize button and press ENTER.

You are now in a list of categories from which you can choose commands. 5. Press DOWN ARROW or UP ARROW to select the category that contains the command or other item that you want to assign a keyboard shortcut to or remove a keyboard shortcut from.

6. Press TAB to move to the Commands box.
7. Press DOWN ARROW or UP ARROW to select the name of the command or other

item that you want to assign a keyboard shortcut to or remove a keyboard shortcut from. 8. Tab once to the Current Keys box. Any keyboard shortcuts that are currently assigned to that command or item appear there. 9. Do one of the following:

Assign a Keyboard Shortcut

Begin keyboard shortcuts with CTRL or a function key. a. Press the TAB key repeatedly until the cursor is in the Press new shortcut key box. b. Press the combination of keys that you want to assign. For example, press CTRL plus the key that you want to use. c. Use your screen reader's mouse cursor to look at "Currently assigned to" (which is near the bottom of the screen) to see whether the combination of keys is already assigned to a command or other item. If the combination is already assigned to a command you plan to use, type a different combination. Important: Reassigning a combination of keys means that you can no longer use the combination for its original purpose. For example, pressing CTRL+B changes selected text to bold. If you reassign CTRL+B to a new command or other item, you will not be able to make text bold by pressing CTRL+B unless you restore the keyboard shortcut assignments to their original settings by clicking Reset All. d. Press the TAB key repeatedly until Assign is selected, and then press ENTER.

Note: If you use a programmable keyboard, the key combination CTRL+ALT+F8 might be reserved for initiating keyboard programming.

Remove a Keyboard Shortcut

a. Press the TAB key repeatedly until the cursor is in the Current keys box. b. Press DOWN ARROW or UP ARROW to select the keyboard shortcut that you want to remove. c. Press the TAB key repeatedly until Remove is selected, and then press ENTER.

10. Press the TAB key repeatedly until the Save changes in box is selected. 11. Press DOWN ARROW or UP ARROW to highlight the current document name or template in which you want to save the keyboard shortcut changes, and then press ENTER.

The Quick Access Toolbar

The Quick Access Toolbar is a customizable toolbar that contains a set of commands that are independent of the tab that is currently displayed. You can access the buttons on this toolbar by pressing ALT+a number, making it easy to access up to 10 commands you use on a regular basis. The first command on the toolbar is accessed with ALT+1, the second with ALT+2, and so on, with ALT+0 accessing the 10th command. You can move the Quick Access Toolbar between two possible locations and add buttons that represent commands to the Quick Access Toolbar. You can also change the order in which items appear on the Quick Access Toolbar in the Customize dialog discussed above.

Move the Quick Access Toolbar

The Quick Access Toolbar can be located in one of two places: the upper-le ft corner next to the Microsoft Office Button (default location) or below the Ribbon. Since the latter location covers some of the work area, it's best to leave the Quick Access Toolbar in its default location. If you need to move it, however, here's how:

1. Press ALT to go to the ribbon.
2. Press SHIFT+TAB twice to go to the Customize Quick Access Toolbar

button and press SPACEBAR. 3. Press UP ARROW twice to reach either Show Below the Ribbon or Show Above the Ribbon, and press ENTER. Add a Command to the Quick Access Toolbar

1. Press ALT to go to the ribbon.
2. Press the arrow keys, TAB, and SHIFT+the arrow keys as needed to locate
the command you want to add.
3. Press the Context key or SHIFT+10.
4. Press ENTER on the first choice, Add to Quick Access Toolbar.

Notes

* There is no option in Microsoft Office for increasing the size of the buttons representing the commands on the Quick Access Toolbar. The only way to increase the size of the buttons is to lower the screen resolution you use.

* You cannot display the Quick Access Toolbar on multiple lines.
* Only commands can be added to the Quick Access Toolbar. The contents of

most lists, such as indent and spacing values and individual styles, which also appear on the Ribbon, cannot be added to the Quick Access Toolbar.

Remove a Command from the Quick Access Toolbar

Here's how to remove a command you don't want from the Quick Access Toolbar:

1. Press ALT to go to the ribbon.
2. Press SHIFT+TAB 3 times to go to the Quick Access Toolbar.
3. Find the command you wish to remove.
4. Press the Context key or SHIFT+F10.
5. Press ENTER on the first choice, Remove From the quick Access Toolbar.

Changing the Order in which Commands Appear on the Quick Access Toolbar

1. Type ALT+F to open the Office menu.
2. Type I; or up arrow to Options and press ENTER.
3. Type C; or down arrow to Customize.
4. Tab to the Quick Access Toolbar list.
5. Down arrow as needed to find the item you want to move.
6. Tat to the Move Up or Move Down button and press ENTER.
7. Repeat as necessary to reorder all the items as you like.

Learning More about Office 2007

Dan Clark at Freedom Scientific has created an excellent introduction to the Office 2007 ribbon, the Quick Access Toolbar, and other unique features of Office. It is valuable regardless of the screen reader you use.

If you have JAWS 9, you can find a DAISY version of this introduction as Module 31, Office 2007 with Magic and JAWS and read it with the built-in demo of FSReader or any other DAISY player. The other option is to download it in DAISY or MP3 format from the JAWS Training page at www.freedomscientific.com/Training/JAWS_training_hq.asp.

Keyboard Commands for Excel

Access Keys for the Main Tabs on the Ribbon

Command Keystroke Home ALT+H Insert ALT+N Page Layout ALT+P Formulas ALT+M Data ALT+A Review ALT+R View ALT+W Add-Ins ALT+X Help F1 Office menu ALT+F

Basic File and Worksheet Commands

Command Keystroke Display the Microsoft Office Excel Help task pane F1 Create a new, blank workbook CTRL+N Insert a new worksheet SHIFT+F11 or ALT+SHIFT+F1 Display the Open dialog box to open or find a file CTRL+O Close the selected workbook window CTRL+W or CTRL+F4 Save file CTRL+S Display the Save As dialog box F12 Display the print dialog box CTRL+P Display the Print Preview window CTRL+F2 Switch between the worksheet, Ribbon, task pane, and Zoom controls. In a worksheet that has been split (View menu, Manage This Window, Freeze Panes, Split Window command), this command includes the split panes when switching between panes and the Ribbon area. F6, reverse direction with SHIFT+F6 Switch to the next workbook window when more than one workbook window is open CTRL+F6 Exit Excel Alt+F4

Navigating

Command Keystroke Display the Go To dialog box CTRL+G or F5 Display the Find and Replace dialog box, with the Find tab selected CTRL+F or SHIFT+F5 Repeat the last Find action SHIFT+F4 Display the Find and Replace dialog box, with the Replace tab selected CTRL+H Move one cell up, down, left, or right in a worksheet ARROW KEYS Move to the edge of the current data region in a worksheet CTRL+ARROW KEY Move one cell to the right in a worksheet. Move between unlocked cells in a protected worksheet. TAB Move to the previous cell in a worksheet SHIFT+TAB Move to the beginning of a row in a worksheet. Move to the cell in the upper-left corner of the window when SCROLL LOCK is turned on. HOME Move to the cell in the lower-right corner of the window when SCROLL LOCK is turned on END Move to the beginning of a worksheet CTRL+HOME Move to the last cell on a worksheet, in the lowest used row of the rightmost used column. If the cursor is in the formula bar, move the cursor to the end of the text. CTRL+END Move one screen up in a worksheet PAGE UP Move one screen down in a worksheet PAGE DOWN Move one screen to the left in a worksheet ALT+PAGE UP Move one screen to the right in a worksheet ALT+PAGE DOWN Move to the previous sheet in a workbook CTRL+PAGE UP Move to the next sheet in a workbook CTRL+PAGE DOWN

Selecting Text and Other Elements

Command Keystroke Select the entire worksheet. If the worksheet contains data, select the current region; press twice to select the current region and its summary rows, or 3 times to select the entire worksheet. When the insertion point is to the right of a function name in a formula, display the Function Arguments dialog box. CTRL+A Select the entire worksheet. If the worksheet contains data, select the current region; press twice to select the current region and its summary rows, and 3 times to select the entire worksheet. When an object is selected, select all objects on a worksheet. CTRL+SHIFT+SPACEBAR Select an entire column in a worksheet CTRL+SPACEBAR Select an entire row in a worksheet SHIFT+SPACEBAR Select the current region around the active cell (the data area enclosed by blank rows and blank columns); in a PivotTable, select the entire PivotTable report CTRL+ ASTERISK Select all cells that contain comments CTRL+SHIFT+O Extend the selection of cells by one cell SHIFT+ARROW KEY Extend the selection of cells to the last nonblank cell in the same column or row as the active cell, or if the next cell is blank, extend the selection to the next nonblank cell CTRL+SHIFT+ARROW KEY Extend the selection of cells to the beginning of the worksheet CTRL+SHIFT+HOME Extend the selection of cells to the last used cell on the worksheet (lower-right corner). If the cursor is in the formula bar, select all text in the formula bar from the cursor position to the end-this does not affect the height of the formula bar. CTRL+SHIFT+END Select the current and previous sheet in a workbook CTRL+SHIFT+PAGE UP Select the current and next sheet in a workbook CTRL+SHIFT+PAGE DOWN Turn extend mode on or off. In extend mode, Extended Selection appears in the status line, and the arrow keys extend the selection. F8 Add a nonadjacent cell or range to a selection of cells by using the arrow keys SHIFT+F8

Formatting Text in a Worksheet

Command Keystroke Apply or remove bold formatting CTRL+B or CTRL+2 Apply or remove italic formatting CTRL+I or CTRL+3 Apply or remove underlining CTRL+U or CTRL+4 Apply or remove strikethrough CTRL+5 Open the Format Cells dialog box with the Font tab selected CTRL+SHIFT+F Change the font size CTRL+SHIFT+P

Formatting Cells

Command Keystroke Display the Format Cells dialog box CTRL+1 Apply the General number format CTRL+TILDE Apply the Currency format with two decimal places (negative numbers in parentheses) CTRL+ DOLLAR SIGN Apply the Percentage format with no decimal places CTRL+PERCENT Apply the Exponential number format with two decimal places CTRL+CARET Apply the Date format with the day, month, and year CTRL+NUMBER SIGN Apply the Time format with the hour and minute, and AM or PM CTRL+AT SIGN Apply the Number format with two decimal places, thousands separator, and minus sign (-) for negative values CTRL+EXCLAMATION POINT Apply the outline border to the selected cells

CTRL+AMPERSAND Remove the outline border from the selected cells
CTRL+UNDERSCORE

Editing and Deleting Text

Command Keystroke Delete one character to the left in the Formula Bar. Clear the content of the active cell. In cell editing mode, delete the character to the left of the insertion point. BACKSPACE Remove the cell contents (data and formulas) from selected cells without affecting cell formats or comments. In cell editing mode, delete the character to the right of the insertion point. DELETE Display the Insert dialog box to insert blank cells CTRL+PLUS SIGN Display the Delete dialog box to delete the selected cells CTRL+MINUS SIGN Edit the active cell and position the insertion point at the end of the cell contents; move the insertion point into the Formula Bar when editing in a cell is turned off F2 Add or edit a cell comment SHIFT+F2 Display the Insert Hyperlink dialog box for new hyperlinks or the Edit Hyperlink dialog box for selected existing hyperlinks CTRL+K Display the Create Table dialog box CTRL+T Display the Spelling dialog box to check spelling in the active worksheet or selected range F7 Complete a cell entry from the cell or the Formula Bar and select the cell below (by default). In a data form, move to the first field in the next record. ENTER Complete a cell entry and select the cell above SHIFT+ENTER Start a new line in the same cell ALT+ENTER Fill the selected cell range with the current entry CTRL+ENTER Cancel an entry in the cell or Formula Bar. Close full screen mode when this mode has been applied, and return to normal screen mode to display the Ribbon and status bar again. ESC Repeat the last command or action, if possible CTRL+Y or F4 Use the Undo command to reverse the last command or to delete the last entry that you typed CTRL+Z Use the Undo or Redo command to reverse or restore the last automatic correction when AutoCorrect Smart Tags are displayed CTRL+SHIFT+Z

Copying and Moving Text

Command Keystroke Cut the selected cells to the Clipboard CTRL+X Copy the selected cells to the Clipboard. Press twice to display the Clipboard. CTRL+C Insert the contents of the Clipboard at the insertion point and replace any selection. Available only after you have cut or copied an object, text, or cell contents. CTRL+V Display the Paste Special dialog box. Available only after you have cut or copied an object, text, or cell contents on a worksheet or in another program. CTRL+ALT+V Display the Paste Name dialog box F3 Copy a formula from the cell above the active cell into the cell or the Formula Bar CTRL+APOSTROPHE Copy the value from the cell above the active cell into the cell or the Formula Bar CTRL+QUOTATION MARKS Use the Fill Down command to copy the contents and format of the topmost cell of a selected range into the cells below. CTRL+D Use the Fill Right command to copy the contents and format of the leftmost cell of a selected range into the cells to the right CTRL+R

Inserting Text Automatically

Command Keystroke Insert the current date CTRL+SEMICOLON Insert the current time CTRL+COLON Insert columns/rows CTRL+PLUS SIGN

Performing Calculations and Working with the Formula Bar

Command Keystroke Start a formula EQUALS SIGN Expand or collapse the formula bar CTRL+SHIFT+U Autosum a range of cells ALT+EQUALS Insert the argument names and parentheses when the insertion point is to the right of a function name in a formula CTRL+SHIFT+A Calculate all worksheets in all open workbooks F9 Calculate the active worksheet SHIFT+F9 Calculate all worksheets in all open workbooks, regardless of whether they have changed since the last calculation CTRL+ALT+F9 Recheck dependent formulas, and then calculate all cells in all open workbooks, including cells not marked as needing to be calculated CTRL+ALT+SHIFT+F9

Displaying and Hiding Spreadsheet Elements

Command Keystroke Display or hide the Microsoft Office Ribbon CTRL+F1 Alternate between displaying cell values and displaying formulas in the worksheet CTRL+GRAVE ACCENT Alternate between hiding objects, displaying objects, and displaying placeholders for objects CTRL+6 Display or hide the outline symbols CTRL+8 Hide the selected rows CTRL+9 Unhide any hidden rows within the selection CTRL+LEFT PARENTHESIS Hide the selected columns CTRL+0 Unhide any hidden columns within the selection CTRL+RIGHT PARENTHESIS

Miscellaneous Commands

Command Keystroke Display the Macro dialog box to create, run, edit, or delete a macro ALT+F8 Turn key tips on or off F10 Display the menu or message for a smart tag. If more than one smart tag is present, switch to the next smart tag and display its menu or message. ALT+SHIFT+F10 Create a chart of the data in the current range F11 or ALT+F1 Open the Microsoft Visual Basic Editor, in which you can create a macro by using Visual Basic for Applications (VBA) ALT+F11

Changing the Size and Position of Workbook Windows

Command Keystroke Maximize or restore the selected workbook window CTRL+F10 Minimize a workbook window to an icon CTRL+F9 Restore the window size of the selected workbook window CTRL+F5 Perform the Move command on the workbook window when it is not maximized. After pressing this command, use the arrow keys to move the window, and when finished press ENTER, or ESC to cancel. CTRL+F7 Perform the Size command (on the Control menu for the workbook window) when a workbook is not maximized CTRL+F8

JAWS Commands for Excel

Note: Many Excel features are also or only available in the Adjust JAWS Options dialog box. To access these options, press INSERT+V while you are in Excel. Use the arrow keys to select an option, and then press the SPACEBAR to cycle through the available settings. This dialog also has the option to apply verbosity settings from one spreadsheet to others with similar names. To access this feature, open a spreadsheet you want to apply the settings to, choose Workbooks Settings, press the SPACEBAR until you reach the Best Match setting, and then press ENTER.

Getting Help

Command Keystroke Display context-sensitive help information in the Virtual Viewer INSERT+F1 Read the JAWS Help topic for Excel Open Excel, press INSERT+F1 twice quickly, and then press F6 to move to the help topic. Display a list of JAWS commands for Excel in the Virtual Viewer INSERT+H Display a list of common Excel commands in the Virtual Viewer INSERT+W

Note: When you are learning to use Excel, be sure to read the Helpful Hints section of the JAWS help topic on Excel. Many procedures for configuring Excel are described there in detail.

Informational Keystrokes for Columns

Command Keystroke List cells in current column INSERT+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

Informational Keystrokes for Rows

Command Keystroke List cells in current row INSERT+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

Commands for Reading Only Information Visible on Screen

Command 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

Miscellaneous Informational Keystrokes

Command Keystroke Describe cell border ALT+SHIFT+B Lists cells at page break CTRL+SHIFT+B List cells with comments CTRL+SHIFT+APOSTROPHE List cells with formulas INSERT+SHIFT+F 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 Say 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

Navigation Keystrokes

Command Keystroke 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

Command Keystroke 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

Command Keystroke Set monitor cell INSERT+SHIFT+1 through 0 Read monitor cell ALT+SHIFT+1 through 0 AutoFilter CTRL+SHIFT+A Create, rename, or delete Custom Summary from selected cells CTRL+INSERT+TAB, or press INSERT+F2 and choose Custom Summary Labels View Custom Summary CTRL+INSERT+SHIFT+TAB, or press INSERT+F2 and choose View Custom Summary

Window-Eyes Commands for Excel

Note: You can control a great deal about what Window-Eyes speaks in Excel from the Verbosity dialog, which you reach with INSERT+V.

Getting Help

All Window-Eyes commands and information for using Window-Eyes with Excel 2007 are available in Section 21 of the Window-Eyes manual. The manual is typically installed as text files when you install Window-Eyes and is also available by doing the following:

1. Type CTRL+BACKSLASH to bring focus to the Window-Eyes program window.
2. Type ALT+H to open the Help menu.
3. Press ENTER on the first choice, Window-Eyes Manual. You are in a tree

view. 4. Find Section 21. The fastest way is to quickly type "21" without the quotes.

5. Press RIGHT ARROW to expand this section of the tree view.
6. Press DOWN ARROW until you reach the topic of interest.
7. Press ENTER.
8. Press F6 to read the topic you selected.
9. For additional information, either follow links in the topic text, or

press F6 to move back to the tree view and select a new topic. 10. Press ALT+F4 to exit the manual when you're finished.

Reading Cell Information

Command Keystroke Read the comment for the active cell ALT+SHIFT+C Read the formula for the active cell; press twice to spell the formula ALT+SHIFT+F Move focus back to the previously active cell ALT-SHIFT-P Route the mouse to the center of the active cell or selected object INSERT+NUMPAD PLUS Read the position of the active cell. If a defined header is found, only the defined header is read. If there is no defined header, the cell position is read. Press twice to read the cell position, along with any defined header. CTRL+SHIFT+N Read the data of the active cell; press twice to spell the contents, or 3 times to spell the contents phonetically CTRL+SHIFT+D Speak summary. Press once for cell information using verbosity settings and twice to hear all cell information. If a header is defined, it is read. CTRL+SHIFT+S Speak the range of cells that are selected, as well as which cell is currently active; press twice for additional information. IF the selection includes a defined header, the header is read. CTRL+SHIFT+M

Charts and Objects

Command Keystroke Move by major groups in a chart UP/DOWN ARROW Move within a group in a chart LEFT/RIGHT ARROW Read detailed information about the current chart element or, if it is selected, the entire chart INSERT+E

Element Properties Dialog

The Element properties dialog gives you detailed information about whatever you are focused on or have selected.

Command Keystroke Open Element Properties dialog INSERT+E Bring focus to the currently selected item and/or move the selection to that item ENTER or ALT+F List all comments contained in the current worksheet or workbook ALT+C List all hyperlinks contained in the current worksheet or workbook ALT+H List all objects contained in the current worksheet or workbook ALT+J List all named areas contained in the current worksheet or workbook ALT+A List all non-empty cells contained in the current column and their value constrained either by the current region or worksheet ALT+E List all non-empty cells contained in the current row and their value constrained either by the current region or worksheet ALT+L List individual pages and their corresponding cell range for either the current worksheet or workbook ALT+P List all monitor cells contained in the current worksheet or workbook ALT+N List all monitor cells contained in the current worksheet or workbook ALT+O List all charts contained in the current worksheet or workbook ALT+T Set current specified area to region ALT+R Set current specified area to worksheet (default setting) ALT+W Set current specified area to workbook ALT+K Read miscellaneous information for the current element ALT+I

Additional Commands

Command Keystroke Open Headers and Totals dialog ALT+SHIFT+H Open Monitor Cells dialog ALT+SHIFT+M Read Monitor Cell 1-10, as defined in the Monitor Cells dialog ALT+SHIFT+0-9 Open Read Monitor Cell dialog ALT+SHIFT+A

System Access Commands for Excel

Command Keystroke Activate a chart embedded in the active worksheet MODIFIER+ENTER Read the virtual status bar MODIFIER+PAGE DOWN Read the current selection MODIFIER+UP ARROW Read the sheet starting at the current cell MODIFIER+DOWN ARROW Create or read a monitor region MODIFIER+0-9 Modify or delete a monitor region SHIFT+MODIFIER+0-9 Read the title of the current column MODIFIER+C Read the current column ALT+MODIFIER+C Read the title of the current row ALT+MODIFIER+R Read the current row MODIFIER+R Add or delete a title range SHIFT+MODIFIER+T Display a dialog containing lists of cells with data, links, totals, and worksheets MODIFIER+F7

Appendix: Descriptions of SmartArt Graphics

List

Layout name Description Grouped List Use to show groups and sub-groups of information, or steps and sub-steps in a task, process, or workflow. Level

1

text corresponds to the top-level horizontal shapes, and Level 2 text corresponds to vertical sub-steps under each related top-level shape. Works well for emphasizing sub-groups or sub-steps, hierarchical information, or multiple lists of information. Basic Block List Use to show non-sequential or grouped blocks of information. Maximizes both horizontal and vertical display space for shapes. Bending Picture Accent List Use to show non-sequential or grouped blocks of information. The small circular shapes are designed to contain pictures. Works well for illustrating both Level 1 and Level 2 text. Maximizes both horizontal and vertical display space for shapes. Continuous Picture List Use to show groups of interconnected information. The circular shapes are designed to contain pictures. Detailed Process Use with large amounts of Level 2 text to show a progression through stages. Hierarchy List Use to show hierarchical relationships progressing across groups. Can also be used to group or list information. Horizontal Bullet List Use to show non-sequential or grouped lists of information. Works well with large amounts of text. All text has the same level of emphasis, and direction is not implied. Horizontal Picture List Use to show non-sequential or grouped information with an emphasis on related pictures. The top shapes are designed to contain pictures. Picture Accent List Use to show grouped or related information. The small shapes on the upper corners are designed to contain pictures. Emphasizes Level 2 text over Level 1 text, and is a good choice for large amounts of Level 2 text. Picture Caption List Use to show non-sequential or grouped blocks of information. The top shapes are designed to contain pictures and pictures are emphasized over text. Works well for pictures with short text captions. Pyramid List Use to show proportional, interconnected, or hierarchical relationships. Text appears in the rectangular shapes on top of the pyramid background. Segmented Process Use to show a progression or sequential steps in a task, process, or workflow. Emphasizes Level 2 text, since each line appears in a separate shape. Stacked List Use to show groups of information or steps in a task, process, or workflow. Circular shapes contain Level 1 text, and the corresponding rectangles contain Level 2 text. Works well for numerous details and minimal Level 1 text. Table Hierarchy Use to show groups of information built from top to bottom, and the hierarchies within each group. This layout does not contain connecting lines. Table List Use to show grouped or related information of equal value. The first Level 1 line of text corresponds to the top shape and its Level 2 text is used for the subsequent lists. Target List Use to show interrelated or overlapping information. Each of the first seven lines of Level 1 text appears in the rectangular shape. Unused text does not appear, but remains available if you switch layouts. Works well with both Level 1 and Level 2 text. Trapezoid List Use to show grouped or related information of equal value. Works well with large amounts of text. Vertical Arrow List Use to show a progression or sequential steps in a task, process, or workflow that move toward a common goal. Works well for bulleted lists of information. Vertical Block List Use to show groups of information or steps in a task, process, or workflow. Works well with large amounts of Level 2 text. A good choice for text with a main point and multiple sub-points. Vertical Box List Use to show several groups of information, especially groups with large amounts of Level 2 text. A good choice for bulleted lists of information. Vertical Bullet List Use to show non-sequential or grouped blocks of information. Works well for lists with long headings or top-level information. Vertical Chevron List Use to show a progression or sequential steps in a task, process, or workflow, or to emphasize movement or direction. Emphasizes Level 2 text over Level 1 text, and is a good choice for large amounts of Level 2 text. Vertical Picture Accent List Use to show non-sequential or grouped blocks of information. The small circles are designed to contain pictures. Vertical Picture List Use to show non-sequential or grouped blocks of information. The small shapes on the left are designed to contain pictures.

Process

Layout name Description Process List Use to show multiple groups of information or steps and sub-steps in a task, process, or workflow. Level

1

text corresponds to the top horizontal shapes, and Level 2 text corresponds to vertical sub-steps under each related top-level shape. Accent Process Use to show a progression, a timeline, or sequential steps in a task, process, or workflow. Works well for illustrating both Level 1 and Level 2 text. Alternating Flow Use to show groups of information or sequential steps in a task, process, or workflow. Emphasizes the interaction or relationships among the groups of information. Arrow Ribbon Use to show either related or contrasting concepts with some connection, such as opposing forces. The first two lines of Level 1 text are used for text in the arrows. Unused text does not appear, but remains available if you switch layouts. Basic Bending Process Use to show a progression or sequential steps in a task, process, or workflow. Maximizes both horizontal and vertical display space for shapes. Basic Chevron Process Use to show a progression; a timeline; sequential steps in a task, process, or workflow; or to emphasize movement or direction. Level 1 text appears inside an arrow shape while Level 2 text appears below the arrow shapes. Basic Process Use to show a progression or sequential steps in a task, process, or workflow. Basic Timeline Use to show sequential steps in a task, process, or workflow, or to show timeline information. Works well with both Level 1 and Level 2 text. Chevron List Use to show a progression through several processes that make up an overall

workflow. Also works for illustrating contrasting processes. The Level 1
text corresponds to the first arrow shape on the left, while the Level 2

text corresponds to horizontal sub-steps for each shape that contains Level 1 text. Circular Bending Process Use to show a long or non-linear sequence or steps in a task, process, or workflow. Works best with Level 1 text only. Maximizes both horizontal and vertical display space for shapes. Closed Chevron Process Use to show a progression, a timeline, or sequential steps in a task, process, or workflow, or to emphasize movement or direction. Can be used to emphasize information in the starting shape. Works best with Level 1 text only. Continuous Arrow Process Use to show a timeline or sequential steps in a task, process, or workflow. Works best with Level 1 text because each line of Level 1 text appears inside the arrow shape. Level 2 text appears outside the arrow shape. Continuous Block Process Use to show a progression or sequential steps in a task, process, or workflow. Works best with minimal Level 1 and Level 2 text. Continuous Picture List Use to show groups of interconnected information. The circular shapes are designed to contain pictures. Converging Arrows Use to show ideas or concepts that converge to a central point. Works best with Level 1 text only. Detailed Process Use with large amounts of Level 2 text to show a progression through stages. Diverging Arrows Use to show ideas or concepts that progress outward from a central source. Works best with Level 1 text only. Equation Use to show sequential steps or tasks that depict a plan or result. The last Level 1 line of text appears after the equals sign (=). Works best with Level 1 text only. Funnel Use to show the filtering of information or how parts merge into a whole. Emphasizes the final outcome. Can contain up to four lines of Level 1 text; the last of these four Level 1 text lines appears below the funnel and the other lines correspond to a circular shape. Unused text does not appear, but remains available if you switch layouts. Gear Use to show interlocking ideas. Each of the first three lines of Level 1 text corresponds to a gear shape, and their corresponding Level 2 text appears in rectangles next to the gear shape. Unused text does not appear, but remains available if you switch layouts. Opposing Arrows Use to show two opposing ideas, or ideas that diverge from a central point. Each of the first two lines of Level 1 text corresponds to an arrow. Unused text does not appear, but remains available if you switch layouts. Picture Accent Process Use to show sequential steps in a task, process, or workflow. The rectangular shapes in the background are designed to contain pictures. Process Arrows Use to show information illustrating a process or workflow. Level 1 text appears in the circular shapes and Level 2 text appears in the arrow shapes. Works best for minimal text and to emphasize movement or direction. Repeating Bending Process Use to show a progression or sequential steps in a task, process, or workflow. Maximizes both horizontal and vertical display space for shapes. Segmented Process Use to show a progression or sequential steps in a task, process, or workflow. Emphasizes Level 2 text, since each line appears in a separate shape. Staggered Process Use to show a downward progression through stages. Each of the first five lines of Level 1 text corresponds with a rectangle. Unused text does not appear, but remains available if you switch layouts. Upward Arrow Use to show a progression or steps that trend upward in a task, process, or workflow. Each of the first five lines of Level 1 text corresponds to a point on the arrow. Works best with minimal text. Unused text does not appear, but remains available if you switch layouts. Vertical Arrow List Use to show a progression or sequential steps in a task, process, or workflow that move toward a common goal. Works well for bulleted lists of information. Vertical Bending Process Use to show a progression or sequential steps in a task, process, or workflow. Maximizes both horizontal and vertical display space for shapes. Places more emphasis on the interrelationships among the shapes than on direction or movement. Vertical Chevron List Use to show a progression or sequential steps in a task, process, or workflow, or to emphasize movement or direction. Emphasizes Level 2 text over Level 1 text, and is a good choice for large amounts of Level 2 text. Vertical Equation Use to show sequential steps or tasks that depict a plan or result. The last Level 1 line of text appears after the arrow. Works best with Level 1 text only. Vertical Process Use to show a progression or sequential steps in a task, process, or workflow from top to bottom. Works best with Level 1 text, since the vertical space is limited.

Cycle

Layout name Description Basic Cycle Use to represent a continuing sequence of stages, tasks, or events in a circular flow. Emphasizes the stages or steps rather than the connecting arrows or flow. Works best with Level 1 text only. Basic Pie Use to show how individual parts form a whole. The first seven lines of Level 1 text correspond to the evenly distributed wedge or pie shapes. The top Level 1 text shape appears outside of the rest of the pie for emphasis. Unused text does not appear, but remains available if you switch layouts. Basic Radial Use to show the relationship to a central idea in a cycle. The first line of Level 1 text corresponds to the central shape, and its Level 2 text corresponds to the surrounding circular shapes. Unused text does not appear, but remains available if you switch layouts. Block Cycle Use to represent a continuing sequence of stages, tasks, or events in a circular flow. Emphasizes the stages or steps rather than the connecting arrows or flow. Continuous Cycle Use to represent a continuing sequence of stages, tasks, or events in a circular flow. Emphasizes the connection between all components. Works best with Level 1 text only. Cycle Matrix Use to show the relationship to a central idea in a cyclical progression. Each of the first four lines of Level 1 text corresponds to a wedge or pie shape, and Level 2 text appears in a rectangular shape to the side of the wedge or pie shape. Unused text does not appear, but remains available if you switch layouts. Diverging Radial Use to show relationships to a central idea in a cycle. The first Level 1 line of text corresponds to the central circular shape. Emphasizes the surrounding circles rather than the central idea. Unused text does not appear, but remains available if you switch layouts. Gear Use to show interlocking ideas. Each of the first three lines of Level 1 text corresponds to a gear shape, and their corresponding Level 2 text appears in rectangles next to the gear shape. Unused text does not appear, but remains available if you switch layouts. Multidirectional Cycle Use to represent a continuing sequence of stages, tasks, or events that can occur in any direction. Nondirectional Cycle Use to represent a continuing sequence of stages, tasks, or events in a circular flow. Each shape has the same level of importance. Works well when direction does not need to be indicated. Radial Cycle Use to show the relationship to a central idea. Emphasizes both information in the center circle and how information in the outer ring of circles contributes to the central idea. The first Level 1 line of text corresponds to the central circle, and its Level 2 text corresponds to the outer ring of circles. Unused text does not appear, but remains available if you switch layouts. Radial Venn Use to show both overlapping relationships and the relationship to a central idea in a cycle. The first line of Level 1 text corresponds to the central shape and the lines of Level 2 text correspond to the surrounding circular shapes. Unused text does not appear, but remains available if you switch layouts. Segmented Cycle Use to show a progression or a sequence of stages, tasks, or events in a circular flow. Emphasizes the interconnected pieces. Each of the first seven lines of Level 1 text corresponds to a wedge or pie shape. Unused text does not appear, but remains available if you switch layouts. Text Cycle Use to represent a continuing sequence of stages, tasks, or events in a circular flow. Emphasizes the arrows or flow rather than the stages or steps. Works best with Level 1 text only.

Hierarchy

Layout name Description Hierarchy Use to show hierarchical relationships progressing from top to bottom. Hierarchy List Use to show hierarchical relationships progressing across groups. Can also be used to group or list information. Horizontal Hierarchy Use to show hierarchical relationships progressing horizontally. Works well for decision trees. Horizontal Labeled Hierarchy Use to show hierarchical relationships progressing horizontally and grouped hierarchically. Emphasizes heading or level 1 text. The first line of Level 1 text appears in the shape at the beginning of the hierarchy, and the second and all subsequent lines of Level 1 text appear at the top of the tall rectangles. Labeled Hierarchy Use to show hierarchical relationships progressing from top to bottom and grouped hierarchically. Emphasizes heading or level 1 text. The first line of Level 1 text appears in the shape at the beginning of the hierarchy, and all subsequent lines of Level 1 text appear to the left of the tall rectangles. Organization Chart Use to show hierarchical information or reporting relationships in an organization. The assistant shape and the Org Chart hanging layouts are available with this layout. Table Hierarchy Use to show groups of information built from top to bottom, and the hierarchies within each group. This layout does not contain connecting lines.

Relationship

Layout name Description Equation Use to show sequential steps or tasks that depict a plan or result. The last Level 1 line of text appears after the equals sign (=). Works best with Level 1 text only. Arrow Ribbon Use to show either related or contrasting concepts with some connection, such as opposing forces. The first two lines of Level 1 text are used for text in the arrows. Unused text does not appear, but remains available if you switch layouts. Balance Use to compare or show the relationship between two ideas. Each of the first two lines of Level 1 text corresponds to text at the top of one side of the center point. Emphasizes Level 2 text, which is limited to four shapes on each side of the center point. The balance tips towards the side with the most shapes containing Level 2 text. Unused text does not appear, but remains available if you switch layouts. Basic Pie Use to show how individual parts form a whole. The first seven lines of Level 1 text correspond to the evenly distributed wedge or pie shapes. The top Level 1 text shape appears outside of the rest of the pie for emphasis. Unused text does not appear, but remains available if you switch layouts. Basic Radial Use to show the relationship to a central idea in a cycle. The first line of Level 1 text corresponds to the central shape, and its Level 2 text corresponds to the surrounding circular shapes. Unused text does not appear, but remains available if you switch layouts. Basic Target Use to show containment, gradations, or hierarchical relationships. The first five lines of Level 1 text are associated with a circle. Unused text does not appear, but remains available if you switch layouts. Basic Venn Use to show overlapping or interconnected relationships. The first seven lines of Level

1 text correspond with a circle. If there are four or fewer lines of Level
1

text, the text is inside the circles. If there are more than four lines of Level 1 text, the text is outside of the circles. Unused text does not appear, but remains available if you switch layouts. Continuous Picture List Use to show groups of interconnected information. The circular shapes are designed to contain pictures. Converging Arrows Use to show ideas or concepts that converge to a central point. Works best with Level 1 text only. Converging Radial Use to show relationships of concepts or components to a central idea in a cycle. The first line of Level 1 text corresponds to the central circular shape and the lines of Level 2 text correspond to the surrounding rectangular shapes. Unused text does not appear, but remains available if you switch layouts. Counterbalance Arrows Use to show two opposing ideas or concepts. Each of the first two lines of Level 1 text corresponds to an arrow and works well with Level 2 text. Unused text does not appear, but remains available if you switch layouts. Cycle Matrix Use to show the relationship to a central idea in a cyclical progression. Each of the first four lines of Level 1 text corresponds to a wedge or pie shape, and Level 2 text appears in a rectangular shape to the side of the wedge or pie shape. Unused text does not appear, but remains available if you switch layouts. Diverging Arrows Use to show ideas or concepts that progress outward from a central source. Works best with Level 1 text only. Diverging Radial Use to show relationships to a central idea in a cycle. The first Level 1 line of text corresponds to the central circular shape. Emphasizes the surrounding circles rather than the central idea. Unused text does not appear, but remains available if you switch layouts. Funnel Use to show the filtering of information or how parts merge into a whole. Emphasizes the final outcome. Can contain up to four lines of Level 1 text; the last of these four Level 1 text lines appears below the funnel and the other lines correspond to a circular shape. Unused text does not appear, but remains available if you switch layouts. Gear Use to show interlocking ideas. Each of the first three lines of Level 1 text corresponds to a gear shape, and their corresponding Level 2 text appears in rectangles next to the gear shape. Unused text does not appear, but remains available if you switch layouts. Grouped List Use to show groups and sub-groups of information, or steps and sub-steps in a task, process, or workflow. Level 1 text corresponds to the top-level horizontal shapes, and Level 2 text corresponds to vertical sub-steps under each related top-level shape. Works well for emphasizing sub-groups or sub-steps, hierarchical information, or multiple lists of information. Hierarchy List Use to show hierarchical relationships progressing across groups. Can also be used to group or list information. Linear Venn Use to show overlapping relationships in a sequence. Works best with Level 1 text only. Nested Target Use to show containment relationships. Each of the first three lines of

Level 1 text correspond to the upper left text in the shapes, and Level 2
text corresponds to the smaller shapes. Works best with minimal Level 2

lines of text. Unused text does not appear, but remains available if you switch layouts. Nondirectional Cycle Use to represent a continuing sequence of stages, tasks, or events in a circular flow. Each shape has the same level of importance. Works well when direction does not need to be indicated. Opposing Arrows Use to show two opposing ideas, or ideas that diverge from a central point. Each of the first two lines of Level 1 text corresponds to an arrow. Unused text does not appear, but remains available if you switch layouts. Picture Accent List Use to show grouped or related information. The small shapes on the upper corners are designed to contain pictures. Emphasizes Level 2 text over Level 1 text, and is a good choice for large amounts of Level 2 text. Radial Cycle Use to show the relationship to a central idea. Emphasizes both information in the center circle and how information in the outer ring of circles contributes to the central idea. The first Level 1 line of text corresponds to the central circle, and its Level 2 text corresponds to the outer ring of circles. Unused text does not appear, but remains available if you switch layouts. Radial List Use to show relationships to a central idea in a cycle. The center shape can contain a picture. Level 1 text appears in the smaller circles and any related Level

2

text appears to the side of the smaller circles. Radial Venn Use to show both overlapping relationships and the relationship to a central idea in a cycle. The first line of Level 1 text corresponds to the central shape and the lines of Level 2 text correspond to the surrounding circular shapes. Unused text does not appear, but remains available if you switch layouts. Segmented Pyramid Use to show containment, proportional, or interconnected relationships. The first nine lines of Level 1 text appear in the triangular shapes. Unused text does not appear, but remains available if you switch layouts. Works best with Level 1 text only. Stacked Venn Use to show overlapping relationships. A good choice for emphasizing growth or gradation. Works best with Level 1 text only. The first seven lines of Level 1 text correspond to a circular shape. Unused text does not appear, but remains available if you switch layouts. Table Hierarchy Use to show groups of information built from top to bottom, and the hierarchies within each group. This layout does not contain connecting lines. Target List Use to show interrelated or overlapping information. Each of the first seven lines of Level 1 text appears in the rectangular shape. Unused text does not appear, but remains available if you switch layouts. Works well with both Level 1 and Level 2 text. Vertical Equation Use to show sequential steps or tasks that depict a plan or result. The last Level 1 line of text appears after the arrow. Works best with Level 1 text only.

Matrix

Layout name Description Basic Matrix Use to show the relationship of components to a whole in quadrants. The first four lines of Level 1 text appear in the quadrants. Unused text does not appear, but remains available if you switch layouts. Grid Matrix Use to show the placement of concepts along two axes. Emphasizes the individual components rather than the whole. The first four lines of Level 1 text appear in the quadrants. Unused text does not appear, but remains available if you switch layouts. Titled Matrix Use to show the relationships of four quadrants to a whole. The first line of Level 1 text corresponds to the central shape, and the first four lines of Level 2 text appear in the quadrants. Unused text does not appear, but remains available if you switch layouts.

Pyramid

Layout name Description Basic Pyramid Use to show proportional, interconnected, or hierarchical relationships with the largest component on the bottom and narrowing up. Level 1 text appears in the pyramid segments and Level 2 text appears in shapes alongside each segment. Inverted Pyramid Use to show proportional, or interconnected, or hierarchical relationships with the largest component on the top and narrowing down. Level 1 text appears in the pyramid segments and Level 2 text appears in shapes alongside each segment. Pyramid List Use to show proportional, interconnected, or hierarchical relationships. Text appears in the rectangular shapes on top of the pyramid background. Segmented Pyramid Use to show containment, proportional, or interconnected relationships. The first nine lines of Level 1 text appear in the triangular shapes. Unused text does not appear, but remains available if you switch layouts. Works best with Level 1 text only.

??

??

??

??

35

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

• Follow-Ups:
  • Re: list of key strokes for Excel
    • From: Dave Durber

• References:
  • list of key strokes for Excel
    • From: tom behler
  • Re: list of key strokes for Excel
    • From: Dave Carlson
  • Re: list of key strokes for Excel
    • From: tom behler
  • Re: list of key strokes for Excel
    • From: Adrian Spratt
  • Re: list of key strokes for Excel
    • From: Dave Durber

Other related posts:

• » list of key strokes for Excel- tom behler
• » Re: list of key strokes for Excel- Dave Carlson
• » Re: list of key strokes for Excel- G.W. Cox
• » Re: list of key strokes for Excel- Dave Carlson
• » Re: list of key strokes for Excel- Dave Carlson
• » Re: list of key strokes for Excel- tom behler
• » Re: list of key strokes for Excel- tom behler
• » Re: list of key strokes for Excel- Adrian Spratt
• » Re: list of key strokes for Excel- tom behler
• » Re: list of key strokes for Excel- Soronel Haetir
• » Re: list of key strokes for Excel- Ann Byrne
• » Re: list of key strokes for Excel- Dave Durber
• » Re: list of key strokes for Excel - Adrian Spratt
• » Re: list of key strokes for Excel- Dave Durber
• » RE: list of key strokes for Excel- Pat L
• » RE: list of key strokes for Excel- Ann Byrne
• » Re: list of key strokes for Excel- tom behler
• » Re: list of key strokes for Excel- Marc Rocheleau
• » Re: list of key strokes for Excel- Soronel Haetir
• » Re: list of key strokes for Excel- Dave Carlson
• » Re: list of key strokes for Excel- The Scarlet Wombat
• » RE: list of key strokes for Excel- George B
• » Re: list of key strokes for Excel- 1SmartDog@xxxxxxx
• » RE: list of key strokes for Excel- Cy Selfridge

1. Home
2. jfw
3. Archive
4. 02-2010

---

• » Previous by Date
• » Next by Date
• » Related Posts
• » View list details
• » Manage your subscription

---