Microsoft Access 2010 Keyboard Shortcuts
Below is a list of Microsoft Access 2010 keyboard shortcuts. With KillerKeys, you can always have the shortcuts you want for practically any application right in front of you. Learn more
| Modifier Key | Key | Description of shortcut |
| Ctrl | 0 | Hides the selected columns. |
| Ctrl Shift | 0 | Unhides any hidden columns within the selection. |
| Ctrl Shift | 1 | Apply the number format with two decimal places, thousands separator, and minus sign (–) for negative values. |
| Ctrl | 1 | Display the format cells dialog box. |
| Ctrl Shift | 2 | Apply the time format with the hour and minute, and am or pm. |
| Ctrl Shift | 3 | Apply the date format with the day, month, and year. |
| Ctrl Shift | 4 | Apply the currency format with two decimal places (negative numbers in parentheses). |
| Ctrl | 5 | Apply or remove strikethrough. |
| Ctrl Shift | 5 | Apply the percentage format with no decimal places. |
| Ctrl Shift | 6 | Apply the exponential number format with two decimal places. |
| Ctrl | 6 | Alternate between hiding objects, displaying objects, and displaying placeholders for objects. |
| Alt | 6 | Views button: switch among available folder views |
| Ctrl Shift | 7 | Apply the outline border to the selected cells. |
| Ctrl | 7 | Show or hide the standard toolbar. |
| Ctrl Shift | 8 | Selects an entire sheet or report. |
| Ctrl | 8 | Displays or hides the outline symbols. |
| Ctrl | 9 | Hides the selected rows. |
| Ctrl Shift | 9 | Unhide any hidden rows within the selection. |
| Ctrl Shift | * | Select the current region around the active cell (the data area enclosed by blank rows and blank columns). In a pivottable report, select the entire pivottable report. |
| Ctrl | / | Select the array containing the active cell. |
| Ctrl | [ | Select all cells directly referenced by formulas in the selection. |
| Ctrl Shift | [ | Select all cells directly or indirectly referenced by formulas in the selection. |
| Ctrl | \ | In a selected row, select the cells that don't match the formula or static value in the active cell. |
| Ctrl Shift | \ | In a selected column, select the cells that don't match the formula or static value in the active cell. |
| Ctrl | ] | Select cells that contain formulas that directly reference the active cell. |
| Ctrl Shift | ] | Select cells that contain formulas that directly or indirectly reference the active cell. |
| = | Start a formula. | |
| Ctrl Shift | = | Insert blank cells. |
| Alt | = | Insert an autosum formula with the sum function. |
| Ctrl | A | Select the entire worksheet. If the worksheet contains data, ctrl+a selects the current region. Pressing ctrl+a a second time selects the entire worksheet. |
| Ctrl | Apostrophe | Copies a formula from the cell above the active cell into the cell or the formula bar. |
| Ctrl Shift | Apostrophe | Copies the value from the cell above the active cell into the cell or the formula bar. |
| Ctrl | B | Bold |
| Alt | B | Apply or remove the bottom border. |
| Backspace | Edit the active cell and then clear it, or delete the preceding character in the active cell as you edit cell contents. | |
| Ctrl | Backspace | Scroll to display the active cell. |
| Shift | Backspace | With multiple cells selected, select only the active cell. |
| Ctrl | C | Copy the selected cells. |
| Ctrl | D | Fill down. |
| Alt | D | Apply or remove the downward diagonal border. |
| Delete | In cell editing mode, it deletes the character to the right of the insertion point or clears cell contents. | |
| Ctrl | Delete | Delete text to the end of the line. |
| Down Arrow | Move one cell/character/menu item down | |
| Ctrl | Down Arrow | Move to the edge of the current data region down. |
| Shift | Down Arrow | Extend the selection by one cell down. |
| Ctrl Shift | Down Arrow | Extend the selection to the last nonblank cell down in the same column or row as the active cell. |
| END | End turns end mode on. In end mode, you can then press an arrow key to move to the next nonblank cell in the same column or row as the active cell. If the cells are blank, pressing end followed by an arrow key moves to the last cell in the row or column. End also selects the last command on the menu when a menu or submenu is visible and moved to the end of a field. | |
| Ctrl | End | Move to the last cell on the worksheet, in the bottom-most used row of the rightmost used column. |
| Shift | End | Select from the insertion point to the end of the entry. |
| Ctrl Shift | End | Extend the selection to the last used cell on the worksheet (lower-right corner). |
These shortcuts are just a sample of the shortcuts available for this application. KillerKeys includes the complete list of shortcuts and is updated automatically with each new release of software.
| Modifier Key | Key | Description of shortcut |
| Ctrl | 0 | Hides the selected columns. |
| Ctrl Shift | 0 | Unhides any hidden columns within the selection. |
| Ctrl Shift | 1 | Apply the number format with two decimal places, thousands separator, and minus sign (–) for negative values. |
| Ctrl | 1 | Display the format cells dialog box. |
| Ctrl Shift | 2 | Apply the time format with the hour and minute, and am or pm. |
| Ctrl Shift | 3 | Apply the date format with the day, month, and year. |
| Ctrl Shift | 4 | Apply the currency format with two decimal places (negative numbers in parentheses). |
| Ctrl | 5 | Apply or remove strikethrough. |
| Ctrl Shift | 5 | Apply the percentage format with no decimal places. |
| Ctrl Shift | 6 | Apply the exponential number format with two decimal places. |
| Ctrl | 6 | Alternate between hiding objects, displaying objects, and displaying placeholders for objects. |
| Alt | 6 | Views button: switch among available folder views |
| Ctrl Shift | 7 | Apply the outline border to the selected cells. |
| Ctrl | 7 | Show or hide the standard toolbar. |
| Ctrl Shift | 8 | Selects an entire sheet or report. |
| Ctrl | 8 | Displays or hides the outline symbols. |
| Ctrl | 9 | Hides the selected rows. |
| Ctrl Shift | 9 | Unhide any hidden rows within the selection. |
| Ctrl Shift | * | Select the current region around the active cell (the data area enclosed by blank rows and blank columns). In a pivottable report, select the entire pivottable report. |
| Ctrl | / | Select the array containing the active cell. |
| Ctrl | [ | Select all cells directly referenced by formulas in the selection. |
| Ctrl Shift | [ | Select all cells directly or indirectly referenced by formulas in the selection. |
| Ctrl | \ | In a selected row, select the cells that don't match the formula or static value in the active cell. |
| Ctrl Shift | \ | In a selected column, select the cells that don't match the formula or static value in the active cell. |
| Ctrl | ] | Select cells that contain formulas that directly reference the active cell. |
| Ctrl Shift | ] | Select cells that contain formulas that directly or indirectly reference the active cell. |
| = | Start a formula. | |
| Ctrl Shift | = | Insert blank cells. |
| Alt | = | Insert an autosum formula with the sum function. |
| Ctrl | A | Select the entire worksheet. If the worksheet contains data, ctrl+a selects the current region. Pressing ctrl+a a second time selects the entire worksheet. |
| Ctrl | Apostrophe | Copies a formula from the cell above the active cell into the cell or the formula bar. |
| Ctrl Shift | Apostrophe | Copies the value from the cell above the active cell into the cell or the formula bar. |
| Ctrl | B | Bold |
| Alt | B | Apply or remove the bottom border. |
| Backspace | Edit the active cell and then clear it, or delete the preceding character in the active cell as you edit cell contents. | |
| Ctrl | Backspace | Scroll to display the active cell. |
| Shift | Backspace | With multiple cells selected, select only the active cell. |
| Ctrl | C | Copy the selected cells. |
| Ctrl | D | Fill down. |
| Alt | D | Apply or remove the downward diagonal border. |
| Delete | In cell editing mode, it deletes the character to the right of the insertion point or clears cell contents. | |
| Ctrl | Delete | Delete text to the end of the line. |
| Down Arrow | Move one cell/character/menu item down | |
| Ctrl | Down Arrow | Move to the edge of the current data region down. |
| Shift | Down Arrow | Extend the selection by one cell down. |
| Ctrl Shift | Down Arrow | Extend the selection to the last nonblank cell down in the same column or row as the active cell. |
| END | End turns end mode on. In end mode, you can then press an arrow key to move to the next nonblank cell in the same column or row as the active cell. If the cells are blank, pressing end followed by an arrow key moves to the last cell in the row or column. End also selects the last command on the menu when a menu or submenu is visible and moved to the end of a field. | |
| Ctrl | End | Move to the last cell on the worksheet, in the bottom-most used row of the rightmost used column. |
| Shift | End | Select from the insertion point to the end of the entry. |
| Ctrl Shift | End | Extend the selection to the last used cell on the worksheet (lower-right corner). |
