Hotkeys and shortcuts for Microsoft Excel 2010 (Windows)

(Total 740)

`Shift` + `Space`	Work with Data Selections - Select Cells Select the entire row.
`Ctrl` + `Space`	Work with Data Selections - Select Cells Select the entire column.
`Ctrl` + `Shift` + `*` (asterisk)	Work with Data Selections - Select Cells Select the current region around the active cell.
`Ctrl` + `a` (or `ctrl` + `Shift` + `spacebar` )	Work with Data Selections - Select Cells Select the entire worksheet or the data-containing area. Pressing ctrl+a a second time then selects entire worksheet.
`Ctrl` + `Shift` + `Page Up`	Work with Data Selections - Select Cells Select the current and previous sheet in a workbook.
`Ctrl` + `Shift` + `O`	Work with Data Selections - Select Cells Select all cells with comments.
`Shift` + `Arrow Keys`	Work with Data Selections - Select Cells Extend the selection by one cell.
`Ctrl` + `Shift` + `Arrow Key`	Work with Data Selections - Select Cells Extend the selection to the last cell with content in row or column.
`Shift` + `Page Down` / `Shift` + `Page Up`	Work with Data Selections - Select Cells Extend the selection down one screen /up one screen.
`Shift` + `Home`	Work with Data Selections - Select Cells Extend the selection to the beginning of the row.
`Ctrl` + `Shift` + `Home`	Work with Data Selections - Select Cells Extend the selection to the beginning of the worksheet.
`Ctrl` + `Shift` + `End`	Work with Data Selections - Select Cells Extend the selection to the last used cell on the worksheet (lower-right corner).
`F8`	Work with Data Selections - Manage Active Selections Turn on extension of selection with arrow keys without having to keep pressing shift.
`Shift` + `F8`	Work with Data Selections - Manage Active Selections Add another (adjacent or non-adjacent) range of cells to the selection. Use arrow keys and shift+arrow keys to add to selection.
`Shift` + `Backspace`	Work with Data Selections - Manage Active Selections Select only the active cell when multiple cells are selected.
`Ctrl` + `Backspace`	Work with Data Selections - Manage Active Selections Show active cell within selection.
`Ctrl` + `.` (period)	Work with Data Selections - Manage Active Selections Move clockwise to the next corner of the selection.
`Enter` / `Shift` + `Enter`	Work with Data Selections - Manage Active Selections Move active cell down / up in a selection.
`Tab` / `Shift` + `Tab`	Work with Data Selections - Manage Active Selections Move active cell right / left in a selection.
`Ctrl` + `Alt` + `Arrow Right` / `Ctrl` + `Alt` + `Arrow Left`	Work with Data Selections - Manage Active Selections Move to the right / to the left between non-adjacent selections (with multiple ranges selected).
`Esc`	Work with Data Selections - Manage Active Selections Cancel Selection.
`Shift` + `Arrow Left` / `Shift` + `Arrow Right`	Work with Data Selections - Select inside cells Select or unselect one character to the left / to the right.
`Ctrl` + `Shift` + `Arrow Left` / `Ctrl` + `Shift` + `Arrow Right`	Work with Data Selections - Select inside cells Select or unselect one word to the left / to the right.
`Shift` + `Home` / `Shift` + `End`	Work with Data Selections - Select inside cells Select from the insertion point to the beginning / to the end of the cell.
`Ctrl` + `Z`	Work with Data Selections - Undo / Redo Shortcuts Undo last action (multiple levels).
`Ctrl` + `Y`	Work with Data Selections - Undo / Redo Shortcuts Redo last action (multiple levels).
`Ctrl` + `C`	Work with Data Selections - Work with Clipboard Copy contents of selected cells.
`Ctrl` + `X`	Work with Data Selections - Work with Clipboard Cut contents of selected cells.
`Ctrl` + `V`	Work with Data Selections - Work with Clipboard Paste content from clipboard into selected cell.
`Ctrl` + `Alt` + `V`	Work with Data Selections - Work with Clipboard If data exists in clipboard: Display the Paste Special dialog box.
`Ctrl` + `Shift` + `[` + `]`	Work with Data Selections - Work with Clipboard If data exists in clipboard: Display the Insert dialog box to insert blank cells.
`F2`	Work with Data Selections - Edit Inside Cells Edit the active cell with cursor at end of the line.
`Alt` + `Enter`	Work with Data Selections - Edit Inside Cells Start a new line in the same cell.
`Enter`	Work with Data Selections - Edit Inside Cells Complete a cell entry and move down in the selection. With multiple cells selected: fill cell range with current cell.
`Shift` + `Enter`	Work with Data Selections - Edit Inside Cells Complete a cell entry and move up in the selection.
`Tab` / `Shift` + `Tab`	Work with Data Selections - Edit Inside Cells Complete a cell entry and move to the right / to the left in the selection.
`Esc`	Work with Data Selections - Edit Inside Cells Cancel a cell entry.
`Backspace`	Work with Data Selections - Edit Inside Cells Delete the character to the left of the insertion point, or delete the selection.
`Delete`	Work with Data Selections - Edit Inside Cells Delete the character to the right of the insertion point, or delete the selection.
`Ctrl` + `Delete`	Work with Data Selections - Edit Inside Cells Delete text to the end of the line.
`Ctrl` + `;` (semicolon)	Work with Data Selections - Edit Inside Cells Insert current date.
`Ctrl` + `Shift` + `:` (colon)	Work with Data Selections - Edit Inside Cells Insert current time.
`Ctrl` + `T`	Work with Data Selections - Edit Inside Cells Show all content as standard numbers. (So 14:15 becomes 14.25 etc for the entire file) To undo press ctrl + t again
`Ctrl` + `D`	Work with Data Selections - Edit Active or Selected Cells Fill complete cell down (Copy above cell).
`Ctrl` + `R`	Work with Data Selections - Edit Active or Selected Cells Fill complete cell to the right (Copy cell from the left).
`Ctrl` + `"`	Work with Data Selections - Edit Active or Selected Cells Fill cell values down and edit (Copy above cell values).
`Ctrl` + `'` (apostrophe)	Work with Data Selections - Edit Active or Selected Cells Fill cell formulas down and edit (Copy above cell formulas).
`Ctrl` + `L`	Work with Data Selections - Edit Active or Selected Cells Insert a table (display Create Table dialog box).
`Ctrl` + `-`	Work with Data Selections - Edit Active or Selected Cells Delete Cell/Row/Column Menu
`Ctrl` + `-` with row / column selected	Work with Data Selections - Edit Active or Selected Cells Delete row / delete column.
`Ctrl` + `Shift` + `[` + `]`	Work with Data Selections - Edit Active or Selected Cells Insert Cell/Row/Column Menu
`Ctrl` + `Shift` + `[` + with row / column selected	Work with Data Selections - Edit Active or Selected Cells Insert row/ insert column.
`Shift` + `F2`	Work with Data Selections - Edit Active or Selected Cells Insert / Edit a cell comment.
`Shift` + `f10` , then `m`	Work with Data Selections - Edit Active or Selected Cells Delete comment.
`Alt` + `F1`	Work with Data Selections - Edit Active or Selected Cells Create and insert chart with data in current range as embedded Chart Object.
`F11`	Work with Data Selections - Edit Active or Selected Cells Create and insert chart with data in current range in a separate Chart sheet.
`Ctrl` + `K`	Work with Data Selections - Edit Active or Selected Cells Insert a hyperlink.
`enter` (in a cell with a hyperlink)	Work with Data Selections - Edit Active or Selected Cells Activate a hyperlink.
`Ctrl` + `9`	Work with Data Selections - Hide and Show Elements Hide the selected rows.
`Ctrl` + `Shift` + `9`	Work with Data Selections - Hide and Show Elements Unhide any hidden rows within the selection.
`Ctrl` + `0` (zero)	Work with Data Selections - Hide and Show Elements Hide the selected columns.
`Ctrl` + `Shift` + `0` (zero)	Work with Data Selections - Hide and Show Elements *Unhide any hidden columns within the selection.**
`Ctrl` + ` (grave accent)	Work with Data Selections - Hide and Show Elements Alternate between displaying cell values and displaying cell formulas. Accent grave /not a quotation mark.
`Alt` + `Shift` + `Arrow Right`	Work with Data Selections - Hide and Show Elements Group rows or columns.
`Alt` + `Shift` + `Arrow Left`	Work with Data Selections - Hide and Show Elements Ungroup rows or columns.
`Ctrl` + `6`	Work with Data Selections - Hide and Show Elements Alternate between hiding and displaying objects.
`Ctrl` + `8`	Work with Data Selections - Hide and Show Elements Display or hides the outline symbols.
`Ctrl` + `6`	Work with Data Selections - Hide and Show Elements Alternate between hiding objects, displaying objects, and displaying placeholders for objects.
`Alt` + `o` , `c` `a`	Work with Data Selections - Adjust Column Width and Row Height Adjust Column width to fit content. Select complete column with Ctrl+Space first, otherwise column adjusts to content of current cell). Remember Format, Column Adjust.
`Alt` + `o` , `c` `w`	Work with Data Selections - Adjust Column Width and Row Height Adjust Columns width to specific value: Option, Cow, width
`Alt` + `o` , `r` `a`	Work with Data Selections - Adjust Column Width and Row Height Adjust Row height to fit content: Option, Row, Adjust
`Alt` + `o` , `r` `e`	Work with Data Selections - Adjust Column Width and Row Height Adjust Row height to specific value: Option, Row, Height
`Ctrl` + `1`	Work with Data Selections - Format Cells Format cells dialog.
`Ctrl` + `b` (or `ctrl` + `2` )	Work with Data Selections - Format Cells Apply or remove bold formatting.
`Ctrl` + `i` (or `ctrl` + `3` )	Work with Data Selections - Format Cells Apply or remove italic formatting.
`Ctrl` + `u` (or `ctrl` + `4` )	Work with Data Selections - Format Cells Apply or remove an underline.
`Ctrl` + `5`	Work with Data Selections - Format Cells Apply or remove strikethrough formatting.
`Ctrl` + `Shift` + `F`	Work with Data Selections - Format Cells Display the Format Cells with Fonts Tab active. Press tab 3x to get to font-size. Used to be ctrl+shift+p, but that seems just get to the Font Tab in 2010.
`Alt` + `'` (apostrophe / single quote)	Work with Data Selections - Format Cells Display the Style dialog box.
`Ctrl` + `Shift` + `$`	Work with Data Selections - Number Formats Apply the Currency format with two decimal places.
`Ctrl` + `Shift` + `~`	Work with Data Selections - Number Formats Apply the General number format.
`Ctrl` + `Shift` + `%`	Work with Data Selections - Number Formats Apply the Percentage format with no decimal places.
`Ctrl` + `Shift` + `#`	Work with Data Selections - Number Formats Apply the Date format with the day, month, and year.
`Ctrl` + `Shift` + `@`	Work with Data Selections - Number Formats Apply the Time format with the hour and minute, and indicate A.M. or P.M.
`Ctrl` + `Shift` + `!`	Work with Data Selections - Number Formats Apply the Number format with two decimal places, thousands separator, and minus sign (-) for negative values.
`Ctrl` + `Shift` + `^`	Work with Data Selections - Number Formats Apply the Scientific number format with two decimal places.
`F4`	Work with Data Selections - Number Formats Repeat last formatting action: Apply previously applied Cell Formatting to a different Cell
`Ctrl` + `Shift` + `&`	Work with Data Selections - Apply Borders to Cells Apply outline border from cell or selection
`Ctrl` + `Shift` + `_` (underscore)	Work with Data Selections - Apply Borders to Cells Remove outline borders from cell or selection
`Ctrl` + `1` , then `Ctrl` + `Arrow Right` / `Arrow Left`	Work with Data Selections - Apply Borders to Cells Access border menu in 'Format Cell' dialog. Once border was selected, it will show up directly on the next Ctrl+1
`Alt` + `t` *	Work with Data Selections - Apply Borders to Cells Set top border
`Alt` + `b` *	Work with Data Selections - Apply Borders to Cells Set bottom Border
`Alt` + `l` *	Work with Data Selections - Apply Borders to Cells Set left Border
`Alt` + `r` *	Work with Data Selections - Apply Borders to Cells Set right Border
`Alt` + `d` *	Work with Data Selections - Apply Borders to Cells Set diagonal and down border
`Alt` + `u` *	Work with Data Selections - Apply Borders to Cells Set diagonal and up border
`Alt` + `h` , `a` `r`	Work with Data Selections - Align Cells Align Right
`Alt` + `h` , `a` `c`	Work with Data Selections - Align Cells Align Center
`Alt` + `h` , `a` `l`	Work with Data Selections - Align Cells Align Left
`=`	Work with Data Selections - Formulas Start a formula.
`Alt` + `=`	Work with Data Selections - Formulas Insert the AutoSum formula.
`Shift` + `F3`	Work with Data Selections - Formulas Display the Insert Function dialog box.
`Ctrl` + `A`	Work with Data Selections - Formulas Display Formula Window after typing formula name.
`Ctrl` + `Shift` + `A`	Work with Data Selections - Formulas Insert Arguments in formula after typing formula name. .
`Shift` + `F3`	Work with Data Selections - Formulas Insert a function into a formula .
`Ctrl` + `Shift` + `Enter`	Work with Data Selections - Formulas Enter a formula as an array formula.
`F4`	Work with Data Selections - Formulas After typing cell reference (e.g. =E3) makes reference absolute (=$E$4)
`F9`	Work with Data Selections - Formulas Calculate all worksheets in all open workbooks.
`Shift` + `F9`	Work with Data Selections - Formulas Calculate the active worksheet.
`Ctrl` + `Alt` + `F9`	Work with Data Selections - Formulas Calculate all worksheets in all open workbooks, regardless of whether they have changed since the last calculation.
`Ctrl` + `Alt` + `Shift` + `F9`	Work with Data Selections - Formulas Recheck dependent formulas, and then calculates all cells in all open workbooks, including cells not marked as needing to be calculated.
`Ctrl` + `Shift` + `U`	Work with Data Selections - Formulas Toggle expand or collapse formula bar.
`Ctrl` + `	Work with Data Selections - Formulas Toggle Show formula in cell instead of values
`Ctrl` + `F3`	Work with Data Selections - Names Define a name or dialog.
`Ctrl` + `Shift` + `F3`	Work with Data Selections - Names Create names from row and column labels.
`F3`	Work with Data Selections - Names Paste a defined name into a formula.
`Arrow Keys`	Work with Data Selections - Dialog Boxes Move between options in the active drop-down list box or between some options in a group of options.
`Ctrl` + `Tab` / `Ctrl` + `Shift` + `Tab`	Work with Data Selections - Dialog Boxes Switch to the next/ previous tab in dialog box.
`Space`	Work with Data Selections - Dialog Boxes In a dialog box: perform the action for the selected button, or select/clear a check box.
`Tab` / `Shift` + `Tab`	Work with Data Selections - Dialog Boxes Move to the next / previous option.
`a` ... `z`	Work with Data Selections - Dialog Boxes Move to an option in a drop-down list box starting with the letter
`Alt` + `a` ... `alt` + `Z`	Work with Data Selections - Dialog Boxes Select an option, or select or clear a check box.
`Alt` + `Arrow Down`	Work with Data Selections - Dialog Boxes Open the selected drop-down list box.
`Enter`	Work with Data Selections - Dialog Boxes Perform the action assigned to the default command button in the dialog box.
`Esc`	Work with Data Selections - Dialog Boxes Cancel the command and close the dialog box.
`Alt` + `Arrow Down`	Work with Data Selections - Auto Filter On the field with column head, display the AutoFilter list for the current column .
`Arrow Down` / `Arrow Up`	Work with Data Selections - Auto Filter Select the next item / previous item in the AutoFilter list.
`Alt` + `Arrow Up`	Work with Data Selections - Auto Filter Close the AutoFilter list for the current column.
`Home` / `End`	Work with Data Selections - Auto Filter Select the first item / last item in the AutoFilter list.
`Enter`	Work with Data Selections - Auto Filter Filter the list by using the selected item in the AutoFilter list.
`Ctrl` + `Shift` + `L`	Work with Data Selections - Auto Filter Apply filter on selected column headings.
`Arrow Keys`	Work with Data Selections - Work with Smart Art Graphics Select elements.
`Esc`	Work with Data Selections - Work with Smart Art Graphics Remove Focus from Selection.
`F2`	Work with Data Selections - Work with Smart Art Graphics Edit Selection Text in if possible (in formula bar).
`Shift` + `Space`	Insert and Edit Data - Select Cells Select the entire row.
`Ctrl` + `Space`	Insert and Edit Data - Select Cells Select the entire column.
`Ctrl` + `Shift` + `*` (asterisk)	Insert and Edit Data - Select Cells Select the current region around the active cell.
`Ctrl` + `a` (or `ctrl` + `Shift` + `spacebar` )	Insert and Edit Data - Select Cells Select the entire worksheet or the data-containing area. Pressing ctrl+a a second time then selects entire worksheet.
`Ctrl` + `Shift` + `Page Up`	Insert and Edit Data - Select Cells Select the current and previous sheet in a workbook.
`Ctrl` + `Shift` + `O`	Insert and Edit Data - Select Cells Select all cells with comments.
`Shift` + `Arrow Keys`	Insert and Edit Data - Select Cells Extend the selection by one cell.
`Ctrl` + `Shift` + `Arrow Key`	Insert and Edit Data - Select Cells Extend the selection to the last cell with content in row or column.
`Shift` + `Page Down` / `Shift` + `Page Up`	Insert and Edit Data - Select Cells Extend the selection down one screen /up one screen.
`Shift` + `Home`	Insert and Edit Data - Select Cells Extend the selection to the beginning of the row.
`Ctrl` + `Shift` + `Home`	Insert and Edit Data - Select Cells Extend the selection to the beginning of the worksheet.
`Ctrl` + `Shift` + `End`	Insert and Edit Data - Select Cells Extend the selection to the last used cell on the worksheet (lower-right corner).
`F8`	Insert and Edit Data - Manage Active Selections Turn on extension of selection with arrow keys without having to keep pressing shift.
`Shift` + `F8`	Insert and Edit Data - Manage Active Selections Add another (adjacent or non-adjacent) range of cells to the selection. Use arrow keys and shift+arrow keys to add to selection.
`Shift` + `Backspace`	Insert and Edit Data - Manage Active Selections Select only the active cell when multiple cells are selected.
`Ctrl` + `Backspace`	Insert and Edit Data - Manage Active Selections Show active cell within selection.
`Ctrl` + `.` (period)	Insert and Edit Data - Manage Active Selections Move clockwise to the next corner of the selection.
`Enter` / `Shift` + `Enter`	Insert and Edit Data - Manage Active Selections Move active cell down / up in a selection.
`Tab` / `Shift` + `Tab`	Insert and Edit Data - Manage Active Selections Move active cell right / left in a selection.
`Ctrl` + `Alt` + `Arrow Right` / `Ctrl` + `Alt` + `Arrow Left`	Insert and Edit Data - Manage Active Selections Move to the right / to the left between non-adjacent selections (with multiple ranges selected).
`Esc`	Insert and Edit Data - Manage Active Selections Cancel Selection.
`Shift` + `Arrow Left` / `Shift` + `Arrow Right`	Insert and Edit Data - Select inside cells Select or unselect one character to the left / to the right.
`Ctrl` + `Shift` + `Arrow Left` / `Ctrl` + `Shift` + `Arrow Right`	Insert and Edit Data - Select inside cells Select or unselect one word to the left / to the right.
`Shift` + `Home` / `Shift` + `End`	Insert and Edit Data - Select inside cells Select from the insertion point to the beginning / to the end of the cell.
`Ctrl` + `Z`	Insert and Edit Data - Undo / Redo Shortcuts Undo last action (multiple levels).
`Ctrl` + `Y`	Insert and Edit Data - Undo / Redo Shortcuts Redo last action (multiple levels).
`Ctrl` + `C`	Insert and Edit Data - Work with Clipboard Copy contents of selected cells.
`Ctrl` + `X`	Insert and Edit Data - Work with Clipboard Cut contents of selected cells.
`Ctrl` + `V`	Insert and Edit Data - Work with Clipboard Paste content from clipboard into selected cell.
`Ctrl` + `Alt` + `V`	Insert and Edit Data - Work with Clipboard If data exists in clipboard: Display the Paste Special dialog box.
`Ctrl` + `Shift` + `[` + `]`	Insert and Edit Data - Work with Clipboard If data exists in clipboard: Display the Insert dialog box to insert blank cells.
`F2`	Insert and Edit Data - Edit Inside Cells Edit the active cell with cursor at end of the line.
`Alt` + `Enter`	Insert and Edit Data - Edit Inside Cells Start a new line in the same cell.
`Enter`	Insert and Edit Data - Edit Inside Cells Complete a cell entry and move down in the selection. With multiple cells selected: fill cell range with current cell.
`Shift` + `Enter`	Insert and Edit Data - Edit Inside Cells Complete a cell entry and move up in the selection.
`Tab` / `Shift` + `Tab`	Insert and Edit Data - Edit Inside Cells Complete a cell entry and move to the right / to the left in the selection.
`Esc`	Insert and Edit Data - Edit Inside Cells Cancel a cell entry.
`Backspace`	Insert and Edit Data - Edit Inside Cells Delete the character to the left of the insertion point, or delete the selection.
`Delete`	Insert and Edit Data - Edit Inside Cells Delete the character to the right of the insertion point, or delete the selection.
`Ctrl` + `Delete`	Insert and Edit Data - Edit Inside Cells Delete text to the end of the line.
`Ctrl` + `;` (semicolon)	Insert and Edit Data - Edit Inside Cells Insert current date.
`Ctrl` + `Shift` + `:` (colon)	Insert and Edit Data - Edit Inside Cells Insert current time.
`Ctrl` + `T`	Insert and Edit Data - Edit Inside Cells Show all content as standard numbers. (So 14:15 becomes 14.25 etc for the entire file) To undo press ctrl + t again
`Ctrl` + `D`	Insert and Edit Data - Edit Active or Selected Cells Fill complete cell down (Copy above cell).
`Ctrl` + `R`	Insert and Edit Data - Edit Active or Selected Cells Fill complete cell to the right (Copy cell from the left).
`Ctrl` + `"`	Insert and Edit Data - Edit Active or Selected Cells Fill cell values down and edit (Copy above cell values).
`Ctrl` + `'` (apostrophe)	Insert and Edit Data - Edit Active or Selected Cells Fill cell formulas down and edit (Copy above cell formulas).
`Ctrl` + `L`	Insert and Edit Data - Edit Active or Selected Cells Insert a table (display Create Table dialog box).
`Ctrl` + `-`	Insert and Edit Data - Edit Active or Selected Cells Delete Cell/Row/Column Menu
`Ctrl` + `-` with row / column selected	Insert and Edit Data - Edit Active or Selected Cells Delete row / delete column.
`Ctrl` + `Shift` + `[` + `]`	Insert and Edit Data - Edit Active or Selected Cells Insert Cell/Row/Column Menu
`Ctrl` + `Shift` + `[` + with row / column selected	Insert and Edit Data - Edit Active or Selected Cells Insert row/ insert column.
`Shift` + `F2`	Insert and Edit Data - Edit Active or Selected Cells Insert / Edit a cell comment.
`Shift` + `f10` , then `m`	Insert and Edit Data - Edit Active or Selected Cells Delete comment.
`Alt` + `F1`	Insert and Edit Data - Edit Active or Selected Cells Create and insert chart with data in current range as embedded Chart Object.
`F11`	Insert and Edit Data - Edit Active or Selected Cells Create and insert chart with data in current range in a separate Chart sheet.
`Ctrl` + `K`	Insert and Edit Data - Edit Active or Selected Cells Insert a hyperlink.
`enter` (in a cell with a hyperlink)	Insert and Edit Data - Edit Active or Selected Cells Activate a hyperlink.
`Ctrl` + `9`	Insert and Edit Data - Hide and Show Elements Hide the selected rows.
`Ctrl` + `Shift` + `9`	Insert and Edit Data - Hide and Show Elements Unhide any hidden rows within the selection.
`Ctrl` + `0` (zero)	Insert and Edit Data - Hide and Show Elements Hide the selected columns.
`Ctrl` + `Shift` + `0` (zero)	Insert and Edit Data - Hide and Show Elements *Unhide any hidden columns within the selection.**
`Ctrl` + ` (grave accent)	Insert and Edit Data - Hide and Show Elements Alternate between displaying cell values and displaying cell formulas. Accent grave /not a quotation mark.
`Alt` + `Shift` + `Arrow Right`	Insert and Edit Data - Hide and Show Elements Group rows or columns.
`Alt` + `Shift` + `Arrow Left`	Insert and Edit Data - Hide and Show Elements Ungroup rows or columns.
`Ctrl` + `6`	Insert and Edit Data - Hide and Show Elements Alternate between hiding and displaying objects.
`Ctrl` + `8`	Insert and Edit Data - Hide and Show Elements Display or hides the outline symbols.
`Ctrl` + `6`	Insert and Edit Data - Hide and Show Elements Alternate between hiding objects, displaying objects, and displaying placeholders for objects.
`Alt` + `o` , `c` `a`	Insert and Edit Data - Adjust Column Width and Row Height Adjust Column width to fit content. Select complete column with Ctrl+Space first, otherwise column adjusts to content of current cell). Remember Format, Column Adjust.
`Alt` + `o` , `c` `w`	Insert and Edit Data - Adjust Column Width and Row Height Adjust Columns width to specific value: Option, Cow, width
`Alt` + `o` , `r` `a`	Insert and Edit Data - Adjust Column Width and Row Height Adjust Row height to fit content: Option, Row, Adjust
`Alt` + `o` , `r` `e`	Insert and Edit Data - Adjust Column Width and Row Height Adjust Row height to specific value: Option, Row, Height
`Ctrl` + `1`	Insert and Edit Data - Format Cells Format cells dialog.
`Ctrl` + `b` (or `ctrl` + `2` )	Insert and Edit Data - Format Cells Apply or remove bold formatting.
`Ctrl` + `i` (or `ctrl` + `3` )	Insert and Edit Data - Format Cells Apply or remove italic formatting.
`Ctrl` + `u` (or `ctrl` + `4` )	Insert and Edit Data - Format Cells Apply or remove an underline.
`Ctrl` + `5`	Insert and Edit Data - Format Cells Apply or remove strikethrough formatting.
`Ctrl` + `Shift` + `F`	Insert and Edit Data - Format Cells Display the Format Cells with Fonts Tab active. Press tab 3x to get to font-size. Used to be ctrl+shift+p, but that seems just get to the Font Tab in 2010.
`Alt` + `'` (apostrophe / single quote)	Insert and Edit Data - Format Cells Display the Style dialog box.
`Ctrl` + `Shift` + `$`	Insert and Edit Data - Number Formats Apply the Currency format with two decimal places.
`Ctrl` + `Shift` + `~`	Insert and Edit Data - Number Formats Apply the General number format.
`Ctrl` + `Shift` + `%`	Insert and Edit Data - Number Formats Apply the Percentage format with no decimal places.
`Ctrl` + `Shift` + `#`	Insert and Edit Data - Number Formats Apply the Date format with the day, month, and year.
`Ctrl` + `Shift` + `@`	Insert and Edit Data - Number Formats Apply the Time format with the hour and minute, and indicate A.M. or P.M.
`Ctrl` + `Shift` + `!`	Insert and Edit Data - Number Formats Apply the Number format with two decimal places, thousands separator, and minus sign (-) for negative values.
`Ctrl` + `Shift` + `^`	Insert and Edit Data - Number Formats Apply the Scientific number format with two decimal places.
`F4`	Insert and Edit Data - Number Formats Repeat last formatting action: Apply previously applied Cell Formatting to a different Cell
`Ctrl` + `Shift` + `&`	Insert and Edit Data - Apply Borders to Cells Apply outline border from cell or selection
`Ctrl` + `Shift` + `_` (underscore)	Insert and Edit Data - Apply Borders to Cells Remove outline borders from cell or selection
`Ctrl` + `1` , then `Ctrl` + `Arrow Right` / `Arrow Left`	Insert and Edit Data - Apply Borders to Cells Access border menu in 'Format Cell' dialog. Once border was selected, it will show up directly on the next Ctrl+1
`Alt` + `t` *	Insert and Edit Data - Apply Borders to Cells Set top border
`Alt` + `b` *	Insert and Edit Data - Apply Borders to Cells Set bottom Border
`Alt` + `l` *	Insert and Edit Data - Apply Borders to Cells Set left Border
`Alt` + `r` *	Insert and Edit Data - Apply Borders to Cells Set right Border
`Alt` + `d` *	Insert and Edit Data - Apply Borders to Cells Set diagonal and down border
`Alt` + `u` *	Insert and Edit Data - Apply Borders to Cells Set diagonal and up border
`Alt` + `h` , `a` `r`	Insert and Edit Data - Align Cells Align Right
`Alt` + `h` , `a` `c`	Insert and Edit Data - Align Cells Align Center
`Alt` + `h` , `a` `l`	Insert and Edit Data - Align Cells Align Left
`=`	Insert and Edit Data - Formulas Start a formula.
`Alt` + `=`	Insert and Edit Data - Formulas Insert the AutoSum formula.
`Shift` + `F3`	Insert and Edit Data - Formulas Display the Insert Function dialog box.
`Ctrl` + `A`	Insert and Edit Data - Formulas Display Formula Window after typing formula name.
`Ctrl` + `Shift` + `A`	Insert and Edit Data - Formulas Insert Arguments in formula after typing formula name. .
`Shift` + `F3`	Insert and Edit Data - Formulas Insert a function into a formula .
`Ctrl` + `Shift` + `Enter`	Insert and Edit Data - Formulas Enter a formula as an array formula.
`F4`	Insert and Edit Data - Formulas After typing cell reference (e.g. =E3) makes reference absolute (=$E$4)
`F9`	Insert and Edit Data - Formulas Calculate all worksheets in all open workbooks.
`Shift` + `F9`	Insert and Edit Data - Formulas Calculate the active worksheet.
`Ctrl` + `Alt` + `F9`	Insert and Edit Data - Formulas Calculate all worksheets in all open workbooks, regardless of whether they have changed since the last calculation.
`Ctrl` + `Alt` + `Shift` + `F9`	Insert and Edit Data - Formulas Recheck dependent formulas, and then calculates all cells in all open workbooks, including cells not marked as needing to be calculated.
`Ctrl` + `Shift` + `U`	Insert and Edit Data - Formulas Toggle expand or collapse formula bar.
`Ctrl` + `	Insert and Edit Data - Formulas Toggle Show formula in cell instead of values
`Ctrl` + `F3`	Insert and Edit Data - Names Define a name or dialog.
`Ctrl` + `Shift` + `F3`	Insert and Edit Data - Names Create names from row and column labels.
`F3`	Insert and Edit Data - Names Paste a defined name into a formula.
`Arrow Keys`	Insert and Edit Data - Dialog Boxes Move between options in the active drop-down list box or between some options in a group of options.
`Ctrl` + `Tab` / `Ctrl` + `Shift` + `Tab`	Insert and Edit Data - Dialog Boxes Switch to the next/ previous tab in dialog box.
`Space`	Insert and Edit Data - Dialog Boxes In a dialog box: perform the action for the selected button, or select/clear a check box.
`Tab` / `Shift` + `Tab`	Insert and Edit Data - Dialog Boxes Move to the next / previous option.
`a` ... `z`	Insert and Edit Data - Dialog Boxes Move to an option in a drop-down list box starting with the letter
`Alt` + `a` ... `alt` + `Z`	Insert and Edit Data - Dialog Boxes Select an option, or select or clear a check box.
`Alt` + `Arrow Down`	Insert and Edit Data - Dialog Boxes Open the selected drop-down list box.
`Enter`	Insert and Edit Data - Dialog Boxes Perform the action assigned to the default command button in the dialog box.
`Esc`	Insert and Edit Data - Dialog Boxes Cancel the command and close the dialog box.
`Alt` + `Arrow Down`	Insert and Edit Data - Auto Filter On the field with column head, display the AutoFilter list for the current column .
`Arrow Down` / `Arrow Up`	Insert and Edit Data - Auto Filter Select the next item / previous item in the AutoFilter list.
`Alt` + `Arrow Up`	Insert and Edit Data - Auto Filter Close the AutoFilter list for the current column.
`Home` / `End`	Insert and Edit Data - Auto Filter Select the first item / last item in the AutoFilter list.
`Enter`	Insert and Edit Data - Auto Filter Filter the list by using the selected item in the AutoFilter list.
`Ctrl` + `Shift` + `L`	Insert and Edit Data - Auto Filter Apply filter on selected column headings.
`Arrow Keys`	Insert and Edit Data - Work with Smart Art Graphics Select elements.
`Esc`	Insert and Edit Data - Work with Smart Art Graphics Remove Focus from Selection.
`F2`	Insert and Edit Data - Work with Smart Art Graphics Edit Selection Text in if possible (in formula bar).
`Shift` + `Space`	Format Data - Select Cells Select the entire row.
`Ctrl` + `Space`	Format Data - Select Cells Select the entire column.
`Ctrl` + `Shift` + `*` (asterisk)	Format Data - Select Cells Select the current region around the active cell.
`Ctrl` + `a` (or `ctrl` + `Shift` + `spacebar` )	Format Data - Select Cells Select the entire worksheet or the data-containing area. Pressing ctrl+a a second time then selects entire worksheet.
`Ctrl` + `Shift` + `Page Up`	Format Data - Select Cells Select the current and previous sheet in a workbook.
`Ctrl` + `Shift` + `O`	Format Data - Select Cells Select all cells with comments.
`Shift` + `Arrow Keys`	Format Data - Select Cells Extend the selection by one cell.
`Ctrl` + `Shift` + `Arrow Key`	Format Data - Select Cells Extend the selection to the last cell with content in row or column.
`Shift` + `Page Down` / `Shift` + `Page Up`	Format Data - Select Cells Extend the selection down one screen /up one screen.
`Shift` + `Home`	Format Data - Select Cells Extend the selection to the beginning of the row.
`Ctrl` + `Shift` + `Home`	Format Data - Select Cells Extend the selection to the beginning of the worksheet.
`Ctrl` + `Shift` + `End`	Format Data - Select Cells Extend the selection to the last used cell on the worksheet (lower-right corner).
`F8`	Format Data - Manage Active Selections Turn on extension of selection with arrow keys without having to keep pressing shift.
`Shift` + `F8`	Format Data - Manage Active Selections Add another (adjacent or non-adjacent) range of cells to the selection. Use arrow keys and shift+arrow keys to add to selection.
`Shift` + `Backspace`	Format Data - Manage Active Selections Select only the active cell when multiple cells are selected.
`Ctrl` + `Backspace`	Format Data - Manage Active Selections Show active cell within selection.
`Ctrl` + `.` (period)	Format Data - Manage Active Selections Move clockwise to the next corner of the selection.
`Enter` / `Shift` + `Enter`	Format Data - Manage Active Selections Move active cell down / up in a selection.
`Tab` / `Shift` + `Tab`	Format Data - Manage Active Selections Move active cell right / left in a selection.
`Ctrl` + `Alt` + `Arrow Right` / `Ctrl` + `Alt` + `Arrow Left`	Format Data - Manage Active Selections Move to the right / to the left between non-adjacent selections (with multiple ranges selected).
`Esc`	Format Data - Manage Active Selections Cancel Selection.
`Shift` + `Arrow Left` / `Shift` + `Arrow Right`	Format Data - Select inside cells Select or unselect one character to the left / to the right.
`Ctrl` + `Shift` + `Arrow Left` / `Ctrl` + `Shift` + `Arrow Right`	Format Data - Select inside cells Select or unselect one word to the left / to the right.
`Shift` + `Home` / `Shift` + `End`	Format Data - Select inside cells Select from the insertion point to the beginning / to the end of the cell.
`Ctrl` + `Z`	Format Data - Undo / Redo Shortcuts Undo last action (multiple levels).
`Ctrl` + `Y`	Format Data - Undo / Redo Shortcuts Redo last action (multiple levels).
`Ctrl` + `C`	Format Data - Work with Clipboard Copy contents of selected cells.
`Ctrl` + `X`	Format Data - Work with Clipboard Cut contents of selected cells.
`Ctrl` + `V`	Format Data - Work with Clipboard Paste content from clipboard into selected cell.
`Ctrl` + `Alt` + `V`	Format Data - Work with Clipboard If data exists in clipboard: Display the Paste Special dialog box.
`Ctrl` + `Shift` + `[` + `]`	Format Data - Work with Clipboard If data exists in clipboard: Display the Insert dialog box to insert blank cells.
`F2`	Format Data - Edit Inside Cells Edit the active cell with cursor at end of the line.
`Alt` + `Enter`	Format Data - Edit Inside Cells Start a new line in the same cell.
`Enter`	Format Data - Edit Inside Cells Complete a cell entry and move down in the selection. With multiple cells selected: fill cell range with current cell.
`Shift` + `Enter`	Format Data - Edit Inside Cells Complete a cell entry and move up in the selection.
`Tab` / `Shift` + `Tab`	Format Data - Edit Inside Cells Complete a cell entry and move to the right / to the left in the selection.
`Esc`	Format Data - Edit Inside Cells Cancel a cell entry.
`Backspace`	Format Data - Edit Inside Cells Delete the character to the left of the insertion point, or delete the selection.
`Delete`	Format Data - Edit Inside Cells Delete the character to the right of the insertion point, or delete the selection.
`Ctrl` + `Delete`	Format Data - Edit Inside Cells Delete text to the end of the line.
`Ctrl` + `;` (semicolon)	Format Data - Edit Inside Cells Insert current date.
`Ctrl` + `Shift` + `:` (colon)	Format Data - Edit Inside Cells Insert current time.
`Ctrl` + `T`	Format Data - Edit Inside Cells Show all content as standard numbers. (So 14:15 becomes 14.25 etc for the entire file) To undo press ctrl + t again
`Ctrl` + `D`	Format Data - Edit Active or Selected Cells Fill complete cell down (Copy above cell).
`Ctrl` + `R`	Format Data - Edit Active or Selected Cells Fill complete cell to the right (Copy cell from the left).
`Ctrl` + `"`	Format Data - Edit Active or Selected Cells Fill cell values down and edit (Copy above cell values).
`Ctrl` + `'` (apostrophe)	Format Data - Edit Active or Selected Cells Fill cell formulas down and edit (Copy above cell formulas).
`Ctrl` + `L`	Format Data - Edit Active or Selected Cells Insert a table (display Create Table dialog box).
`Ctrl` + `-`	Format Data - Edit Active or Selected Cells Delete Cell/Row/Column Menu
`Ctrl` + `-` with row / column selected	Format Data - Edit Active or Selected Cells Delete row / delete column.
`Ctrl` + `Shift` + `[` + `]`	Format Data - Edit Active or Selected Cells Insert Cell/Row/Column Menu
`Ctrl` + `Shift` + `[` + with row / column selected	Format Data - Edit Active or Selected Cells Insert row/ insert column.
`Shift` + `F2`	Format Data - Edit Active or Selected Cells Insert / Edit a cell comment.
`Shift` + `f10` , then `m`	Format Data - Edit Active or Selected Cells Delete comment.
`Alt` + `F1`	Format Data - Edit Active or Selected Cells Create and insert chart with data in current range as embedded Chart Object.
`F11`	Format Data - Edit Active or Selected Cells Create and insert chart with data in current range in a separate Chart sheet.
`Ctrl` + `K`	Format Data - Edit Active or Selected Cells Insert a hyperlink.
`enter` (in a cell with a hyperlink)	Format Data - Edit Active or Selected Cells Activate a hyperlink.
`Ctrl` + `9`	Format Data - Hide and Show Elements Hide the selected rows.
`Ctrl` + `Shift` + `9`	Format Data - Hide and Show Elements Unhide any hidden rows within the selection.
`Ctrl` + `0` (zero)	Format Data - Hide and Show Elements Hide the selected columns.
`Ctrl` + `Shift` + `0` (zero)	Format Data - Hide and Show Elements *Unhide any hidden columns within the selection.**
`Ctrl` + ` (grave accent)	Format Data - Hide and Show Elements Alternate between displaying cell values and displaying cell formulas. Accent grave /not a quotation mark.
`Alt` + `Shift` + `Arrow Right`	Format Data - Hide and Show Elements Group rows or columns.
`Alt` + `Shift` + `Arrow Left`	Format Data - Hide and Show Elements Ungroup rows or columns.
`Ctrl` + `6`	Format Data - Hide and Show Elements Alternate between hiding and displaying objects.
`Ctrl` + `8`	Format Data - Hide and Show Elements Display or hides the outline symbols.
`Ctrl` + `6`	Format Data - Hide and Show Elements Alternate between hiding objects, displaying objects, and displaying placeholders for objects.
`Alt` + `o` , `c` `a`	Format Data - Adjust Column Width and Row Height Adjust Column width to fit content. Select complete column with Ctrl+Space first, otherwise column adjusts to content of current cell). Remember Format, Column Adjust.
`Alt` + `o` , `c` `w`	Format Data - Adjust Column Width and Row Height Adjust Columns width to specific value: Option, Cow, width
`Alt` + `o` , `r` `a`	Format Data - Adjust Column Width and Row Height Adjust Row height to fit content: Option, Row, Adjust
`Alt` + `o` , `r` `e`	Format Data - Adjust Column Width and Row Height Adjust Row height to specific value: Option, Row, Height
`Ctrl` + `1`	Format Data - Format Cells Format cells dialog.
`Ctrl` + `b` (or `ctrl` + `2` )	Format Data - Format Cells Apply or remove bold formatting.
`Ctrl` + `i` (or `ctrl` + `3` )	Format Data - Format Cells Apply or remove italic formatting.
`Ctrl` + `u` (or `ctrl` + `4` )	Format Data - Format Cells Apply or remove an underline.
`Ctrl` + `5`	Format Data - Format Cells Apply or remove strikethrough formatting.
`Ctrl` + `Shift` + `F`	Format Data - Format Cells Display the Format Cells with Fonts Tab active. Press tab 3x to get to font-size. Used to be ctrl+shift+p, but that seems just get to the Font Tab in 2010.
`Alt` + `'` (apostrophe / single quote)	Format Data - Format Cells Display the Style dialog box.
`Ctrl` + `Shift` + `$`	Format Data - Number Formats Apply the Currency format with two decimal places.
`Ctrl` + `Shift` + `~`	Format Data - Number Formats Apply the General number format.
`Ctrl` + `Shift` + `%`	Format Data - Number Formats Apply the Percentage format with no decimal places.
`Ctrl` + `Shift` + `#`	Format Data - Number Formats Apply the Date format with the day, month, and year.
`Ctrl` + `Shift` + `@`	Format Data - Number Formats Apply the Time format with the hour and minute, and indicate A.M. or P.M.
`Ctrl` + `Shift` + `!`	Format Data - Number Formats Apply the Number format with two decimal places, thousands separator, and minus sign (-) for negative values.
`Ctrl` + `Shift` + `^`	Format Data - Number Formats Apply the Scientific number format with two decimal places.
`F4`	Format Data - Number Formats Repeat last formatting action: Apply previously applied Cell Formatting to a different Cell
`Ctrl` + `Shift` + `&`	Format Data - Apply Borders to Cells Apply outline border from cell or selection
`Ctrl` + `Shift` + `_` (underscore)	Format Data - Apply Borders to Cells Remove outline borders from cell or selection
`Ctrl` + `1` , then `Ctrl` + `Arrow Right` / `Arrow Left`	Format Data - Apply Borders to Cells Access border menu in 'Format Cell' dialog. Once border was selected, it will show up directly on the next Ctrl+1
`Alt` + `t` *	Format Data - Apply Borders to Cells Set top border
`Alt` + `b` *	Format Data - Apply Borders to Cells Set bottom Border
`Alt` + `l` *	Format Data - Apply Borders to Cells Set left Border
`Alt` + `r` *	Format Data - Apply Borders to Cells Set right Border
`Alt` + `d` *	Format Data - Apply Borders to Cells Set diagonal and down border
`Alt` + `u` *	Format Data - Apply Borders to Cells Set diagonal and up border
`Alt` + `h` , `a` `r`	Format Data - Align Cells Align Right
`Alt` + `h` , `a` `c`	Format Data - Align Cells Align Center
`Alt` + `h` , `a` `l`	Format Data - Align Cells Align Left
`=`	Format Data - Formulas Start a formula.
`Alt` + `=`	Format Data - Formulas Insert the AutoSum formula.
`Shift` + `F3`	Format Data - Formulas Display the Insert Function dialog box.
`Ctrl` + `A`	Format Data - Formulas Display Formula Window after typing formula name.
`Ctrl` + `Shift` + `A`	Format Data - Formulas Insert Arguments in formula after typing formula name. .
`Shift` + `F3`	Format Data - Formulas Insert a function into a formula .
`Ctrl` + `Shift` + `Enter`	Format Data - Formulas Enter a formula as an array formula.
`F4`	Format Data - Formulas After typing cell reference (e.g. =E3) makes reference absolute (=$E$4)
`F9`	Format Data - Formulas Calculate all worksheets in all open workbooks.
`Shift` + `F9`	Format Data - Formulas Calculate the active worksheet.
`Ctrl` + `Alt` + `F9`	Format Data - Formulas Calculate all worksheets in all open workbooks, regardless of whether they have changed since the last calculation.
`Ctrl` + `Alt` + `Shift` + `F9`	Format Data - Formulas Recheck dependent formulas, and then calculates all cells in all open workbooks, including cells not marked as needing to be calculated.
`Ctrl` + `Shift` + `U`	Format Data - Formulas Toggle expand or collapse formula bar.
`Ctrl` + `	Format Data - Formulas Toggle Show formula in cell instead of values
`Ctrl` + `F3`	Format Data - Names Define a name or dialog.
`Ctrl` + `Shift` + `F3`	Format Data - Names Create names from row and column labels.
`F3`	Format Data - Names Paste a defined name into a formula.
`Arrow Keys`	Format Data - Dialog Boxes Move between options in the active drop-down list box or between some options in a group of options.
`Ctrl` + `Tab` / `Ctrl` + `Shift` + `Tab`	Format Data - Dialog Boxes Switch to the next/ previous tab in dialog box.
`Space`	Format Data - Dialog Boxes In a dialog box: perform the action for the selected button, or select/clear a check box.
`Tab` / `Shift` + `Tab`	Format Data - Dialog Boxes Move to the next / previous option.
`a` ... `z`	Format Data - Dialog Boxes Move to an option in a drop-down list box starting with the letter
`Alt` + `a` ... `alt` + `Z`	Format Data - Dialog Boxes Select an option, or select or clear a check box.
`Alt` + `Arrow Down`	Format Data - Dialog Boxes Open the selected drop-down list box.
`Enter`	Format Data - Dialog Boxes Perform the action assigned to the default command button in the dialog box.
`Esc`	Format Data - Dialog Boxes Cancel the command and close the dialog box.
`Alt` + `Arrow Down`	Format Data - Auto Filter On the field with column head, display the AutoFilter list for the current column .
`Arrow Down` / `Arrow Up`	Format Data - Auto Filter Select the next item / previous item in the AutoFilter list.
`Alt` + `Arrow Up`	Format Data - Auto Filter Close the AutoFilter list for the current column.
`Home` / `End`	Format Data - Auto Filter Select the first item / last item in the AutoFilter list.
`Enter`	Format Data - Auto Filter Filter the list by using the selected item in the AutoFilter list.
`Ctrl` + `Shift` + `L`	Format Data - Auto Filter Apply filter on selected column headings.
`Arrow Keys`	Format Data - Work with Smart Art Graphics Select elements.
`Esc`	Format Data - Work with Smart Art Graphics Remove Focus from Selection.
`F2`	Format Data - Work with Smart Art Graphics Edit Selection Text in if possible (in formula bar).
`Shift` + `Space`	Formulas and Names - Select Cells Select the entire row.
`Ctrl` + `Space`	Formulas and Names - Select Cells Select the entire column.
`Ctrl` + `Shift` + `*` (asterisk)	Formulas and Names - Select Cells Select the current region around the active cell.
`Ctrl` + `a` (or `ctrl` + `Shift` + `spacebar` )	Formulas and Names - Select Cells Select the entire worksheet or the data-containing area. Pressing ctrl+a a second time then selects entire worksheet.
`Ctrl` + `Shift` + `Page Up`	Formulas and Names - Select Cells Select the current and previous sheet in a workbook.
`Ctrl` + `Shift` + `O`	Formulas and Names - Select Cells Select all cells with comments.
`Shift` + `Arrow Keys`	Formulas and Names - Select Cells Extend the selection by one cell.
`Ctrl` + `Shift` + `Arrow Key`	Formulas and Names - Select Cells Extend the selection to the last cell with content in row or column.
`Shift` + `Page Down` / `Shift` + `Page Up`	Formulas and Names - Select Cells Extend the selection down one screen /up one screen.
`Shift` + `Home`	Formulas and Names - Select Cells Extend the selection to the beginning of the row.
`Ctrl` + `Shift` + `Home`	Formulas and Names - Select Cells Extend the selection to the beginning of the worksheet.
`Ctrl` + `Shift` + `End`	Formulas and Names - Select Cells Extend the selection to the last used cell on the worksheet (lower-right corner).
`F8`	Formulas and Names - Manage Active Selections Turn on extension of selection with arrow keys without having to keep pressing shift.
`Shift` + `F8`	Formulas and Names - Manage Active Selections Add another (adjacent or non-adjacent) range of cells to the selection. Use arrow keys and shift+arrow keys to add to selection.
`Shift` + `Backspace`	Formulas and Names - Manage Active Selections Select only the active cell when multiple cells are selected.
`Ctrl` + `Backspace`	Formulas and Names - Manage Active Selections Show active cell within selection.
`Ctrl` + `.` (period)	Formulas and Names - Manage Active Selections Move clockwise to the next corner of the selection.
`Enter` / `Shift` + `Enter`	Formulas and Names - Manage Active Selections Move active cell down / up in a selection.
`Tab` / `Shift` + `Tab`	Formulas and Names - Manage Active Selections Move active cell right / left in a selection.
`Ctrl` + `Alt` + `Arrow Right` / `Ctrl` + `Alt` + `Arrow Left`	Formulas and Names - Manage Active Selections Move to the right / to the left between non-adjacent selections (with multiple ranges selected).
`Esc`	Formulas and Names - Manage Active Selections Cancel Selection.
`Shift` + `Arrow Left` / `Shift` + `Arrow Right`	Formulas and Names - Select inside cells Select or unselect one character to the left / to the right.
`Ctrl` + `Shift` + `Arrow Left` / `Ctrl` + `Shift` + `Arrow Right`	Formulas and Names - Select inside cells Select or unselect one word to the left / to the right.
`Shift` + `Home` / `Shift` + `End`	Formulas and Names - Select inside cells Select from the insertion point to the beginning / to the end of the cell.
`Ctrl` + `Z`	Formulas and Names - Undo / Redo Shortcuts Undo last action (multiple levels).
`Ctrl` + `Y`	Formulas and Names - Undo / Redo Shortcuts Redo last action (multiple levels).
`Ctrl` + `C`	Formulas and Names - Work with Clipboard Copy contents of selected cells.
`Ctrl` + `X`	Formulas and Names - Work with Clipboard Cut contents of selected cells.
`Ctrl` + `V`	Formulas and Names - Work with Clipboard Paste content from clipboard into selected cell.
`Ctrl` + `Alt` + `V`	Formulas and Names - Work with Clipboard If data exists in clipboard: Display the Paste Special dialog box.
`Ctrl` + `Shift` + `[` + `]`	Formulas and Names - Work with Clipboard If data exists in clipboard: Display the Insert dialog box to insert blank cells.
`F2`	Formulas and Names - Edit Inside Cells Edit the active cell with cursor at end of the line.
`Alt` + `Enter`	Formulas and Names - Edit Inside Cells Start a new line in the same cell.
`Enter`	Formulas and Names - Edit Inside Cells Complete a cell entry and move down in the selection. With multiple cells selected: fill cell range with current cell.
`Shift` + `Enter`	Formulas and Names - Edit Inside Cells Complete a cell entry and move up in the selection.
`Tab` / `Shift` + `Tab`	Formulas and Names - Edit Inside Cells Complete a cell entry and move to the right / to the left in the selection.
`Esc`	Formulas and Names - Edit Inside Cells Cancel a cell entry.
`Backspace`	Formulas and Names - Edit Inside Cells Delete the character to the left of the insertion point, or delete the selection.
`Delete`	Formulas and Names - Edit Inside Cells Delete the character to the right of the insertion point, or delete the selection.
`Ctrl` + `Delete`	Formulas and Names - Edit Inside Cells Delete text to the end of the line.
`Ctrl` + `;` (semicolon)	Formulas and Names - Edit Inside Cells Insert current date.
`Ctrl` + `Shift` + `:` (colon)	Formulas and Names - Edit Inside Cells Insert current time.
`Ctrl` + `T`	Formulas and Names - Edit Inside Cells Show all content as standard numbers. (So 14:15 becomes 14.25 etc for the entire file) To undo press ctrl + t again
`Ctrl` + `D`	Formulas and Names - Edit Active or Selected Cells Fill complete cell down (Copy above cell).
`Ctrl` + `R`	Formulas and Names - Edit Active or Selected Cells Fill complete cell to the right (Copy cell from the left).
`Ctrl` + `"`	Formulas and Names - Edit Active or Selected Cells Fill cell values down and edit (Copy above cell values).
`Ctrl` + `'` (apostrophe)	Formulas and Names - Edit Active or Selected Cells Fill cell formulas down and edit (Copy above cell formulas).
`Ctrl` + `L`	Formulas and Names - Edit Active or Selected Cells Insert a table (display Create Table dialog box).
`Ctrl` + `-`	Formulas and Names - Edit Active or Selected Cells Delete Cell/Row/Column Menu
`Ctrl` + `-` with row / column selected	Formulas and Names - Edit Active or Selected Cells Delete row / delete column.
`Ctrl` + `Shift` + `[` + `]`	Formulas and Names - Edit Active or Selected Cells Insert Cell/Row/Column Menu
`Ctrl` + `Shift` + `[` + with row / column selected	Formulas and Names - Edit Active or Selected Cells Insert row/ insert column.
`Shift` + `F2`	Formulas and Names - Edit Active or Selected Cells Insert / Edit a cell comment.
`Shift` + `f10` , then `m`	Formulas and Names - Edit Active or Selected Cells Delete comment.
`Alt` + `F1`	Formulas and Names - Edit Active or Selected Cells Create and insert chart with data in current range as embedded Chart Object.
`F11`	Formulas and Names - Edit Active or Selected Cells Create and insert chart with data in current range in a separate Chart sheet.
`Ctrl` + `K`	Formulas and Names - Edit Active or Selected Cells Insert a hyperlink.
`enter` (in a cell with a hyperlink)	Formulas and Names - Edit Active or Selected Cells Activate a hyperlink.
`Ctrl` + `9`	Formulas and Names - Hide and Show Elements Hide the selected rows.
`Ctrl` + `Shift` + `9`	Formulas and Names - Hide and Show Elements Unhide any hidden rows within the selection.
`Ctrl` + `0` (zero)	Formulas and Names - Hide and Show Elements Hide the selected columns.
`Ctrl` + `Shift` + `0` (zero)	Formulas and Names - Hide and Show Elements *Unhide any hidden columns within the selection.**
`Ctrl` + ` (grave accent)	Formulas and Names - Hide and Show Elements Alternate between displaying cell values and displaying cell formulas. Accent grave /not a quotation mark.
`Alt` + `Shift` + `Arrow Right`	Formulas and Names - Hide and Show Elements Group rows or columns.
`Alt` + `Shift` + `Arrow Left`	Formulas and Names - Hide and Show Elements Ungroup rows or columns.
`Ctrl` + `6`	Formulas and Names - Hide and Show Elements Alternate between hiding and displaying objects.
`Ctrl` + `8`	Formulas and Names - Hide and Show Elements Display or hides the outline symbols.
`Ctrl` + `6`	Formulas and Names - Hide and Show Elements Alternate between hiding objects, displaying objects, and displaying placeholders for objects.
`Alt` + `o` , `c` `a`	Formulas and Names - Adjust Column Width and Row Height Adjust Column width to fit content. Select complete column with Ctrl+Space first, otherwise column adjusts to content of current cell). Remember Format, Column Adjust.
`Alt` + `o` , `c` `w`	Formulas and Names - Adjust Column Width and Row Height Adjust Columns width to specific value: Option, Cow, width
`Alt` + `o` , `r` `a`	Formulas and Names - Adjust Column Width and Row Height Adjust Row height to fit content: Option, Row, Adjust
`Alt` + `o` , `r` `e`	Formulas and Names - Adjust Column Width and Row Height Adjust Row height to specific value: Option, Row, Height
`Ctrl` + `1`	Formulas and Names - Format Cells Format cells dialog.
`Ctrl` + `b` (or `ctrl` + `2` )	Formulas and Names - Format Cells Apply or remove bold formatting.
`Ctrl` + `i` (or `ctrl` + `3` )	Formulas and Names - Format Cells Apply or remove italic formatting.
`Ctrl` + `u` (or `ctrl` + `4` )	Formulas and Names - Format Cells Apply or remove an underline.
`Ctrl` + `5`	Formulas and Names - Format Cells Apply or remove strikethrough formatting.
`Ctrl` + `Shift` + `F`	Formulas and Names - Format Cells Display the Format Cells with Fonts Tab active. Press tab 3x to get to font-size. Used to be ctrl+shift+p, but that seems just get to the Font Tab in 2010.
`Alt` + `'` (apostrophe / single quote)	Formulas and Names - Format Cells Display the Style dialog box.
`Ctrl` + `Shift` + `$`	Formulas and Names - Number Formats Apply the Currency format with two decimal places.
`Ctrl` + `Shift` + `~`	Formulas and Names - Number Formats Apply the General number format.
`Ctrl` + `Shift` + `%`	Formulas and Names - Number Formats Apply the Percentage format with no decimal places.
`Ctrl` + `Shift` + `#`	Formulas and Names - Number Formats Apply the Date format with the day, month, and year.
`Ctrl` + `Shift` + `@`	Formulas and Names - Number Formats Apply the Time format with the hour and minute, and indicate A.M. or P.M.
`Ctrl` + `Shift` + `!`	Formulas and Names - Number Formats Apply the Number format with two decimal places, thousands separator, and minus sign (-) for negative values.
`Ctrl` + `Shift` + `^`	Formulas and Names - Number Formats Apply the Scientific number format with two decimal places.
`F4`	Formulas and Names - Number Formats Repeat last formatting action: Apply previously applied Cell Formatting to a different Cell
`Ctrl` + `Shift` + `&`	Formulas and Names - Apply Borders to Cells Apply outline border from cell or selection
`Ctrl` + `Shift` + `_` (underscore)	Formulas and Names - Apply Borders to Cells Remove outline borders from cell or selection
`Ctrl` + `1` , then `Ctrl` + `Arrow Right` / `Arrow Left`	Formulas and Names - Apply Borders to Cells Access border menu in 'Format Cell' dialog. Once border was selected, it will show up directly on the next Ctrl+1
`Alt` + `t` *	Formulas and Names - Apply Borders to Cells Set top border
`Alt` + `b` *	Formulas and Names - Apply Borders to Cells Set bottom Border
`Alt` + `l` *	Formulas and Names - Apply Borders to Cells Set left Border
`Alt` + `r` *	Formulas and Names - Apply Borders to Cells Set right Border
`Alt` + `d` *	Formulas and Names - Apply Borders to Cells Set diagonal and down border
`Alt` + `u` *	Formulas and Names - Apply Borders to Cells Set diagonal and up border
`Alt` + `h` , `a` `r`	Formulas and Names - Align Cells Align Right
`Alt` + `h` , `a` `c`	Formulas and Names - Align Cells Align Center
`Alt` + `h` , `a` `l`	Formulas and Names - Align Cells Align Left
`=`	Formulas and Names - Formulas Start a formula.
`Alt` + `=`	Formulas and Names - Formulas Insert the AutoSum formula.
`Shift` + `F3`	Formulas and Names - Formulas Display the Insert Function dialog box.
`Ctrl` + `A`	Formulas and Names - Formulas Display Formula Window after typing formula name.
`Ctrl` + `Shift` + `A`	Formulas and Names - Formulas Insert Arguments in formula after typing formula name. .
`Shift` + `F3`	Formulas and Names - Formulas Insert a function into a formula .
`Ctrl` + `Shift` + `Enter`	Formulas and Names - Formulas Enter a formula as an array formula.
`F4`	Formulas and Names - Formulas After typing cell reference (e.g. =E3) makes reference absolute (=$E$4)
`F9`	Formulas and Names - Formulas Calculate all worksheets in all open workbooks.
`Shift` + `F9`	Formulas and Names - Formulas Calculate the active worksheet.
`Ctrl` + `Alt` + `F9`	Formulas and Names - Formulas Calculate all worksheets in all open workbooks, regardless of whether they have changed since the last calculation.
`Ctrl` + `Alt` + `Shift` + `F9`	Formulas and Names - Formulas Recheck dependent formulas, and then calculates all cells in all open workbooks, including cells not marked as needing to be calculated.
`Ctrl` + `Shift` + `U`	Formulas and Names - Formulas Toggle expand or collapse formula bar.
`Ctrl` + `	Formulas and Names - Formulas Toggle Show formula in cell instead of values
`Ctrl` + `F3`	Formulas and Names - Names Define a name or dialog.
`Ctrl` + `Shift` + `F3`	Formulas and Names - Names Create names from row and column labels.
`F3`	Formulas and Names - Names Paste a defined name into a formula.
`Arrow Keys`	Formulas and Names - Dialog Boxes Move between options in the active drop-down list box or between some options in a group of options.
`Ctrl` + `Tab` / `Ctrl` + `Shift` + `Tab`	Formulas and Names - Dialog Boxes Switch to the next/ previous tab in dialog box.
`Space`	Formulas and Names - Dialog Boxes In a dialog box: perform the action for the selected button, or select/clear a check box.
`Tab` / `Shift` + `Tab`	Formulas and Names - Dialog Boxes Move to the next / previous option.
`a` ... `z`	Formulas and Names - Dialog Boxes Move to an option in a drop-down list box starting with the letter
`Alt` + `a` ... `alt` + `Z`	Formulas and Names - Dialog Boxes Select an option, or select or clear a check box.
`Alt` + `Arrow Down`	Formulas and Names - Dialog Boxes Open the selected drop-down list box.
`Enter`	Formulas and Names - Dialog Boxes Perform the action assigned to the default command button in the dialog box.
`Esc`	Formulas and Names - Dialog Boxes Cancel the command and close the dialog box.
`Alt` + `Arrow Down`	Formulas and Names - Auto Filter On the field with column head, display the AutoFilter list for the current column .
`Arrow Down` / `Arrow Up`	Formulas and Names - Auto Filter Select the next item / previous item in the AutoFilter list.
`Alt` + `Arrow Up`	Formulas and Names - Auto Filter Close the AutoFilter list for the current column.
`Home` / `End`	Formulas and Names - Auto Filter Select the first item / last item in the AutoFilter list.
`Enter`	Formulas and Names - Auto Filter Filter the list by using the selected item in the AutoFilter list.
`Ctrl` + `Shift` + `L`	Formulas and Names - Auto Filter Apply filter on selected column headings.
`Arrow Keys`	Formulas and Names - Work with Smart Art Graphics Select elements.
`Esc`	Formulas and Names - Work with Smart Art Graphics Remove Focus from Selection.
`F2`	Formulas and Names - Work with Smart Art Graphics Edit Selection Text in if possible (in formula bar).
`Shift` + `Space`	The Rest - Select Cells Select the entire row.
`Ctrl` + `Space`	The Rest - Select Cells Select the entire column.
`Ctrl` + `Shift` + `*` (asterisk)	The Rest - Select Cells Select the current region around the active cell.
`Ctrl` + `a` (or `ctrl` + `Shift` + `spacebar` )	The Rest - Select Cells Select the entire worksheet or the data-containing area. Pressing ctrl+a a second time then selects entire worksheet.
`Ctrl` + `Shift` + `Page Up`	The Rest - Select Cells Select the current and previous sheet in a workbook.
`Ctrl` + `Shift` + `O`	The Rest - Select Cells Select all cells with comments.
`Shift` + `Arrow Keys`	The Rest - Select Cells Extend the selection by one cell.
`Ctrl` + `Shift` + `Arrow Key`	The Rest - Select Cells Extend the selection to the last cell with content in row or column.
`Shift` + `Page Down` / `Shift` + `Page Up`	The Rest - Select Cells Extend the selection down one screen /up one screen.
`Shift` + `Home`	The Rest - Select Cells Extend the selection to the beginning of the row.
`Ctrl` + `Shift` + `Home`	The Rest - Select Cells Extend the selection to the beginning of the worksheet.
`Ctrl` + `Shift` + `End`	The Rest - Select Cells Extend the selection to the last used cell on the worksheet (lower-right corner).
`F8`	The Rest - Manage Active Selections Turn on extension of selection with arrow keys without having to keep pressing shift.
`Shift` + `F8`	The Rest - Manage Active Selections Add another (adjacent or non-adjacent) range of cells to the selection. Use arrow keys and shift+arrow keys to add to selection.
`Shift` + `Backspace`	The Rest - Manage Active Selections Select only the active cell when multiple cells are selected.
`Ctrl` + `Backspace`	The Rest - Manage Active Selections Show active cell within selection.
`Ctrl` + `.` (period)	The Rest - Manage Active Selections Move clockwise to the next corner of the selection.
`Enter` / `Shift` + `Enter`	The Rest - Manage Active Selections Move active cell down / up in a selection.
`Tab` / `Shift` + `Tab`	The Rest - Manage Active Selections Move active cell right / left in a selection.
`Ctrl` + `Alt` + `Arrow Right` / `Ctrl` + `Alt` + `Arrow Left`	The Rest - Manage Active Selections Move to the right / to the left between non-adjacent selections (with multiple ranges selected).
`Esc`	The Rest - Manage Active Selections Cancel Selection.
`Shift` + `Arrow Left` / `Shift` + `Arrow Right`	The Rest - Select inside cells Select or unselect one character to the left / to the right.
`Ctrl` + `Shift` + `Arrow Left` / `Ctrl` + `Shift` + `Arrow Right`	The Rest - Select inside cells Select or unselect one word to the left / to the right.
`Shift` + `Home` / `Shift` + `End`	The Rest - Select inside cells Select from the insertion point to the beginning / to the end of the cell.
`Ctrl` + `Z`	The Rest - Undo / Redo Shortcuts Undo last action (multiple levels).
`Ctrl` + `Y`	The Rest - Undo / Redo Shortcuts Redo last action (multiple levels).
`Ctrl` + `C`	The Rest - Work with Clipboard Copy contents of selected cells.
`Ctrl` + `X`	The Rest - Work with Clipboard Cut contents of selected cells.
`Ctrl` + `V`	The Rest - Work with Clipboard Paste content from clipboard into selected cell.
`Ctrl` + `Alt` + `V`	The Rest - Work with Clipboard If data exists in clipboard: Display the Paste Special dialog box.
`Ctrl` + `Shift` + `[` + `]`	The Rest - Work with Clipboard If data exists in clipboard: Display the Insert dialog box to insert blank cells.
`F2`	The Rest - Edit Inside Cells Edit the active cell with cursor at end of the line.
`Alt` + `Enter`	The Rest - Edit Inside Cells Start a new line in the same cell.
`Enter`	The Rest - Edit Inside Cells Complete a cell entry and move down in the selection. With multiple cells selected: fill cell range with current cell.
`Shift` + `Enter`	The Rest - Edit Inside Cells Complete a cell entry and move up in the selection.
`Tab` / `Shift` + `Tab`	The Rest - Edit Inside Cells Complete a cell entry and move to the right / to the left in the selection.
`Esc`	The Rest - Edit Inside Cells Cancel a cell entry.
`Backspace`	The Rest - Edit Inside Cells Delete the character to the left of the insertion point, or delete the selection.
`Delete`	The Rest - Edit Inside Cells Delete the character to the right of the insertion point, or delete the selection.
`Ctrl` + `Delete`	The Rest - Edit Inside Cells Delete text to the end of the line.
`Ctrl` + `;` (semicolon)	The Rest - Edit Inside Cells Insert current date.
`Ctrl` + `Shift` + `:` (colon)	The Rest - Edit Inside Cells Insert current time.
`Ctrl` + `T`	The Rest - Edit Inside Cells Show all content as standard numbers. (So 14:15 becomes 14.25 etc for the entire file) To undo press ctrl + t again
`Ctrl` + `D`	The Rest - Edit Active or Selected Cells Fill complete cell down (Copy above cell).
`Ctrl` + `R`	The Rest - Edit Active or Selected Cells Fill complete cell to the right (Copy cell from the left).
`Ctrl` + `"`	The Rest - Edit Active or Selected Cells Fill cell values down and edit (Copy above cell values).
`Ctrl` + `'` (apostrophe)	The Rest - Edit Active or Selected Cells Fill cell formulas down and edit (Copy above cell formulas).
`Ctrl` + `L`	The Rest - Edit Active or Selected Cells Insert a table (display Create Table dialog box).
`Ctrl` + `-`	The Rest - Edit Active or Selected Cells Delete Cell/Row/Column Menu
`Ctrl` + `-` with row / column selected	The Rest - Edit Active or Selected Cells Delete row / delete column.
`Ctrl` + `Shift` + `[` + `]`	The Rest - Edit Active or Selected Cells Insert Cell/Row/Column Menu
`Ctrl` + `Shift` + `[` + with row / column selected	The Rest - Edit Active or Selected Cells Insert row/ insert column.
`Shift` + `F2`	The Rest - Edit Active or Selected Cells Insert / Edit a cell comment.
`Shift` + `f10` , then `m`	The Rest - Edit Active or Selected Cells Delete comment.
`Alt` + `F1`	The Rest - Edit Active or Selected Cells Create and insert chart with data in current range as embedded Chart Object.
`F11`	The Rest - Edit Active or Selected Cells Create and insert chart with data in current range in a separate Chart sheet.
`Ctrl` + `K`	The Rest - Edit Active or Selected Cells Insert a hyperlink.
`enter` (in a cell with a hyperlink)	The Rest - Edit Active or Selected Cells Activate a hyperlink.
`Ctrl` + `9`	The Rest - Hide and Show Elements Hide the selected rows.
`Ctrl` + `Shift` + `9`	The Rest - Hide and Show Elements Unhide any hidden rows within the selection.
`Ctrl` + `0` (zero)	The Rest - Hide and Show Elements Hide the selected columns.
`Ctrl` + `Shift` + `0` (zero)	The Rest - Hide and Show Elements *Unhide any hidden columns within the selection.**
`Ctrl` + ` (grave accent)	The Rest - Hide and Show Elements Alternate between displaying cell values and displaying cell formulas. Accent grave /not a quotation mark.
`Alt` + `Shift` + `Arrow Right`	The Rest - Hide and Show Elements Group rows or columns.
`Alt` + `Shift` + `Arrow Left`	The Rest - Hide and Show Elements Ungroup rows or columns.
`Ctrl` + `6`	The Rest - Hide and Show Elements Alternate between hiding and displaying objects.
`Ctrl` + `8`	The Rest - Hide and Show Elements Display or hides the outline symbols.
`Ctrl` + `6`	The Rest - Hide and Show Elements Alternate between hiding objects, displaying objects, and displaying placeholders for objects.
`Alt` + `o` , `c` `a`	The Rest - Adjust Column Width and Row Height Adjust Column width to fit content. Select complete column with Ctrl+Space first, otherwise column adjusts to content of current cell). Remember Format, Column Adjust.
`Alt` + `o` , `c` `w`	The Rest - Adjust Column Width and Row Height Adjust Columns width to specific value: Option, Cow, width
`Alt` + `o` , `r` `a`	The Rest - Adjust Column Width and Row Height Adjust Row height to fit content: Option, Row, Adjust
`Alt` + `o` , `r` `e`	The Rest - Adjust Column Width and Row Height Adjust Row height to specific value: Option, Row, Height
`Ctrl` + `1`	The Rest - Format Cells Format cells dialog.
`Ctrl` + `b` (or `ctrl` + `2` )	The Rest - Format Cells Apply or remove bold formatting.
`Ctrl` + `i` (or `ctrl` + `3` )	The Rest - Format Cells Apply or remove italic formatting.
`Ctrl` + `u` (or `ctrl` + `4` )	The Rest - Format Cells Apply or remove an underline.
`Ctrl` + `5`	The Rest - Format Cells Apply or remove strikethrough formatting.
`Ctrl` + `Shift` + `F`	The Rest - Format Cells Display the Format Cells with Fonts Tab active. Press tab 3x to get to font-size. Used to be ctrl+shift+p, but that seems just get to the Font Tab in 2010.
`Alt` + `'` (apostrophe / single quote)	The Rest - Format Cells Display the Style dialog box.
`Ctrl` + `Shift` + `$`	The Rest - Number Formats Apply the Currency format with two decimal places.
`Ctrl` + `Shift` + `~`	The Rest - Number Formats Apply the General number format.
`Ctrl` + `Shift` + `%`	The Rest - Number Formats Apply the Percentage format with no decimal places.
`Ctrl` + `Shift` + `#`	The Rest - Number Formats Apply the Date format with the day, month, and year.
`Ctrl` + `Shift` + `@`	The Rest - Number Formats Apply the Time format with the hour and minute, and indicate A.M. or P.M.
`Ctrl` + `Shift` + `!`	The Rest - Number Formats Apply the Number format with two decimal places, thousands separator, and minus sign (-) for negative values.
`Ctrl` + `Shift` + `^`	The Rest - Number Formats Apply the Scientific number format with two decimal places.
`F4`	The Rest - Number Formats Repeat last formatting action: Apply previously applied Cell Formatting to a different Cell
`Ctrl` + `Shift` + `&`	The Rest - Apply Borders to Cells Apply outline border from cell or selection
`Ctrl` + `Shift` + `_` (underscore)	The Rest - Apply Borders to Cells Remove outline borders from cell or selection
`Ctrl` + `1` , then `Ctrl` + `Arrow Right` / `Arrow Left`	The Rest - Apply Borders to Cells Access border menu in 'Format Cell' dialog. Once border was selected, it will show up directly on the next Ctrl+1
`Alt` + `t` *	The Rest - Apply Borders to Cells Set top border
`Alt` + `b` *	The Rest - Apply Borders to Cells Set bottom Border
`Alt` + `l` *	The Rest - Apply Borders to Cells Set left Border
`Alt` + `r` *	The Rest - Apply Borders to Cells Set right Border
`Alt` + `d` *	The Rest - Apply Borders to Cells Set diagonal and down border
`Alt` + `u` *	The Rest - Apply Borders to Cells Set diagonal and up border
`Alt` + `h` , `a` `r`	The Rest - Align Cells Align Right
`Alt` + `h` , `a` `c`	The Rest - Align Cells Align Center
`Alt` + `h` , `a` `l`	The Rest - Align Cells Align Left
`=`	The Rest - Formulas Start a formula.
`Alt` + `=`	The Rest - Formulas Insert the AutoSum formula.
`Shift` + `F3`	The Rest - Formulas Display the Insert Function dialog box.
`Ctrl` + `A`	The Rest - Formulas Display Formula Window after typing formula name.
`Ctrl` + `Shift` + `A`	The Rest - Formulas Insert Arguments in formula after typing formula name. .
`Shift` + `F3`	The Rest - Formulas Insert a function into a formula .
`Ctrl` + `Shift` + `Enter`	The Rest - Formulas Enter a formula as an array formula.
`F4`	The Rest - Formulas After typing cell reference (e.g. =E3) makes reference absolute (=$E$4)
`F9`	The Rest - Formulas Calculate all worksheets in all open workbooks.
`Shift` + `F9`	The Rest - Formulas Calculate the active worksheet.
`Ctrl` + `Alt` + `F9`	The Rest - Formulas Calculate all worksheets in all open workbooks, regardless of whether they have changed since the last calculation.
`Ctrl` + `Alt` + `Shift` + `F9`	The Rest - Formulas Recheck dependent formulas, and then calculates all cells in all open workbooks, including cells not marked as needing to be calculated.
`Ctrl` + `Shift` + `U`	The Rest - Formulas Toggle expand or collapse formula bar.
`Ctrl` + `	The Rest - Formulas Toggle Show formula in cell instead of values
`Ctrl` + `F3`	The Rest - Names Define a name or dialog.
`Ctrl` + `Shift` + `F3`	The Rest - Names Create names from row and column labels.
`F3`	The Rest - Names Paste a defined name into a formula.
`Arrow Keys`	The Rest - Dialog Boxes Move between options in the active drop-down list box or between some options in a group of options.
`Ctrl` + `Tab` / `Ctrl` + `Shift` + `Tab`	The Rest - Dialog Boxes Switch to the next/ previous tab in dialog box.
`Space`	The Rest - Dialog Boxes In a dialog box: perform the action for the selected button, or select/clear a check box.
`Tab` / `Shift` + `Tab`	The Rest - Dialog Boxes Move to the next / previous option.
`a` ... `z`	The Rest - Dialog Boxes Move to an option in a drop-down list box starting with the letter
`Alt` + `a` ... `alt` + `Z`	The Rest - Dialog Boxes Select an option, or select or clear a check box.
`Alt` + `Arrow Down`	The Rest - Dialog Boxes Open the selected drop-down list box.
`Enter`	The Rest - Dialog Boxes Perform the action assigned to the default command button in the dialog box.
`Esc`	The Rest - Dialog Boxes Cancel the command and close the dialog box.
`Alt` + `Arrow Down`	The Rest - Auto Filter On the field with column head, display the AutoFilter list for the current column .
`Arrow Down` / `Arrow Up`	The Rest - Auto Filter Select the next item / previous item in the AutoFilter list.
`Alt` + `Arrow Up`	The Rest - Auto Filter Close the AutoFilter list for the current column.
`Home` / `End`	The Rest - Auto Filter Select the first item / last item in the AutoFilter list.
`Enter`	The Rest - Auto Filter Filter the list by using the selected item in the AutoFilter list.
`Ctrl` + `Shift` + `L`	The Rest - Auto Filter Apply filter on selected column headings.
`Arrow Keys`	The Rest - Work with Smart Art Graphics Select elements.
`Esc`	The Rest - Work with Smart Art Graphics Remove Focus from Selection.
`F2`	The Rest - Work with Smart Art Graphics Edit Selection Text in if possible (in formula bar).
`Arrow Keys`	Navigate Inside Worksheets Move one cell up, down, left, or right in a worksheet.
`Page Down` / `Page Up`	Navigate Inside Worksheets Move one screen down / one screen up in a worksheet.
`Alt` + `Page Down` / `Alt` + `Page Up`	Navigate Inside Worksheets Move one screen to the right / to the left in a worksheet.
`Tab` / `Shift` + `Tab`	Navigate Inside Worksheets Move one cell to the right / to the left in a worksheet.
`Ctrl` + `Arrow Keys`	Navigate Inside Worksheets Move to the edge of next data region (cells that contains data)
`Home`	Navigate Inside Worksheets Move to the beginning of a row in a worksheet.
`Ctrl` + `Home`	Navigate Inside Worksheets Move to the beginning of a worksheet.
`Ctrl` + `End`	Navigate Inside Worksheets Move to the last cell with content on a worksheet.
`Ctrl` + `F`	Navigate Inside Worksheets Display the Find and Replace dialog box (with Find selected).
`Ctrl` + `H`	Navigate Inside Worksheets Display the Find and Replace dialog box (with Replace selected).
`Shift` + `F4`	Navigate Inside Worksheets Repeat last find.
`Ctrl` + `g` (or `f5` )	Navigate Inside Worksheets Display the 'Go To' dialog box.
`Ctrl` + `Arrow Left` / `Ctrl` + `Arrow Right`	Navigate Inside Worksheets Inside a cell: Move one word to the left / to the right.
`Home` / `End`	Navigate Inside Worksheets Inside a cell: Move to the beginning / to the end of a cell entry.
`Alt` + `Arrow Down`	Navigate Inside Worksheets Display the AutoComplete list e.g. in cell with dropdowns or autofilter.
`End`	Navigate Inside Worksheets Turn 'End' mode on. In End mode, press arrow keys to move to the next nonblank cell in the same column or row as the active cell. From here use arrow keys to move by blocks of data, home to move to last cell, or enter to move to the last cell to the right.
`Shift` + `F11` / `Alt` + `Shift` + `F1`	Manage Multipe Worksheets Insert a new worksheet in current workbook.
`Ctrl` + `Page Down` / `Ctrl` + `Page Up`	Manage Multipe Worksheets Move to the next / previous worksheet in current workbook.
`Shift` + `Ctrl` + `Page Down` / `Shift` + `Ctrl` + `Page Up`	Manage Multipe Worksheets Select the current and next sheet(s) / select and previous sheet(s).
`Alt` + `o` then `h` `r`	Manage Multipe Worksheets Rename current worksheet (format, sheet, rename)
`Alt` + `e` then `l`	Manage Multipe Worksheets Delete current worksheet (Edit, delete)
`Alt` + `e` then `m`	Manage Multipe Worksheets Move current worksheet (Edit, move)
`F6` / `Shift` + `F6`	Manage Multiple Workbooks Move to the next pane / previous pane in a workbook that has been split.
`Ctrl` + `F4`	Manage Multiple Workbooks Close the selected workbook window.
`Ctrl` + `N`	Manage Multiple Workbooks Create a new blank workbook (Excel File)
`Ctrl` + `Tab` / `Ctrl` + `Shift` + `Tab`	Manage Multiple Workbooks Move to next / previous workbook window.
`Alt` + `Space`	Manage Multiple Workbooks Display the Control menu for Main Excel window.
`Ctrl` + `F9`	Manage Multiple Workbooks Minimize current workbook window to an icon. Also restores ('un-maximizes') all workbook windows.
`Ctrl` + `F10`	Manage Multiple Workbooks Maximize or restores the selected workbook window.
`Ctrl` + `F7`	Manage Multiple Workbooks Move Workbook Windows which are not maximized.
`Ctrl` + `F8`	Manage Multiple Workbooks Perform size command for workbook windows which are not maximzed.
`Alt` + `F4`	Manage Multiple Workbooks Close Excel.
`Ctrl` + `O`	Various Excel Features Open File.
`Ctrl` + `S`	Various Excel Features Save the active file with its current file name, location, and file format.
`F12`	Various Excel Features Display the Save As dialog box.
`f10` (or `alt` )	Various Excel Features Turn key tips on or off.
`Ctrl` + `P`	Various Excel Features Print File (Opens print menu).
`F1`	Various Excel Features Display the Excel Help task pane.
`F7`	Various Excel Features Display the Spelling dialog box.
`Shift` + `F7`	Various Excel Features Display the Thesaurus dialog box.
`Alt` + `F8`	Various Excel Features Display the Macro dialog box.
`Alt` + `F11`	Various Excel Features Open the Visual Basic Editor to create Macros.
`Ctrl` + `F1`	Work with the Excel Ribbon Minimize or restore the Ribbon.s
`Alt` / `F10`	Work with the Excel Ribbon Select the active tab of the Ribbon and activate the access keys. Press either of these keys again to move back to the document and cancel the access keys. and then arrow left or arrow right
`Shift` + `F10`	Work with the Excel Ribbon Display the shortcut menu for the selected command.
`Space` / `Enter`	Work with the Excel Ribbon Activate the selected command or control in the Ribbon, Open the selected menu or gallery in the Ribbon..
`Enter`	Work with the Excel Ribbon Finish modifying a value in a control in the Ribbon, and move focus back to the document.
`F1`	Work with the Excel Ribbon Get help on the selected command or control in the Ribbon. (If no Help topic is associated with the selected command, the Help table of contents for that program is shown instead.)
`Tab` / `Shift` + `Tab`	Data Forms Move to the next / previous field which can be edited.
`Enter` / `Shift` + `Enter`	Data Forms Move to the first field in the next / previous record.
`Page Down` / `Page Up`	Data Forms Move to the same field 10 records forward / back.
`Ctrl` + `Page Down`	Data Forms Move to a new record.
`Ctrl` + `Page Up`	Data Forms Move to the first record.
`Home` / `End`	Data Forms Move to the beginning / end of a field.
`Arrow Keys`	Pivot Tables Navigate inside Pivot tables.
`Home` / `End`	Pivot Tables Select the first / last visible item in the list.
`Alt` + `C`	Pivot Tables Move the selected field into the Column area.
`Alt` + `D`	Pivot Tables Move the selected field into the Data area.
`Alt` + `L`	Pivot Tables Display the PivotTable Field dialog box.
`Alt` + `P`	Pivot Tables Move the selected field into the Page area.
`Alt` + `R`	Pivot Tables Move the selected field into the Row area.
`Ctrl` + `Shift` +* (asterisk)	Pivot Tables Select the entire PivotTable report.
`arrow keys` to select the cell that contains the field, and then `alt` + `Arrow Down`	Pivot Tables Display the list for the current field in a PivotTable report.
`arrow keys` to select the page field in a PivotChart report, and then `alt` + `Arrow Down`	Pivot Tables Display the list for the current page field in a PivotChart report.
`Enter`	Pivot Tables Display the selected item.
`Space`	Pivot Tables Select or clear a check box in the list.
`Ctrl` + `tab` `ctrl` + `Shift` + `Tab`	Pivot Tables select the PivotTable toolbar.
`enter` then `arrow down` / `Arrow Up`	Pivot Tables On a field button: select the area you want to move the selected field to.
`Alt` + `Shift` + `Arrow Right`	Pivot Tables Group selected PivotTable items.
`Alt` + `Shift` + `Arrow Left`	Pivot Tables Ungroup selected PivotTable items.

Hotkeys and shortcuts for Microsoft Excel 2010 (Windows)

(Total 740)

Shift + Space

Work with Data Selections - Select Cells

Select the entire row.

Ctrl + Space

Work with Data Selections - Select Cells

Select the entire column.

Ctrl + Shift + * (asterisk)

Work with Data Selections - Select Cells

Select the current region around the active cell.

Ctrl + a (or ctrl + Shift + spacebar )

Work with Data Selections - Select Cells

Select the entire worksheet or the data-containing area. Pressing ctrl+a a second time then selects entire worksheet.

Ctrl + Shift + Page Up

Work with Data Selections - Select Cells

Select the current and previous sheet in a workbook.

Ctrl + Shift + O

Work with Data Selections - Select Cells

Select all cells with comments.

Shift + Arrow Keys

Work with Data Selections - Select Cells

Extend the selection by one cell.

Ctrl + Shift + Arrow Key

Work with Data Selections - Select Cells

Extend the selection to the last cell with content in row or column.

Shift + Page Down / Shift + Page Up

Work with Data Selections - Select Cells

Extend the selection down one screen /up one screen.

Shift + Home

Work with Data Selections - Select Cells

Extend the selection to the beginning of the row.

Ctrl + Shift + Home

Work with Data Selections - Select Cells

Extend the selection to the beginning of the worksheet.

Ctrl + Shift + End

Work with Data Selections - Select Cells

Extend the selection to the last used cell on the worksheet (lower-right corner).

F8

Work with Data Selections - Manage Active Selections

Turn on extension of selection with arrow keys without having to keep pressing shift.

Shift + F8

Work with Data Selections - Manage Active Selections

Add another (adjacent or non-adjacent) range of cells to the selection. Use arrow keys and shift+arrow keys to add to selection.

Shift + Backspace

Work with Data Selections - Manage Active Selections

Select only the active cell when multiple cells are selected.

Ctrl + Backspace

Work with Data Selections - Manage Active Selections

Show active cell within selection.

Ctrl + . (period)

Work with Data Selections - Manage Active Selections

Move clockwise to the next corner of the selection.

Enter / Shift + Enter

Work with Data Selections - Manage Active Selections

Move active cell down / up in a selection.

Tab / Shift + Tab

Work with Data Selections - Manage Active Selections

Move active cell right / left in a selection.

Ctrl + Alt + Arrow Right / Ctrl + Alt + Arrow Left

Work with Data Selections - Manage Active Selections

Move to the right / to the left between non-adjacent selections (with multiple ranges selected).

Esc

Work with Data Selections - Manage Active Selections

Cancel Selection.

Shift + Arrow Left / Shift + Arrow Right

Work with Data Selections - Select inside cells

Select or unselect one character to the left / to the right.

Ctrl + Shift + Arrow Left / Ctrl + Shift + Arrow Right

Work with Data Selections - Select inside cells

Select or unselect one word to the left / to the right.

Shift + Home / Shift + End

Work with Data Selections - Select inside cells

Select from the insertion point to the beginning / to the end of the cell.

Ctrl + Z

Work with Data Selections - Undo / Redo Shortcuts

Undo last action (multiple levels).

Ctrl + Y

Work with Data Selections - Undo / Redo Shortcuts

Redo last action (multiple levels).

`Shift` + `Space`

`Ctrl` + `Space`

`Ctrl` + `Shift` + `*` (asterisk)

`Ctrl` + `a` (or `ctrl` + `Shift` + `spacebar` )

`Ctrl` + `Shift` + `Page Up`

`Ctrl` + `Shift` + `O`

`Shift` + `Arrow Keys`

`Ctrl` + `Shift` + `Arrow Key`

`Shift` + `Page Down` / `Shift` + `Page Up`

`Shift` + `Home`

`Ctrl` + `Shift` + `Home`

`Ctrl` + `Shift` + `End`

`F8`

`Shift` + `F8`

`Shift` + `Backspace`

`Ctrl` + `Backspace`

`Ctrl` + `.` (period)

`Enter` / `Shift` + `Enter`

`Tab` / `Shift` + `Tab`

`Ctrl` + `Alt` + `Arrow Right` / `Ctrl` + `Alt` + `Arrow Left`

`Esc`

`Shift` + `Arrow Left` / `Shift` + `Arrow Right`

`Ctrl` + `Shift` + `Arrow Left` / `Ctrl` + `Shift` + `Arrow Right`

`Shift` + `Home` / `Shift` + `End`

`Ctrl` + `Z`

`Ctrl` + `Y`

`Ctrl` + `C`

`Ctrl` + `X`

`Ctrl` + `V`

`Ctrl` + `Alt` + `V`

`Ctrl` + `Shift` + `[` + `]`

`F2`

`Alt` + `Enter`

`Enter`

`Shift` + `Enter`

`Tab` / `Shift` + `Tab`

`Esc`

`Backspace`

`Delete`

`Ctrl` + `Delete`

`Ctrl` + `;` (semicolon)

`Ctrl` + `Shift` + `:` (colon)

`Ctrl` + `T`

`Ctrl` + `D`

`Ctrl` + `R`

`Ctrl` + `"`

`Ctrl` + `'` (apostrophe)

`Ctrl` + `L`

`Ctrl` + `-`

`Ctrl` + `-` with row / column selected