Microsoft Excel with a screen reader: keyboard shortcuts

A quick reference for using Excel for Windows with JAWS or NVDA, with Mac equivalents where they are simple. It covers moving around a sheet, selecting, entering data and formulas, formatting, rows and columns, tables and filters, and setting up header reading.

Or use your browser’s Print command (Control + P, or Command + P on a Mac).

These shortcuts are for Microsoft Excel on Windows (Microsoft 365) with JAWS or NVDA. Where the Mac version is different and simple, it is shown too. In this guide, Insert means the JAWS key or the NVDA key. Excel is not a web page, so you do not need the virtual cursor or browse mode: both screen readers read each cell as you arrow to it and announce its address, such as B4, and the Control + Alt + Arrow table commands from the web are not needed. Some commands take more than one step through the ribbon: "Alt + H, then O, then I" means press Alt + H, let go, then press O and then I. Shortcuts that use a symbol, such as Control + Shift + 4, are for the US English keyboard and may differ on other layouts.

Moving around

To do thisPress
Move one cell up, down, left or rightThe arrow keys
Move to the edge of the current block of dataControl + an arrow key (Mac: Command + an arrow key)
Move to cell A1, the start of the sheetControl + Home (Mac: Fn + Control + Left Arrow)
Move to the last cell that has been usedControl + End (Mac: Fn + Control + Right Arrow)
Move down or up one screenPage Down or Page Up
Move to the next or previous worksheetControl + Page Down or Page Up (Mac: Option + Right Arrow or Left Arrow)
Open Go To, then type a cell address such as C10 or a range nameF5 or Control + G
Move to the next cell in the row, or back to the previous oneTab or Shift + Tab
Finish the cell and move down to the next row, or back upEnter or Shift + Enter

Selecting

To do thisPress
Extend the selection by one cellShift + an arrow key
Extend the selection to the edge of the dataControl + Shift + an arrow key
Select the whole columnControl + Space
Select the whole rowShift + Space
Select the current block of data; press again for the whole sheetControl + A (Mac: Command + A)

Entering and editing

To do thisPress
Edit the cell you are on without clearing itF2 (Mac: Control + U)
Cancel what you are typing and keep the old contentsEscape
Start a new line inside the same cellAlt + Enter
Fill every selected cell with what you have typedControl + Enter
Copy the cell above into the selected cells (fill down)Control + D
Copy the cell on the left into the selected cells (fill right)Control + R
Clear the contents of the selected cellsDelete
Enter today's dateControl + Semicolon
Enter the current timeControl + Shift + Semicolon
Undo or redoControl + Z or Control + Y (Mac: Command + Z or Command + Y)

Formulas

To do thisPress
Start a formulaEquals
Add up the numbers above or to the left (AutoSum)Alt + Equals (Mac: Command + Shift + T)
Switch a cell reference between relative and absolute while editing, for example A1 to $A$1F4 (Mac: Command + T)
Open the Insert Function dialogShift + F3
Show formulas instead of results on the sheet, or show results againControl + Grave (the key under Escape)
Recalculate all open workbooksF9

Formatting

To do thisPress
Make the selection bold, italic or underlinedControl + B, Control + I or Control + U (Command on the Mac)
Open the Format Cells dialogControl + 1 (Mac: Command + 1)
Apply currency format with two decimal placesControl + Shift + 4 (the dollar sign)
Apply percentage format with no decimal placesControl + Shift + 5 (the percent sign)
Apply number format with two decimal places and a thousands separatorControl + Shift + 1
Apply date format with the day, month and yearControl + Shift + 3 (the hash sign)
Make the column as wide as its longest entry (AutoFit)Alt + H, then O, then I

Rows, columns and sheets

To do thisPress
Insert cells, rows or columns (inserts at once when a whole row or column is selected)Control + Shift + Plus
Delete the selected cells, rows or columnsControl + Minus
Hide the selected rows or columnsControl + 9 or Control + 0
Unhide the rows or columns inside the selection (Control + Shift + 0 does not work on every keyboard; use the ribbon instead)Control + Shift + 9 or Control + Shift + 0
Insert a new worksheetShift + F11
Rename the current worksheetAlt + H, then O, then R
Open the context menu for the selected cellsShift + F10 or the Applications key

Tables and filters

To do thisPress
Turn the current block of data into a table with filter buttonsControl + T
Turn filter buttons on or off for the header rowControl + Shift + L
Open the filter and sort menu for the column you are on (from a header cell)Alt + Down Arrow
Move through the filter menu and check or uncheck itemsTab, the arrow keys and Space

Screen reader settings and reading

If your sheet has a header row or a header column, tell the screen reader where it is and it will read the header before each cell as you move. Go to the cell where the header row and header column meet, usually A1, then press the keys for your screen reader. NVDA clears the setting if you press the same keys again.

To do thisPress
Hear the current cell again, with its addressInsert + Tab
Set the column headers row (JAWS)Insert + Control + Alt + C
Set the row headers column (JAWS)Insert + Control + Alt + R
Set the column headers row (NVDA)Insert + Shift + C
Set the row headers column (NVDA)Insert + Shift + R
Hear the font, color and number format of the cellInsert + F

Tip: defining the header row and column takes a few seconds and makes a long sheet much easier to follow, because every cell is read as "Total, March, 450" instead of just "450". For the full list of Excel shortcuts, press Alt + Q, type "keyboard shortcuts" and choose the help article.

Back to the cheat sheet