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 this
Press
Move one cell up, down, left or right
The arrow keys
Move to the edge of the current block of data
Control + an arrow key (Mac: Command + an arrow key)
Move to cell A1, the start of the sheet
Control + Home (Mac: Fn + Control + Left Arrow)
Move to the last cell that has been used
Control + End (Mac: Fn + Control + Right Arrow)
Move down or up one screen
Page Down or Page Up
Move to the next or previous worksheet
Control + 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 name
F5 or Control + G
Move to the next cell in the row, or back to the previous one
Tab or Shift + Tab
Finish the cell and move down to the next row, or back up
Enter or Shift + Enter
Selecting
To do this
Press
Extend the selection by one cell
Shift + an arrow key
Extend the selection to the edge of the data
Control + Shift + an arrow key
Select the whole column
Control + Space
Select the whole row
Shift + Space
Select the current block of data; press again for the whole sheet
Control + A (Mac: Command + A)
Entering and editing
To do this
Press
Edit the cell you are on without clearing it
F2 (Mac: Control + U)
Cancel what you are typing and keep the old contents
Escape
Start a new line inside the same cell
Alt + Enter
Fill every selected cell with what you have typed
Control + 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 cells
Delete
Enter today's date
Control + Semicolon
Enter the current time
Control + Shift + Semicolon
Undo or redo
Control + Z or Control + Y (Mac: Command + Z or Command + Y)
Formulas
To do this
Press
Start a formula
Equals
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$1
F4 (Mac: Command + T)
Open the Insert Function dialog
Shift + F3
Show formulas instead of results on the sheet, or show results again
Control + Grave (the key under Escape)
Recalculate all open workbooks
F9
Formatting
To do this
Press
Make the selection bold, italic or underlined
Control + B, Control + I or Control + U (Command on the Mac)
Open the Format Cells dialog
Control + 1 (Mac: Command + 1)
Apply currency format with two decimal places
Control + Shift + 4 (the dollar sign)
Apply percentage format with no decimal places
Control + Shift + 5 (the percent sign)
Apply number format with two decimal places and a thousands separator
Control + Shift + 1
Apply date format with the day, month and year
Control + 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 this
Press
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 columns
Control + Minus
Hide the selected rows or columns
Control + 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 worksheet
Shift + F11
Rename the current worksheet
Alt + H, then O, then R
Open the context menu for the selected cells
Shift + F10 or the Applications key
Tables and filters
To do this
Press
Turn the current block of data into a table with filter buttons
Control + T
Turn filter buttons on or off for the header row
Control + 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 items
Tab, 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 this
Press
Hear the current cell again, with its address
Insert + 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 cell
Insert + 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.