JAWS hotkeys for Microsoft Excel

JAWS hotkeys for Microsoft Excel

Information

Below hotkeys provided by JAWS for using Microsoft Excel.

Informational Keystrokes for Columns

Description Command
List cells in current column INSERT+SHIFT+C
Read column total INSERT+NUM PAD ENTER
Say column title INSERT+ALT+SHIFT+C
Set column titles to row INSERT+ALT+CTRL+C
Set current column to the column containing row totals CTRL+INSERT+ENTER

Informational Keystrokes for Rows

Description Command
List cells in current row INSERT+SHIFT+R
Read row total INSERT+DELETE
Say row title INSERT+ALT+SHIFT+R
Set row titles to column INSERT+ALT+CTRL+R
Set current row to the row containing column totals CTRL+INSERT+DELETE

Table Layer Keystrokes

Table layer keystrokes offer a fast and convenient way to navigate tables. The table layer eliminates the need to have to hold down several keys at once to perform a table navigation command.

Below is a list of the layered keystrokes for table navigation. Press and release INSERT+SPACEBAR, followed by T to activate the table layer, and then press any of the following keystrokes.

Description Command
Read first cell in current column. ALT+1
Read second cell in current column. ALT+2
Read third cell in current column. ALT+3
Read fourth cell in current column. ALT+4
Read first cell in current row. CTRL+1
Read second cell in current row. CTRL+2
Read third cell in current row. CTRL+3
Read fourth cell in current row. CTRL+4

Miscellaneous Informational Keystrokes

Description Command
Open custom summary label manager INSERT+CTRL+TAB
Open custom summary when one exists INSERT+CTRL+SHIFT+TAB
Describe cell border ALT+SHIFT+B
List 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 current cell validation input message CTRL+SHIFT+V
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 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 INSERT+CTRL+F2
Read spelling error and suggestion **INSERT+F7 **
Display detailed cell appearance information INSERT+TAB twice quickly

Navigation Keystrokes

Description Command
Move to prior screen in spreadsheet ALT+PAGE UP
Move to next screen in spreadsheetALT+PAGE DOWN
Next Sheet CTRL+PAGE DOWN
Prior Sheet CTRL+PAGE UP
Move to first cell in region ALT+SHIFT+HOME
Move to last cell in region ALT+SHIFT+END
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
Insert CellMarker INSERT+WINDOWS Key+K
Move to CellMarker on current worksheet ALT+WINDOWS Key+K
Move to CellMarker on next worksheet CTRL+WINDOWS Key+K
Move to CellMarker on previous worksheet CTRL+WINDOWS Key+SHIFT+K
List all CellMarkers in workbook CTRL+ALT+WINDOWS Key+K

Selection Keystrokes

Description Command
Select column CTRL+SPACEBAR
Select hyperlink INSERT+F7
Select region CTRL+SHIFT+8
Select a region and announce the region's cell range CTRL+SHIFT+SPACEBAR
Select row SHIFT+SPACEBAR
Select worksheet objects CTRL+SHIFT+O
Read the current worksheet object **INSERT+CTRL+C **
Select the first worksheet object INSERT+ALT+C
Collapse selection to current cell **SHIFT+BACKSPACE **

Configuration Keystrokes

Description Command
Set monitor cell INSERT+SHIFT+1 through INSERT+SHIFT+0
Note: If a monitor cell was previously set and you then try to set that cell again, a message appears letting you know that you are about to overwrite the existing monitor cell. You have the option to cancel or continue and overwrite the monitor cell.
Read monitor cell ALT+SHIFT+1 through **ALT+SHIFT+0 **
Create or edit cell comment **SHIFT+F2 **
Formula input mode EQUALS
AutoSum ALT+EQUALS
Date stamp CTRL+SEMICOLON
Time stamp **CTRL+SHIFT+SEMICOLON **
Close Office Assistant CTRL+INSERT+F4

your title goes here

The Office Assistant is not available in Microsoft Office 2007 or later.

    • Related Articles

    • JAWS - Set up automatic column title and row title reading in Excel

      Problem A JAWS customer wishes to have row or column titles read back as they navigate with arrow keys in an Excel worksheet. Resolution JAWS can be made to speak row and column titles in Excel documents when navigating from cell to cell. This can be ...

    • JAWS – Make JAWS read Excel column/row titles using named ranges

      Problem A customer wishes to have JAWS automatically read out Excel column/row titles in an Excel file. Resolution It is possible by insertion of named ranges to have JAWS automatically read row or column titles, when created and saved will enable ...

    • Microsoft Office - Hotkey shortcuts

      Problem A customer using Microsoft Office who needs to operate the software using hotkey shortcuts needs to locate relevant hotkey information. Applies to Microsoft Office Resolution Please find below hotkey information for Microsoft Office ...

    • JAWS – Microsoft office ribbon accelerator keys do not always work

      Problem A JAWS customer using Microsoft Office applications find that sometimes when they use the Microsoft Office ribbon accelerator keystrokes, they do not always work or function as expected. Applies to JAWS Fusion Resolution The Microsoft Office ...

    • JAWS - Microsoft Teams hotkeys

      Problem A customer who needs to use Microsoft Teams would like to know the relevant hotkeys for the app. Resolution Below are a list of general hotkeys for Microsoft Teams app: Microsoft Teams hotkeys To do this Desktop App Web App Accept video call ...