The following list of hotkeys contains hotkeys for using Window-Eyes with Excel 2007 as well as Microsoft hotkeys. This list was created by GW Micro to help Window-Eyes customers navigate Office 2007. If you have technical questions regarding Window-Eyes, you should contact GW Micro at (260) 489-3671, or at support@gwmicro.com. If you have technical questions regarding Office 2007, you should contact Microsoft (www.microsoft.com). GW Micro can answer questions regarding Window-Eyes, but GW Micro cannot answer your questions regarding Office 2007 applications. For training solutions for using Window-Eyes with Office 2007, please check out our Window-Eyes Training classes at www.gwmicro.com/training. For more information about Window-Eyes, call (260) 489-3671, visit GW Micro on the web at www.gwmicro.com or send an email to sales@gwmicro.com. The following information should not be copied, used, or distributed in any way without express written permission from GW Micro. Window-Eyes Commands for Microsoft Excel 2007: Alt-Shift-C = Read comment. This will read the comment for the active cell. Alt-Shift-F = Read formula. When pressed once, this hot key will read the formula for the active cell. When pressed twice, this hot key will spell the formula for the active cell. Alt-Shift-P = Previous cell. This hot key will move focus back to the cell that was active before the current cell became active. F2 = The is an Excel hotkey that allows you to edit the current cell. Ins-Numpad plus = Mouse To Focus. When pressed, Window-Eyes will route the mouse to the center of the active cell or selected object. Ctrl-Shift-N = Field name. When pressed, Window-Eyes will read the position of the active cell. The second press of this hot key will always read the cell position, along with any defined header. Ctrl-Shift-D = Field data. When pressed, Window-Eyes will read the data of the active cell. The second press will spell the contents. The third press will spell the contents phonetically. Ctrl-Page up/Ctrl-page down = Excel hot keys that move backward and forward through the worksheets of the current workbook. Ctrl-Shift-S = Speak sumamry. When pressed once, Window-Eyes will speak the cell information using the current verbosity options. When pressed a second time, Speak Summary will speak cell information forcing all verbosity options on for the current worksheet (note that only those elements that exist will be spoken). Ctrl-Shift-M = Highlighted block. When pressed, Window-Eyes will speak the range of cells that are selected, as well as which cell is currently active. Alt-Shift-H = Headers and totals. Alt-Shift-T = Read total cell. This hotkey will automatically read the toatl cell defined in the Headers and Totals dialog. Alt-Shift-M = Monitor cells. Alt-Shift-0 through Alt-Shift-9 = Monitor cell 1-10. Alt-Shift-A = Any monitor cell. Ctrl-Shift-? = Application specific help. Ins-tab = Page navigation. Alt-C = Lists all comments. Alt-H = Lists all hyperlinks. Alt-J = Lists all objects. Alt-A = Lists all named areas. Alt-E = Cells in columns. Alt-L = Cells in rows. Alt-P = Lists individual pages and their corresponding cell range. Alt-N = Lists all moniotr cells. Alt-O = Lists all worksheets. Alt-T = Lists all charts. Microsoft Excel 2007 commands: Ctrl-N = New workbook. Opens a new workbok. Ctrl-O = Open workbook. Opens a saved workbook. Ctrl-P = Print. Prints workbook. Ctrl-S = Save. Saves current workbook. Ctrl-W = Close. Closes current workbook. Ctrl-T = Create table. Ctrl-Z = Undo. Undoes last move. Ctrl-Y = Repeat. Repeats last move. Ctrl-F = Open find dialog box Ctrl-K = Insert hyperlink. Ctrl-C = Copy. Copies selected text. Ctrl-X = Cut. Removes selected text. Ctrl-V = Paste. Pastes copied text. Ctrl-B = Bold. Bolds selected text. Ctrl-I = Italics. Italicizes selected text. Ctrl-U = Underline. Underlines selected text. Ctrl-A = Select all. Selects all text in the document. Ctrl-G = Go to. Moves to specified cell. To access the ribbon: Alt-F = Office button Alt-H = Home tab Alt-N = Insert tab Alt-P = Page Layout tab Alt-M = Formulas tab Alt-A = Data tab Alt-R = Review tab Alt-W = View tab Quick Access icons (These are the default settings for Microsoft Excel. There are more icons available, and they can be arranged in any order. The order that they are in the Access bar will correspond with Alt-1, Alt-2, Alt3, etc.) Alt-1 = Save Alt-2 = Undo Alt-3 = Redo Office button: Alt-F, then N = New workbook. Alt-F, then O = Open previously saved workbook. Alt-F, then S = Save current workbook. Alt-F, then A = Save as, for current workbook. Alt-F, then F, then X = Excel workbook. Save file in default format. Alt-F, then F, then M = Excel macro-enabled workbook. Alt-F, then F, then B = Excel binary workbook. Alt-F, then F, then 9 = Excel 97-2003 workbook. Alt-F, then F, then F = Find add-ins for other file formats. Alt-F, then F, then O = Other formats. Alt-F, then P = Print. Opens print dialog box. Alt-F, then W, then P = Print. Alt-F, then W, then Q = Quick print. Alt-F, then W, then V = Print preview. Alt-F, then E, then P = Properties. Alt-F, then E, then I = Inspect document. Alt-F, then E, then E = Encrypt document. Alt-F, then E, then S = Add a digital signature. Alt-F, then E, then F = Mark as final. Alt-F, then E, then C = Run compatibility checker. Alt-F, then D, then E = Send as e-mail. Alt-F, then D, then X = Send as internet fax. Alt-F, then U, then D = Document management server. Alt-F, then U, then C = Create document workspace. Alt-F, then C = Close. Alt-F, then I = Excel options. Alt-F, then X = Exit. Home tab: Alt-H, then V, then P = Paste. Alt-H, then X = Cut. Alt-H, then C = Copy. Alt-H, then F, then P = Format Painter. Alt-H, then F, then O = Go to clipboard. Alt-H, then F, then F = Font name. Alt-H, then F, then S = Font size. Alt-H, then F, then G = Increases font size. Alt-H, then F, then K = Decreases font size. Alt-H, then 1 = Bold. Alt-H, then 2 = Italics. Alt-H, then 3 = Underline Alt-H, then B = Border. Alt-H, then H = Fill color. Alt-H, then F, then C = Font color Alt-H, then F, then N = Font dialog box. Alt-H, then A, then T = Align top. Alt-H, then A, then M = Align middle. Alt-H, then A, then B = Align bottom. Alt-H, then A, then L = Align left. Alt-H, then A, then C = Align center. Alt-H, then A, then R = Align right. Alt-H, then F, then Q = Orientation. Rotate text to a diagonal angle or vertical orientation. Alt-H, then 5 = Decrease indent (Alternate shortcut: Ctrl-Alt-Shift-Tab) Alt-H, then 6 = Increase indent (Alternate shortcut: Ctrl-Alt-Tab) Alt-H, then W = Wrap text. Alt-H, then M, then C = Merge and center. Joins the selected cells into one cell and centers the text. Alt-H, then M, then A = Merge across. Alt-H, then M, then M = Merge cells. Merge the selected cells into one cell. Alt-H, then M, then U = Unmerge cells. Split the selected cells into multiple new cells. Alt-H, then F, then A = Font alignment dialog box. Alt-H, then N = Number format. Alt-H, then A, then N = Accounting number format. Alt-H, then P = Percent style. (Alternate shortcut: Ctrl-Shift-%) Alt-H, then K = Comma style. Alt-H, then 0 = Decrease decimal. Alt-H, then 9 = Increase decimal. Alt-H, then F, then N = Format Cells: number. Alt-H, then L = Conditional formatting. Alt-H, then T = Format as table. Alt-H, then J = Cell styles. Alt-H, then I = Incert cells. Alt-H, then D = Delete cells. Alt-H, then O = Format. Alt-H, then U = Autosum. (Alternate shortcut: Alt + =) Alt-H, then F, then I = Fill. Continue a pattern into one or more adjacent cells. Alt-H, then E = Clear. Clear the contents of the cell. Alt-H, then S = Sort and filter. Arrange data so that it is easier to analyze. Alt-H, then F, then D = Find and select. Find and select specific text, formatting, or type of information within a workbook. Insert Tab Alt-N, then V, then T = PivotTable. Alt-N, then V, then C = PivotChart. Alt-N, then T = Table. Creates a table. Alt-N, then P = Picture. Insert a picture from a file. Alt-N, then F = Clip art. Insert clip art into the workbook. Alt-N, then S, then H = Shapes. Insert a shape into the workbook. Alt-N, then M = SmartArt. Insert a SmartArt graphic into the workbook. Alt-N, then C = Column. Insert a column chart. Alt-N, then N = Line. Insert a line chart. Alt-N, then E = Pie. Insert a pie chart. Alt-N, then B = Bar. Insert a bar chart. Alt-N, then A = Area. Insert an area chart. Alt-N, then D = Scatter. Insert a scatter chart, also known as an XY chart. Alt-N, then O = Other charts. Insert a stock, surface, doughnut, bubble, or radar chart. Alt-N, then K = Create chart. Opens chart dialog box. Alt-N, then I = Insert hyperlink. Create a link to a webpage, a picture, an e-mail address, or a program. Alt-N, then X = Text box. Insert a text box that can be positioned anywhere on the page. Alt-N, then H = Header and footer. Edit the header or footer of the document. Alt-N, then W = WordArt. Insert decorative text into your workbook. Alt-N, then G = Signature line. Insert a signature line that specifies the individual that must sign. Alt-N, then J = Object. Insert an embedded object. Alt-N, then U = Symbols. Insert characters that are not on your keyboard, such as copyright symbols, trademark symbols, paragraph marks, and Unicode characters. Page Layout tab Alt-P, then T, then H = Themes. Alt-P, then T, then C = colors. Alt-P, then T, then F = Fonts. Alt-P, then T, then E = Effects. Alt-P, then M = Margins. Select the margin sizes for the entire document or the current selection. Alt-P, then O = Orientation. Switch the pages between portrait and landscape layouts. Alt-P, then S, then Z = Paper size. Choose a paper size for the current selection. Alt-P, then R, then S = Set print area. Alt-P, then R, then C = Clear print area. Alt-P, then B, then I = Insert breaks. Alt-P, then B, then R = Remove breaks. Alt-P, then G = Background. Choose an image to display as the background of the sheet. Alt-P, then I = Print titles. Specify rows and columns to repeat on each printed page. Alt-P, then S, then P = Page setup. Alt-P, then W = Width. Shrink the width of printed output to fit a maximum number of pages. Alt-P, then H = Height. Shirnk the height of printed output to fit a maximum number of pages. Alt-P, then X = Scale. Stretch or shrink the printed output to a percentage of its actual size. Alt-P, then V, then G = View gridlines. Show the lines between rows and columns in the sheet to make editing and reading easier. Alt-P, then P, then G = Print gridlines. Print the lines between rows and columns in the sheet to make reading easier. Alt-P, then V, then H = View headings. Show row and column headings. Alt-P, then P, then H = Print headings. Print row and column headings. Alt-P, then S, then O = Sheet options. Opens sheet dialog box. Alt-P, then A, then F = Bring to front. Bring the selected object forward one level or to the front of all objects. Alt-P, then A, then E = Send to back. Send the selected object back one level or the back of all objects. Alt-P, then A, then P = Selection pane. Show the selection pane to help select individual objects and to change their order and visibility. Alt-P, then A, then A = Align. Align the edges of multiple selected objects. Alt-P, then A, then G = Group. Group objects together so that they can be treated like a single object. Alt-P, then A, then Y = Rotate. Rotate or flip the selected object. Formulas Tab Alt-M, then F = Insert function. (Alternate shortcut: Shift-F3) Edit the formula in the current cell by choosing functions and editing the arguments. Alt-M, then U, then S = Sum. (Alternate shortcut: Alt-=) Display the sum of the selected cells directly after the selected cells. Alt-M, then U, then A = Average. Alt-M, then U, then C = Count numbers. Alt-M, then U, then M = Max. Alt-M, then U, then I = Min. Alt-M, then U, then F = More functions. Alt-M, then R = Recently used. Browse and select from a list of recently used functions. Alt-M, then I = Financial. Browse and select from a list of financial functions. Alt-M, then L = Logical. Browse and select from a list of logical functions. Alt-M, then T = Text. Browse and select from a list of text functions. Alt-M, then E = Date and time. Browse and select from a list of date and time functions. Alt-M, then O = Lookup and reference. Browse and select from a list of lookup and reference functions. Alt-M, then G = Math and trigonometry. Browse and select from a list of math and trigonometry functions. Alt-M, then Q = More functions. Browse and select from lists of statistical, engineering, cube, and information functions. Alt-M, then N = Name manager. (Alternate shortcut: Ctrl-F3) Alt-M, then M, then D = Define names. Name cells so that you can refer to them in formulas by that name. Alt-M, then M, then A = Apply names. Alt-M, then S = Use in formula. Choose a name used in this workbook and insert it into the current formula. Alt-M, then C = Create from selection. (Alternate shortcut: Ctrl-Shift-F3) Automatically generate names from the selected cells. Alt-M, then P = Trace precedents. Show arrows that indicate what cells affect the value of the currently selected cell. Alt-M, then D = Trace dependents. Show arrows that indicate what cells are affected by the value of the currently selected cell. Alt-M, then A, then A = Remove arrows. Remove the arrows drawn by trace precedents or trace dependents. Alt-M, then A, then P = Remove precedent arrows. Alt-M, then A, then D = Remove dependent arrows. Alt-M, then H = Show formulas. (Alternate shortcut: Ctrl-`) Display the formula in each cell instead of the resulting value. Alt-M, then K, then K = Error checking. Check for common errors that occur in formulas. Alt-M, then K, then E = Trace error. Alt-M, then K, then C = Circular references. Alt-M, then V = Evaluate formula. Launch the evaluate formula dialog box to debug a formula by evaluating each part of the formula individually. Alt-M, then W = Watch window. Monitors the values of certain cells as changes are made to the sheet. Alt-M, then X, then A = Calculation options, automatic. Specify when formulas are calculated. Alt-M, then x, then E = Automatic, except for data tables. Alt-M, then X, then M = Manual. Alt-M, then B = Calculate now. (Alternate shortcut: F9) Calculate the entire workbook now. Alt-M, then J = Calculate sheet. (Alternate shortcut: Shift-F9) Calculate the current sheet now. Data Tab Alt-A, then F, then A = Get external data from access. Import data from a Microsoft Access database. Alt-A, then F, then W = Get external data from the webl. Import data from a web page. Alt-A, then F, then T = Get external data from text. Import data from a text document. Alt-A, then F, then O = Get external data from other sources. Import data from other data sources. Alt-A, then X = Get external data using an existing connection. Connect to an external data source by selecting from a list of commonly used sources. Alt-A, then R, then A = Refresh all. (Alternate shortcut: Ctrl-Alt-F5) Update all of the information in the workbook that is coming from a data source. Alt-A, then R, then R = Refresh. Alt-A, then R, then S = Refresh status. Alt-A, then R, then C = Cancel refresh. Alt-A, then R, then O = Refresh properties. Alt-A, then O = Connections. Display all data connections for the workbook. Alt-A, then P = Data range properties. Alt-A, then K = Edit links. view all of the other files this spreasheet is linked to so that you can update or remove the links. Alt-A, then A = Sort A to Z. Sort the selection so that the lowest values are at the top of the column. Alt-A, then D = Sort Z to A. Sort the selection so that the highest values are at the top of the column. Alt-A, then S = Sort. Launch the sort dialog box to sort data based on several criteria at once. Alt-A, then T = Filter. (Alternate shortcut: Ctrl-Shift-L) Enable filtering of the selected cells. Alt-A, then C = Clear. Clear the filter and sort state for the current range of data. Alt-A, then Y = Reapply. (Alternate shortcut: Ctrl-Alt-L) Reapply the filter and sort in the current range. Alt-A, then Q = Advanced. Specify complex criteria to limit which records are included in the result set of a query. Alt-A, then E = Text to columns. Separate the contents of one Excel cell into separate columns. Alt-A, then M = Remove duplicates. Delete duplicate rows from a sheet. Alt-A, then V, then V = Data validation. Prevent invalid data from being entered into the cell. Alt-A, then V, then I = Circle invalid data. Alt-A, then V, then R = Clear validation circles. Alt-A, then N = Consolidate. Combine values from multiple ranges into one new range. Alt-A, then W, then S = What-if analysis, scenario manager. Alt-A, then W, then G = Goal seek. Alt-A, then W, then T = Data table. Alt-A, then G, then G = Group. (Alternate shortcut: Shift-Alt-Right) Tie a range of cells together so that they can be collapsed or expanded. Alt-A, then G, then A = Auto-outline. Alt-A, then U, then U = Ungroup. (Alternate shortcut: Shift-Alt-Left) Ungroup a range of cells that were previously grouped. Alt-A, then U, then C = Clear outline. Alt-A, then B = Subtotal. Total several rows of related data together by automatically inserting subtotals and totals for the selected cells. Alt-A, then J = Show detail. Expand a collapsed group of cells. Alt-A, then H = Hide detail. Collapse a group of cells. Alt-A, then L = Open settings dialog box. Review Tab Alt-R, then S = Spelling. (Alternate shortcut: F7) Check the spelling of the text. Alt-R, then R = Research. (Alternate shortcut: Alt-click) Open the research task pane to search through reference materials, such as dictionaries, encyclopedias, and translation services. Alt-R, then E = Thesaurus. Suggests other words with a similar meaning to the word you have selected. Alt-R, then L = Translate. Translate the selected text into a different language. Alt-R, then C = New comment. (Alternate shortcut: Shift-F2) Add a comment about the selection. Alt-R, then D = Delete comment. Delete the selected comment. Alt-R, then V = Previous comment. Select the previous comment in the sheet. Alt-R, then N = Next comment. Navigate to the next comment in the sheet. Alt-R, then H = Show/Hide comments. Show or hide the comment attached to the selected cell. Alt-R, then A = Show all comments. Display all comments in the sheet. Alt-R, then I = Show Ink. Show or hide any ink annotations in the sheet. Alt-R, then P, then S = Protect sheet. Prevent unwanted changes to the data in a sheet by specifying what information can be changed. Alt-R, then P, then W = Protect workbook. Prevent unwanted changes to the structure of the workbook, such as moving, deleting, or adding sheets. Alt-R, then W = Share workbook. Allow multiple people to work in a workbook at the same time. Alt-R, then O = Protect and share workbook. Share the workbook and protect it with a password at the same time. Alt-R, then U = Allow users to edit ranges. Allows specific people to edit ranges of cells in a protected workbook or sheet. Alt-R, then G, then H = Track changes, highlight changes. Track all changes made to the document, including insertions, deletions, and formatting changes. Alt-R, then G, then C = Accept/reject changes. View Tab Alt-W, then L = Normal view. View the document in normal view. Alt-W, then P = Page Layout. View the document as it will appear on the printed page. Alt-W, then I = Page break preview. View a preview of where pages will break when this document is printed. Alt-W, then C = Custom views. Save a set of display and print settings as a custom view. Alt-W, then E = Full screen. View the document in full screen mode. Alt-W, then R = Ruler. View the rulers, used to measure and line up objects in the document. Alt-W, then V, then G = Gridlines. Show the lines between rows and columns in the sheet to make editing and reading easier. Alt-W, then D = Message bar. Open the message bar to complete any required actions on the document. Alt-W, then V, then F = Formula bar. View the formula bar, in which you can enter text and formulas into cells. Alt-W, then V, then H = Headings. Show row and column headings. Alt-W, then Q = Zoom. Open the zoom dialog box to specify the zoom level of the document. Alt-W, then J = 100%. Zoom the document to 100% of the normal size. Alt-W, then G = Zoom to selection. Zoom the worksheet so that the currently selected range of cells fills the entire window. Alt-W, then N = New window. Open a new window containing a view of the current document. Alt-W, then A = Arrange all. Tile all open program windows side-by-side on the screen. Alt-W, then F, then F = Freeze panes. Keep rows and columns visible while the rest of the worksheet scrolls (based on current selection). Alt-W, then F, then R = Freeze top row. Keep the top row visible while scrolling through the rest of the worksheet. Alt-W, then F, then C = Freeze first column. Keep the first column visible while scrolling through the rest of the worksheet. Alt-W, then S = Split. Split the window into multiple resizable panes containing views of your worksheet. Alt-W, then H = Hide. Hide the current window so that it cannot be seen. Alt-W, then U = Unhide. Unhide any windows hidden by the Hide Window feature. Alt-W, then B = View side-by-side. View two worksheets side-by-side so that you can compare their contents. Alt-W, then V, then S = Synchronous scrolling. Synchronize the scrolling of two documents so that they scroll together. Alt-W, then T = Reset window position. Reset the window position of the documents being compared side-by-side so that they share the screen equally. Alt-W, then K = Save workspace. Save the current layout of all windows as a workspace so that it can be restored later. Alt-W, then W, then 1 = Switch windows. Switch to a different currently open window. (The number in the shortcut corresponds to the number of each individual window) Alt-W, then M, then V = View macros. (Alternate shortcut: Alt-F8) View the list of macros, from which you can run, create, or delete a macro. Alt-W, then M, then R = Record macros. Each of the commands that you perform will be saved into the macro so that you can play them back again. Alt-W, then M, then U = Use relative references. Use relative references so that macros are recorded with actions relative to the initial selected cell.