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.
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.