Microsoft Excel 2010 (Windows)

The Rest - Manage Active Selections

Move active cell down / up in a selection.

Enter / Shift + Enter

All hotkeys for Microsoft Excel 2010 (Windows)

Work with Data Selections - Select Cells
Select the entire row.

Shift + Space

Work with Data Selections - Select Cells
Select the entire column.

Ctrl + Space

Work with Data Selections - Select Cells
Select the current region around the active cell.

Ctrl + Shift + * (asterisk)

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 + a (or ctrl + Shift + spacebar )

Work with Data Selections - Select Cells
Select the current and previous sheet in a workbook.

Ctrl + Shift + Page Up

Work with Data Selections - Select Cells
Select all cells with comments.

Ctrl + Shift + O

Work with Data Selections - Select Cells
Extend the selection by one cell.

Shift + Arrow Keys

Work with Data Selections - Select Cells
Extend the selection to the last cell with content in row or column.

Ctrl + Shift + Arrow Key

Work with Data Selections - Select Cells
Extend the selection down one screen /up one screen.

Shift + Page Down / Shift + Page Up

Work with Data Selections - Select Cells
Extend the selection to the beginning of the row.

Shift + Home

Work with Data Selections - Select Cells
Extend the selection to the beginning of the worksheet.

Ctrl + Shift + Home

Work with Data Selections - Select Cells
Extend the selection to the last used cell on the worksheet (lower-right corner).

Ctrl + Shift + End

Work with Data Selections - Manage Active Selections
Turn on extension of selection with arrow keys without having to keep pressing 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 + F8

Work with Data Selections - Manage Active Selections
Select only the active cell when multiple cells are selected.

Shift + Backspace

Work with Data Selections - Manage Active Selections
Show active cell within selection.

Ctrl + Backspace

Work with Data Selections - Manage Active Selections
Move clockwise to the next corner of the selection.

Ctrl + . (period)

Work with Data Selections - Manage Active Selections
Move active cell down / up in a selection.

Enter / Shift + Enter

Work with Data Selections - Manage Active Selections
Move active cell right / left in a selection.

Tab / Shift + Tab

Work with Data Selections - Manage Active Selections
Move to the right / to the left between non-adjacent selections (with multiple ranges selected).

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

Work with Data Selections - Manage Active Selections
Cancel Selection.

Esc

Work with Data Selections - Select inside cells
Select or unselect one character to the left / to the right.

Shift + Arrow Left / Shift + Arrow Right

Work with Data Selections - Select inside cells
Select or unselect one word to the left / to the right.

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

Work with Data Selections - Select inside cells
Select from the insertion point to the beginning / to the end of the cell.

Shift + Home / Shift + End

Work with Data Selections - Undo / Redo Shortcuts
Undo last action (multiple levels).

Ctrl + Z

Work with Data Selections - Undo / Redo Shortcuts
Redo last action (multiple levels).

Ctrl + Y

Work with Data Selections - Work with Clipboard
Copy contents of selected cells.

Ctrl + C

Work with Data Selections - Work with Clipboard
Cut contents of selected cells.

Ctrl + X

Work with Data Selections - Work with Clipboard
Paste content from clipboard into selected cell.

Ctrl + V

Work with Data Selections - Work with Clipboard
If data exists in clipboard: Display the Paste Special dialog box.

Ctrl + Alt + V

Work with Data Selections - Work with Clipboard
If data exists in clipboard: Display the Insert dialog box to insert blank cells.

Ctrl + Shift + [ + ]

Work with Data Selections - Edit Inside Cells
Edit the active cell with cursor at end of the line.

F2

Work with Data Selections - Edit Inside Cells
Start a new line in the same cell.

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

Enter

Work with Data Selections - Edit Inside Cells
Complete a cell entry and move up in the selection.

Shift + Enter

Work with Data Selections - Edit Inside Cells
Complete a cell entry and move to the right / to the left in the selection.

Tab / Shift + Tab

Work with Data Selections - Edit Inside Cells
Cancel a cell entry.

Esc

Work with Data Selections - Edit Inside Cells
Delete the character to the left of the insertion point, or delete the selection.

Backspace

Work with Data Selections - Edit Inside Cells
Delete the character to the right of the insertion point, or delete the selection.

Delete

Work with Data Selections - Edit Inside Cells
Delete text to the end of the line.

Ctrl + Delete

Work with Data Selections - Edit Inside Cells
Insert current date.

Ctrl + ; (semicolon)

Work with Data Selections - Edit Inside Cells
Insert current time.

Ctrl + Shift + : (colon)

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 + T

Work with Data Selections - Edit Active or Selected Cells
Fill complete cell down (Copy above cell).

Ctrl + D

Work with Data Selections - Edit Active or Selected Cells
Fill complete cell to the right (Copy cell from the left).

Ctrl + R

Work with Data Selections - Edit Active or Selected Cells
Fill cell values down and edit (Copy above cell values).

Ctrl + "

Work with Data Selections - Edit Active or Selected Cells
Fill cell formulas down and edit (Copy above cell formulas).

Ctrl + ' (apostrophe)

Work with Data Selections - Edit Active or Selected Cells
Insert a table (display Create Table dialog box).

Ctrl + L

Work with Data Selections - Edit Active or Selected Cells
Delete Cell/Row/Column Menu

Ctrl + -

Work with Data Selections - Edit Active or Selected Cells
Delete row / delete column.

Ctrl + - with row / column selected

Work with Data Selections - Edit Active or Selected Cells
Insert Cell/Row/Column Menu

Ctrl + Shift + [ + ]

Work with Data Selections - Edit Active or Selected Cells
Insert row/ insert column.

Ctrl + Shift + [ + with row / column selected

Work with Data Selections - Edit Active or Selected Cells
Insert / Edit a cell comment.

Shift + F2

Work with Data Selections - Edit Active or Selected Cells
Delete comment.

Shift + f10 , then m

Work with Data Selections - Edit Active or Selected Cells
Create and insert chart with data in current range as embedded Chart Object.

Alt + F1

Work with Data Selections - Edit Active or Selected Cells
Create and insert chart with data in current range in a separate Chart sheet.

F11

Work with Data Selections - Edit Active or Selected Cells
Insert a hyperlink.

Ctrl + K

Work with Data Selections - Edit Active or Selected Cells
Activate a hyperlink.

enter (in a cell with a hyperlink)

Work with Data Selections - Hide and Show Elements
Hide the selected rows.

Ctrl + 9

Work with Data Selections - Hide and Show Elements
Unhide any hidden rows within the selection.

Ctrl + Shift + 9

Work with Data Selections - Hide and Show Elements
Hide the selected columns.

Ctrl + 0 (zero)

Work with Data Selections - Hide and Show Elements
Unhide any hidden columns within the selection*.

Ctrl + Shift + 0 (zero)

Work with Data Selections - Hide and Show Elements
Alternate between displaying cell values and displaying cell formulas. Accent grave /not a quotation mark.

Ctrl + ` (grave accent)

Work with Data Selections - Hide and Show Elements
Group rows or columns.

Alt + Shift + Arrow Right

Work with Data Selections - Hide and Show Elements
Ungroup rows or columns.

Alt + Shift + Arrow Left

Work with Data Selections - Hide and Show Elements
Alternate between hiding and displaying objects.

Ctrl + 6

Work with Data Selections - Hide and Show Elements
Display or hides the outline symbols.

Ctrl + 8

Work with Data Selections - Hide and Show Elements
Alternate between hiding objects, displaying objects, and displaying placeholders for objects.

Ctrl + 6

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 a

Work with Data Selections - Adjust Column Width and Row Height
Adjust Columns width to specific value: Option, Cow, width

Alt + o , c w

Work with Data Selections - Adjust Column Width and Row Height
Adjust Row height to fit content: Option, Row, Adjust

Alt + o , r a

Work with Data Selections - Adjust Column Width and Row Height
Adjust Row height to specific value: Option, Row, Height

Alt + o , r e

Work with Data Selections - Format Cells
Format cells dialog.

Ctrl + 1

Work with Data Selections - Format Cells
Apply or remove bold formatting.

Ctrl + b (or ctrl + 2 )

Work with Data Selections - Format Cells
Apply or remove italic formatting.

Ctrl + i (or ctrl + 3 )

Work with Data Selections - Format Cells
Apply or remove an underline.

Ctrl + u (or ctrl + 4 )

Work with Data Selections - Format Cells
Apply or remove strikethrough formatting.

Ctrl + 5

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.

Ctrl + Shift + F

Work with Data Selections - Format Cells
Display the Style dialog box.

Alt + ' (apostrophe / single quote)

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.

Ctrl + Shift + ^

Work with Data Selections - Number Formats
Repeat last formatting action: Apply previously applied Cell Formatting to a different Cell

F4

Work with Data Selections - Apply Borders to Cells
Apply outline border from cell or selection

Ctrl + Shift + &

Work with Data Selections - Apply Borders to Cells
Remove outline borders from cell or selection

Ctrl + Shift + _ (underscore)

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

Ctrl + 1 , then Ctrl + Arrow Right / Arrow Left

Work with Data Selections - Apply Borders to Cells
Set top border

Alt + t *

Work with Data Selections - Apply Borders to Cells
Set bottom Border

Alt + b *

Work with Data Selections - Apply Borders to Cells
Set left Border

Alt + l *

Work with Data Selections - Apply Borders to Cells
Set right Border

Alt + r *

Work with Data Selections - Apply Borders to Cells
Set diagonal and down border

Alt + d *

Work with Data Selections - Apply Borders to Cells
Set diagonal and up border

Alt + u *

Work with Data Selections - Align Cells
Align Right

Alt + h , a r

Work with Data Selections - Align Cells
Align Center

Alt + h , a c

Work with Data Selections - Align Cells
Align Left

Alt + h , a l

Work with Data Selections - Formulas
Start a formula.

=

Work with Data Selections - Formulas
Insert the AutoSum formula.

Alt + =

Work with Data Selections - Formulas
Display the Insert Function dialog box.

Shift + F3

Work with Data Selections - Formulas
Display Formula Window after typing formula name.

Ctrl + A

Work with Data Selections - Formulas
Insert Arguments in formula after typing formula name. .

Ctrl + Shift + A

Work with Data Selections - Formulas
Insert a function into a formula .

Shift + F3

Work with Data Selections - Formulas
Enter a formula as an array formula.

Ctrl + Shift + Enter

Work with Data Selections - Formulas
After typing cell reference (e.g. =E3) makes reference absolute (=$E$4)

F4

Work with Data Selections - Formulas
Calculate all worksheets in all open workbooks.

F9

Work with Data Selections - Formulas
Calculate the active worksheet.

Shift + 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 + 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 + Alt + Shift + F9

Work with Data Selections - Formulas
Toggle expand or collapse formula bar.

Ctrl + Shift + U

Work with Data Selections - Formulas
Toggle Show formula in cell instead of values

Ctrl + `

Work with Data Selections - Names
Define a name or dialog.

Ctrl + F3

Work with Data Selections - Names
Create names from row and column labels.

Ctrl + Shift + F3

Work with Data Selections - Names
Paste a defined name into a formula.

F3

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.

Arrow Keys

Work with Data Selections - Dialog Boxes
Switch to the next/ previous tab in dialog box.

Ctrl + Tab / Ctrl + Shift + Tab

Work with Data Selections - Dialog Boxes
In a dialog box: perform the action for the selected button, or select/clear a check box.

Space

Work with Data Selections - Dialog Boxes
Move to the next / previous option.

Tab / Shift + Tab

Work with Data Selections - Dialog Boxes
Move to an option in a drop-down list box starting with the letter

a ... z

Work with Data Selections - Dialog Boxes
Select an option, or select or clear a check box.

Alt + a ... alt + Z

Work with Data Selections - Dialog Boxes
Open the selected drop-down list box.

Alt + Arrow Down

Work with Data Selections - Dialog Boxes
Perform the action assigned to the default command button in the dialog box.

Enter

Work with Data Selections - Dialog Boxes
Cancel the command and close the dialog box.

Esc

Work with Data Selections - Auto Filter
On the field with column head, display the AutoFilter list for the current column .

Alt + Arrow Down

Work with Data Selections - Auto Filter
Select the next item / previous item in the AutoFilter list.

Arrow Down / Arrow Up

Work with Data Selections - Auto Filter
Close the AutoFilter list for the current column.

Alt + Arrow Up

Work with Data Selections - Auto Filter
Select the first item / last item in the AutoFilter list.

Home / End

Work with Data Selections - Auto Filter
Filter the list by using the selected item in the AutoFilter list.

Enter

Work with Data Selections - Auto Filter
Apply filter on selected column headings.

Ctrl + Shift + L

Work with Data Selections - Work with Smart Art Graphics
Select elements.

Arrow Keys

Work with Data Selections - Work with Smart Art Graphics
Remove Focus from Selection.

Esc

Work with Data Selections - Work with Smart Art Graphics
Edit Selection Text in if possible (in formula bar).

F2

Insert and Edit Data - Select Cells
Select the entire row.

Shift + Space

Insert and Edit Data - Select Cells
Select the entire column.

Ctrl + Space

Insert and Edit Data - Select Cells
Select the current region around the active cell.

Ctrl + Shift + * (asterisk)

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 + a (or ctrl + Shift + spacebar )

Insert and Edit Data - Select Cells
Select the current and previous sheet in a workbook.

Ctrl + Shift + Page Up

Insert and Edit Data - Select Cells
Select all cells with comments.

Ctrl + Shift + O

Insert and Edit Data - Select Cells
Extend the selection by one cell.

Shift + Arrow Keys

Insert and Edit Data - Select Cells
Extend the selection to the last cell with content in row or column.

Ctrl + Shift + Arrow Key

Insert and Edit Data - Select Cells
Extend the selection down one screen /up one screen.

Shift + Page Down / Shift + Page Up

Insert and Edit Data - Select Cells
Extend the selection to the beginning of the row.

Shift + Home

Insert and Edit Data - Select Cells
Extend the selection to the beginning of the worksheet.

Ctrl + Shift + Home

Insert and Edit Data - Select Cells
Extend the selection to the last used cell on the worksheet (lower-right corner).

Ctrl + Shift + End

Insert and Edit Data - Manage Active Selections
Turn on extension of selection with arrow keys without having to keep pressing 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 + F8

Insert and Edit Data - Manage Active Selections
Select only the active cell when multiple cells are selected.

Shift + Backspace

Insert and Edit Data - Manage Active Selections
Show active cell within selection.

Ctrl + Backspace

Insert and Edit Data - Manage Active Selections
Move clockwise to the next corner of the selection.

Ctrl + . (period)

Insert and Edit Data - Manage Active Selections
Move active cell down / up in a selection.

Enter / Shift + Enter

Insert and Edit Data - Manage Active Selections
Move active cell right / left in a selection.

Tab / Shift + Tab

Insert and Edit Data - Manage Active Selections
Move to the right / to the left between non-adjacent selections (with multiple ranges selected).

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

Insert and Edit Data - Manage Active Selections
Cancel Selection.

Esc

Insert and Edit Data - Select inside cells
Select or unselect one character to the left / to the right.

Shift + Arrow Left / Shift + Arrow Right

Insert and Edit Data - Select inside cells
Select or unselect one word to the left / to the right.

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

Insert and Edit Data - Select inside cells
Select from the insertion point to the beginning / to the end of the cell.

Shift + Home / Shift + End

Insert and Edit Data - Undo / Redo Shortcuts
Undo last action (multiple levels).

Ctrl + Z

Insert and Edit Data - Undo / Redo Shortcuts
Redo last action (multiple levels).

Ctrl + Y

Insert and Edit Data - Work with Clipboard
Copy contents of selected cells.

Ctrl + C

Insert and Edit Data - Work with Clipboard
Cut contents of selected cells.

Ctrl + X

Insert and Edit Data - Work with Clipboard
Paste content from clipboard into selected cell.

Ctrl + V

Insert and Edit Data - Work with Clipboard
If data exists in clipboard: Display the Paste Special dialog box.

Ctrl + Alt + V

Insert and Edit Data - Work with Clipboard
If data exists in clipboard: Display the Insert dialog box to insert blank cells.

Ctrl + Shift + [ + ]

Insert and Edit Data - Edit Inside Cells
Edit the active cell with cursor at end of the line.

F2

Insert and Edit Data - Edit Inside Cells
Start a new line in the same cell.

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

Enter

Insert and Edit Data - Edit Inside Cells
Complete a cell entry and move up in the selection.

Shift + Enter

Insert and Edit Data - Edit Inside Cells
Complete a cell entry and move to the right / to the left in the selection.

Tab / Shift + Tab

Insert and Edit Data - Edit Inside Cells
Cancel a cell entry.

Esc

Insert and Edit Data - Edit Inside Cells
Delete the character to the left of the insertion point, or delete the selection.

Backspace

Insert and Edit Data - Edit Inside Cells
Delete the character to the right of the insertion point, or delete the selection.

Delete

Insert and Edit Data - Edit Inside Cells
Delete text to the end of the line.

Ctrl + Delete

Insert and Edit Data - Edit Inside Cells
Insert current date.

Ctrl + ; (semicolon)

Insert and Edit Data - Edit Inside Cells
Insert current time.

Ctrl + Shift + : (colon)

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 + T

Insert and Edit Data - Edit Active or Selected Cells
Fill complete cell down (Copy above cell).

Ctrl + D

Insert and Edit Data - Edit Active or Selected Cells
Fill complete cell to the right (Copy cell from the left).

Ctrl + R

Insert and Edit Data - Edit Active or Selected Cells
Fill cell values down and edit (Copy above cell values).

Ctrl + "

Insert and Edit Data - Edit Active or Selected Cells
Fill cell formulas down and edit (Copy above cell formulas).

Ctrl + ' (apostrophe)

Insert and Edit Data - Edit Active or Selected Cells
Insert a table (display Create Table dialog box).

Ctrl + L

Insert and Edit Data - Edit Active or Selected Cells
Delete Cell/Row/Column Menu

Ctrl + -

Insert and Edit Data - Edit Active or Selected Cells
Delete row / delete column.

Ctrl + - with row / column selected

Insert and Edit Data - Edit Active or Selected Cells
Insert Cell/Row/Column Menu

Ctrl + Shift + [ + ]

Insert and Edit Data - Edit Active or Selected Cells
Insert row/ insert column.

Ctrl + Shift + [ + with row / column selected

Insert and Edit Data - Edit Active or Selected Cells
Insert / Edit a cell comment.

Shift + F2

Insert and Edit Data - Edit Active or Selected Cells
Delete comment.

Shift + f10 , then m

Insert and Edit Data - Edit Active or Selected Cells
Create and insert chart with data in current range as embedded Chart Object.

Alt + F1

Insert and Edit Data - Edit Active or Selected Cells
Create and insert chart with data in current range in a separate Chart sheet.

F11

Insert and Edit Data - Edit Active or Selected Cells
Insert a hyperlink.

Ctrl + K

Insert and Edit Data - Edit Active or Selected Cells
Activate a hyperlink.

enter (in a cell with a hyperlink)

Insert and Edit Data - Hide and Show Elements
Hide the selected rows.

Ctrl + 9

Insert and Edit Data - Hide and Show Elements
Unhide any hidden rows within the selection.

Ctrl + Shift + 9

Insert and Edit Data - Hide and Show Elements
Hide the selected columns.

Ctrl + 0 (zero)

Insert and Edit Data - Hide and Show Elements
Unhide any hidden columns within the selection*.

Ctrl + Shift + 0 (zero)

Insert and Edit Data - Hide and Show Elements
Alternate between displaying cell values and displaying cell formulas. Accent grave /not a quotation mark.

Ctrl + ` (grave accent)

Insert and Edit Data - Hide and Show Elements
Group rows or columns.

Alt + Shift + Arrow Right

Insert and Edit Data - Hide and Show Elements
Ungroup rows or columns.

Alt + Shift + Arrow Left

Insert and Edit Data - Hide and Show Elements
Alternate between hiding and displaying objects.

Ctrl + 6

Insert and Edit Data - Hide and Show Elements
Display or hides the outline symbols.

Ctrl + 8

Insert and Edit Data - Hide and Show Elements
Alternate between hiding objects, displaying objects, and displaying placeholders for objects.

Ctrl + 6

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 a

Insert and Edit Data - Adjust Column Width and Row Height
Adjust Columns width to specific value: Option, Cow, width

Alt + o , c w

Insert and Edit Data - Adjust Column Width and Row Height
Adjust Row height to fit content: Option, Row, Adjust

Alt + o , r a

Insert and Edit Data - Adjust Column Width and Row Height
Adjust Row height to specific value: Option, Row, Height

Alt + o , r e

Insert and Edit Data - Format Cells
Format cells dialog.

Ctrl + 1

Insert and Edit Data - Format Cells
Apply or remove bold formatting.

Ctrl + b (or ctrl + 2 )

Insert and Edit Data - Format Cells
Apply or remove italic formatting.

Ctrl + i (or ctrl + 3 )

Insert and Edit Data - Format Cells
Apply or remove an underline.

Ctrl + u (or ctrl + 4 )

Insert and Edit Data - Format Cells
Apply or remove strikethrough formatting.

Ctrl + 5

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.

Ctrl + Shift + F

Insert and Edit Data - Format Cells
Display the Style dialog box.

Alt + ' (apostrophe / single quote)

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.

Ctrl + Shift + ^

Insert and Edit Data - Number Formats
Repeat last formatting action: Apply previously applied Cell Formatting to a different Cell

F4

Insert and Edit Data - Apply Borders to Cells
Apply outline border from cell or selection

Ctrl + Shift + &

Insert and Edit Data - Apply Borders to Cells
Remove outline borders from cell or selection

Ctrl + Shift + _ (underscore)

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

Ctrl + 1 , then Ctrl + Arrow Right / Arrow Left

Insert and Edit Data - Apply Borders to Cells
Set top border

Alt + t *

Insert and Edit Data - Apply Borders to Cells
Set bottom Border

Alt + b *

Insert and Edit Data - Apply Borders to Cells
Set left Border

Alt + l *

Insert and Edit Data - Apply Borders to Cells
Set right Border

Alt + r *

Insert and Edit Data - Apply Borders to Cells
Set diagonal and down border

Alt + d *

Insert and Edit Data - Apply Borders to Cells
Set diagonal and up border

Alt + u *

Insert and Edit Data - Align Cells
Align Right

Alt + h , a r

Insert and Edit Data - Align Cells
Align Center

Alt + h , a c

Insert and Edit Data - Align Cells
Align Left

Alt + h , a l

Insert and Edit Data - Formulas
Start a formula.

=

Insert and Edit Data - Formulas
Insert the AutoSum formula.

Alt + =

Insert and Edit Data - Formulas
Display the Insert Function dialog box.

Shift + F3

Insert and Edit Data - Formulas
Display Formula Window after typing formula name.

Ctrl + A

Insert and Edit Data - Formulas
Insert Arguments in formula after typing formula name. .

Ctrl + Shift + A

Insert and Edit Data - Formulas
Insert a function into a formula .

Shift + F3

Insert and Edit Data - Formulas
Enter a formula as an array formula.

Ctrl + Shift + Enter

Insert and Edit Data - Formulas
After typing cell reference (e.g. =E3) makes reference absolute (=$E$4)

F4

Insert and Edit Data - Formulas
Calculate all worksheets in all open workbooks.

F9

Insert and Edit Data - Formulas
Calculate the active worksheet.

Shift + 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 + 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 + Alt + Shift + F9

Insert and Edit Data - Formulas
Toggle expand or collapse formula bar.

Ctrl + Shift + U

Insert and Edit Data - Formulas
Toggle Show formula in cell instead of values

Ctrl + `

Insert and Edit Data - Names
Define a name or dialog.

Ctrl + F3

Insert and Edit Data - Names
Create names from row and column labels.

Ctrl + Shift + F3

Insert and Edit Data - Names
Paste a defined name into a formula.

F3

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.

Arrow Keys

Insert and Edit Data - Dialog Boxes
Switch to the next/ previous tab in dialog box.

Ctrl + Tab / Ctrl + Shift + Tab

Insert and Edit Data - Dialog Boxes
In a dialog box: perform the action for the selected button, or select/clear a check box.

Space

Insert and Edit Data - Dialog Boxes
Move to the next / previous option.

Tab / Shift + Tab

Insert and Edit Data - Dialog Boxes
Move to an option in a drop-down list box starting with the letter

a ... z

Insert and Edit Data - Dialog Boxes
Select an option, or select or clear a check box.

Alt + a ... alt + Z

Insert and Edit Data - Dialog Boxes
Open the selected drop-down list box.

Alt + Arrow Down

Insert and Edit Data - Dialog Boxes
Perform the action assigned to the default command button in the dialog box.

Enter

Insert and Edit Data - Dialog Boxes
Cancel the command and close the dialog box.

Esc

Insert and Edit Data - Auto Filter
On the field with column head, display the AutoFilter list for the current column .

Alt + Arrow Down

Insert and Edit Data - Auto Filter
Select the next item / previous item in the AutoFilter list.

Arrow Down / Arrow Up

Insert and Edit Data - Auto Filter
Close the AutoFilter list for the current column.

Alt + Arrow Up

Insert and Edit Data - Auto Filter
Select the first item / last item in the AutoFilter list.

Home / End

Insert and Edit Data - Auto Filter
Filter the list by using the selected item in the AutoFilter list.

Enter

Insert and Edit Data - Auto Filter
Apply filter on selected column headings.

Ctrl + Shift + L

Insert and Edit Data - Work with Smart Art Graphics
Select elements.

Arrow Keys

Insert and Edit Data - Work with Smart Art Graphics
Remove Focus from Selection.

Esc

Insert and Edit Data - Work with Smart Art Graphics
Edit Selection Text in if possible (in formula bar).

F2

Format Data - Select Cells
Select the entire row.

Shift + Space

Format Data - Select Cells
Select the entire column.

Ctrl + Space

Format Data - Select Cells
Select the current region around the active cell.

Ctrl + Shift + * (asterisk)

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

Ctrl + a (or ctrl + Shift + spacebar )

Format Data - Select Cells
Select the current and previous sheet in a workbook.

Ctrl + Shift + Page Up

Format Data - Select Cells
Select all cells with comments.

Ctrl + Shift + O

Format Data - Select Cells
Extend the selection by one cell.

Shift + Arrow Keys

Format Data - Select Cells
Extend the selection to the last cell with content in row or column.

Ctrl + Shift + Arrow Key

Format Data - Select Cells
Extend the selection down one screen /up one screen.

Shift + Page Down / Shift + Page Up

Format Data - Select Cells
Extend the selection to the beginning of the row.

Shift + Home

Format Data - Select Cells
Extend the selection to the beginning of the worksheet.

Ctrl + Shift + Home

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

Ctrl + Shift + End

Format Data - Manage Active Selections
Turn on extension of selection with arrow keys without having to keep pressing 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 + F8

Format Data - Manage Active Selections
Select only the active cell when multiple cells are selected.

Shift + Backspace

Format Data - Manage Active Selections
Show active cell within selection.

Ctrl + Backspace

Format Data - Manage Active Selections
Move clockwise to the next corner of the selection.

Ctrl + . (period)

Format Data - Manage Active Selections
Move active cell down / up in a selection.

Enter / Shift + Enter

Format Data - Manage Active Selections
Move active cell right / left in a selection.

Tab / Shift + Tab

Format Data - Manage Active Selections
Move to the right / to the left between non-adjacent selections (with multiple ranges selected).

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

Format Data - Manage Active Selections
Cancel Selection.

Esc

Format Data - Select inside cells
Select or unselect one character to the left / to the right.

Shift + Arrow Left / Shift + Arrow Right

Format Data - Select inside cells
Select or unselect one word to the left / to the right.

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

Format Data - Select inside cells
Select from the insertion point to the beginning / to the end of the cell.

Shift + Home / Shift + End

Format Data - Undo / Redo Shortcuts
Undo last action (multiple levels).

Ctrl + Z

Format Data - Undo / Redo Shortcuts
Redo last action (multiple levels).

Ctrl + Y

Format Data - Work with Clipboard
Copy contents of selected cells.

Ctrl + C

Format Data - Work with Clipboard
Cut contents of selected cells.

Ctrl + X

Format Data - Work with Clipboard
Paste content from clipboard into selected cell.

Ctrl + V

Format Data - Work with Clipboard
If data exists in clipboard: Display the Paste Special dialog box.

Ctrl + Alt + V

Format Data - Work with Clipboard
If data exists in clipboard: Display the Insert dialog box to insert blank cells.

Ctrl + Shift + [ + ]

Format Data - Edit Inside Cells
Edit the active cell with cursor at end of the line.

F2

Format Data - Edit Inside Cells
Start a new line in the same cell.

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

Enter

Format Data - Edit Inside Cells
Complete a cell entry and move up in the selection.

Shift + Enter

Format Data - Edit Inside Cells
Complete a cell entry and move to the right / to the left in the selection.

Tab / Shift + Tab

Format Data - Edit Inside Cells
Cancel a cell entry.

Esc

Format Data - Edit Inside Cells
Delete the character to the left of the insertion point, or delete the selection.

Backspace

Format Data - Edit Inside Cells
Delete the character to the right of the insertion point, or delete the selection.

Delete

Format Data - Edit Inside Cells
Delete text to the end of the line.

Ctrl + Delete

Format Data - Edit Inside Cells
Insert current date.

Ctrl + ; (semicolon)

Format Data - Edit Inside Cells
Insert current time.

Ctrl + Shift + : (colon)

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 + T

Format Data - Edit Active or Selected Cells
Fill complete cell down (Copy above cell).

Ctrl + D

Format Data - Edit Active or Selected Cells
Fill complete cell to the right (Copy cell from the left).

Ctrl + R

Format Data - Edit Active or Selected Cells
Fill cell values down and edit (Copy above cell values).

Ctrl + "

Format Data - Edit Active or Selected Cells
Fill cell formulas down and edit (Copy above cell formulas).

Ctrl + ' (apostrophe)

Format Data - Edit Active or Selected Cells
Insert a table (display Create Table dialog box).

Ctrl + L

Format Data - Edit Active or Selected Cells
Delete Cell/Row/Column Menu

Ctrl + -

Format Data - Edit Active or Selected Cells
Delete row / delete column.

Ctrl + - with row / column selected

Format Data - Edit Active or Selected Cells
Insert Cell/Row/Column Menu

Ctrl + Shift + [ + ]

Format Data - Edit Active or Selected Cells
Insert row/ insert column.

Ctrl + Shift + [ + with row / column selected

Format Data - Edit Active or Selected Cells
Insert / Edit a cell comment.

Shift + F2

Format Data - Edit Active or Selected Cells
Delete comment.

Shift + f10 , then m

Format Data - Edit Active or Selected Cells
Create and insert chart with data in current range as embedded Chart Object.

Alt + F1

Format Data - Edit Active or Selected Cells
Create and insert chart with data in current range in a separate Chart sheet.

F11

Format Data - Edit Active or Selected Cells
Insert a hyperlink.

Ctrl + K

Format Data - Edit Active or Selected Cells
Activate a hyperlink.

enter (in a cell with a hyperlink)

Format Data - Hide and Show Elements
Hide the selected rows.

Ctrl + 9

Format Data - Hide and Show Elements
Unhide any hidden rows within the selection.

Ctrl + Shift + 9

Format Data - Hide and Show Elements
Hide the selected columns.

Ctrl + 0 (zero)

Format Data - Hide and Show Elements
Unhide any hidden columns within the selection*.

Ctrl + Shift + 0 (zero)

Format Data - Hide and Show Elements
Alternate between displaying cell values and displaying cell formulas. Accent grave /not a quotation mark.

Ctrl + ` (grave accent)

Format Data - Hide and Show Elements
Group rows or columns.

Alt + Shift + Arrow Right

Format Data - Hide and Show Elements
Ungroup rows or columns.

Alt + Shift + Arrow Left

Format Data - Hide and Show Elements
Alternate between hiding and displaying objects.

Ctrl + 6

Format Data - Hide and Show Elements
Display or hides the outline symbols.

Ctrl + 8

Format Data - Hide and Show Elements
Alternate between hiding objects, displaying objects, and displaying placeholders for objects.

Ctrl + 6

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 a

Format Data - Adjust Column Width and Row Height
Adjust Columns width to specific value: Option, Cow, width

Alt + o , c w

Format Data - Adjust Column Width and Row Height
Adjust Row height to fit content: Option, Row, Adjust

Alt + o , r a

Format Data - Adjust Column Width and Row Height
Adjust Row height to specific value: Option, Row, Height

Alt + o , r e

Format Data - Format Cells
Format cells dialog.

Ctrl + 1

Format Data - Format Cells
Apply or remove bold formatting.

Ctrl + b (or ctrl + 2 )

Format Data - Format Cells
Apply or remove italic formatting.

Ctrl + i (or ctrl + 3 )

Format Data - Format Cells
Apply or remove an underline.

Ctrl + u (or ctrl + 4 )

Format Data - Format Cells
Apply or remove strikethrough formatting.

Ctrl + 5

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.

Ctrl + Shift + F

Format Data - Format Cells
Display the Style dialog box.

Alt + ' (apostrophe / single quote)

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.

Ctrl + Shift + ^

Format Data - Number Formats
Repeat last formatting action: Apply previously applied Cell Formatting to a different Cell

F4

Format Data - Apply Borders to Cells
Apply outline border from cell or selection

Ctrl + Shift + &

Format Data - Apply Borders to Cells
Remove outline borders from cell or selection

Ctrl + Shift + _ (underscore)

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

Ctrl + 1 , then Ctrl + Arrow Right / Arrow Left

Format Data - Apply Borders to Cells
Set top border

Alt + t *

Format Data - Apply Borders to Cells
Set bottom Border

Alt + b *

Format Data - Apply Borders to Cells
Set left Border

Alt + l *

Format Data - Apply Borders to Cells
Set right Border

Alt + r *

Format Data - Apply Borders to Cells
Set diagonal and down border

Alt + d *

Format Data - Apply Borders to Cells
Set diagonal and up border

Alt + u *

Format Data - Align Cells
Align Right

Alt + h , a r

Format Data - Align Cells
Align Center

Alt + h , a c

Format Data - Align Cells
Align Left

Alt + h , a l

Format Data - Formulas
Start a formula.

=

Format Data - Formulas
Insert the AutoSum formula.

Alt + =

Format Data - Formulas
Display the Insert Function dialog box.

Shift + F3

Format Data - Formulas
Display Formula Window after typing formula name.

Ctrl + A

Format Data - Formulas
Insert Arguments in formula after typing formula name. .

Ctrl + Shift + A

Format Data - Formulas
Insert a function into a formula .

Shift + F3

Format Data - Formulas
Enter a formula as an array formula.

Ctrl + Shift + Enter

Format Data - Formulas
After typing cell reference (e.g. =E3) makes reference absolute (=$E$4)

F4

Format Data - Formulas
Calculate all worksheets in all open workbooks.

F9

Format Data - Formulas
Calculate the active worksheet.

Shift + F9

Format Data - Formulas
Calculate all worksheets in all open workbooks, regardless of whether they have changed since the last calculation.

Ctrl + Alt + 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 + Alt + Shift + F9

Format Data - Formulas
Toggle expand or collapse formula bar.

Ctrl + Shift + U

Format Data - Formulas
Toggle Show formula in cell instead of values

Ctrl + `

Format Data - Names
Define a name or dialog.

Ctrl + F3

Format Data - Names
Create names from row and column labels.

Ctrl + Shift + F3

Format Data - Names
Paste a defined name into a formula.

F3

Format Data - Dialog Boxes
Move between options in the active drop-down list box or between some options in a group of options.

Arrow Keys

Format Data - Dialog Boxes
Switch to the next/ previous tab in dialog box.

Ctrl + Tab / Ctrl + Shift + Tab

Format Data - Dialog Boxes
In a dialog box: perform the action for the selected button, or select/clear a check box.

Space

Format Data - Dialog Boxes
Move to the next / previous option.

Tab / Shift + Tab

Format Data - Dialog Boxes
Move to an option in a drop-down list box starting with the letter

a ... z

Format Data - Dialog Boxes
Select an option, or select or clear a check box.

Alt + a ... alt + Z

Format Data - Dialog Boxes
Open the selected drop-down list box.

Alt + Arrow Down

Format Data - Dialog Boxes
Perform the action assigned to the default command button in the dialog box.

Enter

Format Data - Dialog Boxes
Cancel the command and close the dialog box.

Esc

Format Data - Auto Filter
On the field with column head, display the AutoFilter list for the current column .

Alt + Arrow Down

Format Data - Auto Filter
Select the next item / previous item in the AutoFilter list.

Arrow Down / Arrow Up

Format Data - Auto Filter
Close the AutoFilter list for the current column.

Alt + Arrow Up

Format Data - Auto Filter
Select the first item / last item in the AutoFilter list.

Home / End

Format Data - Auto Filter
Filter the list by using the selected item in the AutoFilter list.

Enter

Format Data - Auto Filter
Apply filter on selected column headings.

Ctrl + Shift + L

Format Data - Work with Smart Art Graphics
Select elements.

Arrow Keys

Format Data - Work with Smart Art Graphics
Remove Focus from Selection.

Esc

Format Data - Work with Smart Art Graphics
Edit Selection Text in if possible (in formula bar).

F2

Formulas and Names - Select Cells
Select the entire row.

Shift + Space

Formulas and Names - Select Cells
Select the entire column.

Ctrl + Space

Formulas and Names - Select Cells
Select the current region around the active cell.

Ctrl + Shift + * (asterisk)

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 + a (or ctrl + Shift + spacebar )

Formulas and Names - Select Cells
Select the current and previous sheet in a workbook.

Ctrl + Shift + Page Up

Formulas and Names - Select Cells
Select all cells with comments.

Ctrl + Shift + O

Formulas and Names - Select Cells
Extend the selection by one cell.

Shift + Arrow Keys

Formulas and Names - Select Cells
Extend the selection to the last cell with content in row or column.

Ctrl + Shift + Arrow Key

Formulas and Names - Select Cells
Extend the selection down one screen /up one screen.

Shift + Page Down / Shift + Page Up

Formulas and Names - Select Cells
Extend the selection to the beginning of the row.

Shift + Home

Formulas and Names - Select Cells
Extend the selection to the beginning of the worksheet.

Ctrl + Shift + Home

Formulas and Names - Select Cells
Extend the selection to the last used cell on the worksheet (lower-right corner).

Ctrl + Shift + End

Formulas and Names - Manage Active Selections
Turn on extension of selection with arrow keys without having to keep pressing 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 + F8

Formulas and Names - Manage Active Selections
Select only the active cell when multiple cells are selected.

Shift + Backspace

Formulas and Names - Manage Active Selections
Show active cell within selection.

Ctrl + Backspace

Formulas and Names - Manage Active Selections
Move clockwise to the next corner of the selection.

Ctrl + . (period)

Formulas and Names - Manage Active Selections
Move active cell down / up in a selection.

Enter / Shift + Enter

Formulas and Names - Manage Active Selections
Move active cell right / left in a selection.

Tab / Shift + Tab

Formulas and Names - Manage Active Selections
Move to the right / to the left between non-adjacent selections (with multiple ranges selected).

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

Formulas and Names - Manage Active Selections
Cancel Selection.

Esc

Formulas and Names - Select inside cells
Select or unselect one character to the left / to the right.

Shift + Arrow Left / Shift + Arrow Right

Formulas and Names - Select inside cells
Select or unselect one word to the left / to the right.

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

Formulas and Names - Select inside cells
Select from the insertion point to the beginning / to the end of the cell.

Shift + Home / Shift + End

Formulas and Names - Undo / Redo Shortcuts
Undo last action (multiple levels).

Ctrl + Z

Formulas and Names - Undo / Redo Shortcuts
Redo last action (multiple levels).

Ctrl + Y

Formulas and Names - Work with Clipboard
Copy contents of selected cells.

Ctrl + C

Formulas and Names - Work with Clipboard
Cut contents of selected cells.

Ctrl + X

Formulas and Names - Work with Clipboard
Paste content from clipboard into selected cell.

Ctrl + V

Formulas and Names - Work with Clipboard
If data exists in clipboard: Display the Paste Special dialog box.

Ctrl + Alt + V

Formulas and Names - Work with Clipboard
If data exists in clipboard: Display the Insert dialog box to insert blank cells.

Ctrl + Shift + [ + ]

Formulas and Names - Edit Inside Cells
Edit the active cell with cursor at end of the line.

F2

Formulas and Names - Edit Inside Cells
Start a new line in the same cell.

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

Enter

Formulas and Names - Edit Inside Cells
Complete a cell entry and move up in the selection.

Shift + Enter

Formulas and Names - Edit Inside Cells
Complete a cell entry and move to the right / to the left in the selection.

Tab / Shift + Tab

Formulas and Names - Edit Inside Cells
Cancel a cell entry.

Esc

Formulas and Names - Edit Inside Cells
Delete the character to the left of the insertion point, or delete the selection.

Backspace

Formulas and Names - Edit Inside Cells
Delete the character to the right of the insertion point, or delete the selection.

Delete

Formulas and Names - Edit Inside Cells
Delete text to the end of the line.

Ctrl + Delete

Formulas and Names - Edit Inside Cells
Insert current date.

Ctrl + ; (semicolon)

Formulas and Names - Edit Inside Cells
Insert current time.

Ctrl + Shift + : (colon)

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 + T

Formulas and Names - Edit Active or Selected Cells
Fill complete cell down (Copy above cell).

Ctrl + D

Formulas and Names - Edit Active or Selected Cells
Fill complete cell to the right (Copy cell from the left).

Ctrl + R

Formulas and Names - Edit Active or Selected Cells
Fill cell values down and edit (Copy above cell values).

Ctrl + "

Formulas and Names - Edit Active or Selected Cells
Fill cell formulas down and edit (Copy above cell formulas).

Ctrl + ' (apostrophe)

Formulas and Names - Edit Active or Selected Cells
Insert a table (display Create Table dialog box).

Ctrl + L

Formulas and Names - Edit Active or Selected Cells
Delete Cell/Row/Column Menu

Ctrl + -

Formulas and Names - Edit Active or Selected Cells
Delete row / delete column.

Ctrl + - with row / column selected

Formulas and Names - Edit Active or Selected Cells
Insert Cell/Row/Column Menu

Ctrl + Shift + [ + ]

Formulas and Names - Edit Active or Selected Cells
Insert row/ insert column.

Ctrl + Shift + [ + with row / column selected

Formulas and Names - Edit Active or Selected Cells
Insert / Edit a cell comment.

Shift + F2

Formulas and Names - Edit Active or Selected Cells
Delete comment.

Shift + f10 , then m

Formulas and Names - Edit Active or Selected Cells
Create and insert chart with data in current range as embedded Chart Object.

Alt + F1

Formulas and Names - Edit Active or Selected Cells
Create and insert chart with data in current range in a separate Chart sheet.

F11

Formulas and Names - Edit Active or Selected Cells
Insert a hyperlink.

Ctrl + K

Formulas and Names - Edit Active or Selected Cells
Activate a hyperlink.

enter (in a cell with a hyperlink)

Formulas and Names - Hide and Show Elements
Hide the selected rows.

Ctrl + 9

Formulas and Names - Hide and Show Elements
Unhide any hidden rows within the selection.

Ctrl + Shift + 9

Formulas and Names - Hide and Show Elements
Hide the selected columns.

Ctrl + 0 (zero)

Formulas and Names - Hide and Show Elements
Unhide any hidden columns within the selection*.

Ctrl + Shift + 0 (zero)

Formulas and Names - Hide and Show Elements
Alternate between displaying cell values and displaying cell formulas. Accent grave /not a quotation mark.

Ctrl + ` (grave accent)

Formulas and Names - Hide and Show Elements
Group rows or columns.

Alt + Shift + Arrow Right

Formulas and Names - Hide and Show Elements
Ungroup rows or columns.

Alt + Shift + Arrow Left

Formulas and Names - Hide and Show Elements
Alternate between hiding and displaying objects.

Ctrl + 6

Formulas and Names - Hide and Show Elements
Display or hides the outline symbols.

Ctrl + 8

Formulas and Names - Hide and Show Elements
Alternate between hiding objects, displaying objects, and displaying placeholders for objects.

Ctrl + 6

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 a

Formulas and Names - Adjust Column Width and Row Height
Adjust Columns width to specific value: Option, Cow, width

Alt + o , c w

Formulas and Names - Adjust Column Width and Row Height
Adjust Row height to fit content: Option, Row, Adjust

Alt + o , r a

Formulas and Names - Adjust Column Width and Row Height
Adjust Row height to specific value: Option, Row, Height

Alt + o , r e

Formulas and Names - Format Cells
Format cells dialog.

Ctrl + 1

Formulas and Names - Format Cells
Apply or remove bold formatting.

Ctrl + b (or ctrl + 2 )

Formulas and Names - Format Cells
Apply or remove italic formatting.

Ctrl + i (or ctrl + 3 )

Formulas and Names - Format Cells
Apply or remove an underline.

Ctrl + u (or ctrl + 4 )

Formulas and Names - Format Cells
Apply or remove strikethrough formatting.

Ctrl + 5

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.

Ctrl + Shift + F

Formulas and Names - Format Cells
Display the Style dialog box.

Alt + ' (apostrophe / single quote)

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.

Ctrl + Shift + ^

Formulas and Names - Number Formats
Repeat last formatting action: Apply previously applied Cell Formatting to a different Cell

F4

Formulas and Names - Apply Borders to Cells
Apply outline border from cell or selection

Ctrl + Shift + &

Formulas and Names - Apply Borders to Cells
Remove outline borders from cell or selection

Ctrl + Shift + _ (underscore)

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

Ctrl + 1 , then Ctrl + Arrow Right / Arrow Left

Formulas and Names - Apply Borders to Cells
Set top border

Alt + t *

Formulas and Names - Apply Borders to Cells
Set bottom Border

Alt + b *

Formulas and Names - Apply Borders to Cells
Set left Border

Alt + l *

Formulas and Names - Apply Borders to Cells
Set right Border

Alt + r *

Formulas and Names - Apply Borders to Cells
Set diagonal and down border

Alt + d *

Formulas and Names - Apply Borders to Cells
Set diagonal and up border

Alt + u *

Formulas and Names - Align Cells
Align Right

Alt + h , a r

Formulas and Names - Align Cells
Align Center

Alt + h , a c

Formulas and Names - Align Cells
Align Left

Alt + h , a l

Formulas and Names - Formulas
Start a formula.

=

Formulas and Names - Formulas
Insert the AutoSum formula.

Alt + =

Formulas and Names - Formulas
Display the Insert Function dialog box.

Shift + F3

Formulas and Names - Formulas
Display Formula Window after typing formula name.

Ctrl + A

Formulas and Names - Formulas
Insert Arguments in formula after typing formula name. .

Ctrl + Shift + A

Formulas and Names - Formulas
Insert a function into a formula .

Shift + F3

Formulas and Names - Formulas
Enter a formula as an array formula.

Ctrl + Shift + Enter

Formulas and Names - Formulas
After typing cell reference (e.g. =E3) makes reference absolute (=$E$4)

F4

Formulas and Names - Formulas
Calculate all worksheets in all open workbooks.

F9

Formulas and Names - Formulas
Calculate the active worksheet.

Shift + F9

Formulas and Names - Formulas
Calculate all worksheets in all open workbooks, regardless of whether they have changed since the last calculation.

Ctrl + Alt + 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 + Alt + Shift + F9

Formulas and Names - Formulas
Toggle expand or collapse formula bar.

Ctrl + Shift + U

Formulas and Names - Formulas
Toggle Show formula in cell instead of values

Ctrl + `

Formulas and Names - Names
Define a name or dialog.

Ctrl + F3

Formulas and Names - Names
Create names from row and column labels.

Ctrl + Shift + F3

Formulas and Names - Names
Paste a defined name into a formula.

F3

Formulas and Names - Dialog Boxes
Move between options in the active drop-down list box or between some options in a group of options.

Arrow Keys

Formulas and Names - Dialog Boxes
Switch to the next/ previous tab in dialog box.

Ctrl + Tab / Ctrl + Shift + Tab

Formulas and Names - Dialog Boxes
In a dialog box: perform the action for the selected button, or select/clear a check box.

Space

Formulas and Names - Dialog Boxes
Move to the next / previous option.

Tab / Shift + Tab

Formulas and Names - Dialog Boxes
Move to an option in a drop-down list box starting with the letter

a ... z

Formulas and Names - Dialog Boxes
Select an option, or select or clear a check box.

Alt + a ... alt + Z

Formulas and Names - Dialog Boxes
Open the selected drop-down list box.

Alt + Arrow Down

Formulas and Names - Dialog Boxes
Perform the action assigned to the default command button in the dialog box.

Enter

Formulas and Names - Dialog Boxes
Cancel the command and close the dialog box.

Esc

Formulas and Names - Auto Filter
On the field with column head, display the AutoFilter list for the current column .

Alt + Arrow Down

Formulas and Names - Auto Filter
Select the next item / previous item in the AutoFilter list.

Arrow Down / Arrow Up

Formulas and Names - Auto Filter
Close the AutoFilter list for the current column.

Alt + Arrow Up

Formulas and Names - Auto Filter
Select the first item / last item in the AutoFilter list.

Home / End

Formulas and Names - Auto Filter
Filter the list by using the selected item in the AutoFilter list.

Enter

Formulas and Names - Auto Filter
Apply filter on selected column headings.

Ctrl + Shift + L

Formulas and Names - Work with Smart Art Graphics
Select elements.

Arrow Keys

Formulas and Names - Work with Smart Art Graphics
Remove Focus from Selection.

Esc

Formulas and Names - Work with Smart Art Graphics
Edit Selection Text in if possible (in formula bar).

F2

The Rest - Select Cells
Select the entire row.

Shift + Space

The Rest - Select Cells
Select the entire column.

Ctrl + Space

The Rest - Select Cells
Select the current region around the active cell.

Ctrl + Shift + * (asterisk)

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

Ctrl + a (or ctrl + Shift + spacebar )

The Rest - Select Cells
Select the current and previous sheet in a workbook.

Ctrl + Shift + Page Up

The Rest - Select Cells
Select all cells with comments.

Ctrl + Shift + O

The Rest - Select Cells
Extend the selection by one cell.

Shift + Arrow Keys

The Rest - Select Cells
Extend the selection to the last cell with content in row or column.

Ctrl + Shift + Arrow Key

The Rest - Select Cells
Extend the selection down one screen /up one screen.

Shift + Page Down / Shift + Page Up

The Rest - Select Cells
Extend the selection to the beginning of the row.

Shift + Home

The Rest - Select Cells
Extend the selection to the beginning of the worksheet.

Ctrl + Shift + Home

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

Ctrl + Shift + End

The Rest - Manage Active Selections
Turn on extension of selection with arrow keys without having to keep pressing 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 + F8

The Rest - Manage Active Selections
Select only the active cell when multiple cells are selected.

Shift + Backspace

The Rest - Manage Active Selections
Show active cell within selection.

Ctrl + Backspace

The Rest - Manage Active Selections
Move clockwise to the next corner of the selection.

Ctrl + . (period)

The Rest - Manage Active Selections
Move active cell down / up in a selection.

Enter / Shift + Enter

The Rest - Manage Active Selections
Move active cell right / left in a selection.

Tab / Shift + Tab

The Rest - Manage Active Selections
Move to the right / to the left between non-adjacent selections (with multiple ranges selected).

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

The Rest - Manage Active Selections
Cancel Selection.

Esc

The Rest - Select inside cells
Select or unselect one character to the left / to the right.

Shift + Arrow Left / Shift + Arrow Right

The Rest - Select inside cells
Select or unselect one word to the left / to the right.

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

The Rest - Select inside cells
Select from the insertion point to the beginning / to the end of the cell.

Shift + Home / Shift + End

The Rest - Undo / Redo Shortcuts
Undo last action (multiple levels).

Ctrl + Z

The Rest - Undo / Redo Shortcuts
Redo last action (multiple levels).

Ctrl + Y

The Rest - Work with Clipboard
Copy contents of selected cells.

Ctrl + C

The Rest - Work with Clipboard
Cut contents of selected cells.

Ctrl + X

The Rest - Work with Clipboard
Paste content from clipboard into selected cell.

Ctrl + V

The Rest - Work with Clipboard
If data exists in clipboard: Display the Paste Special dialog box.

Ctrl + Alt + V

The Rest - Work with Clipboard
If data exists in clipboard: Display the Insert dialog box to insert blank cells.

Ctrl + Shift + [ + ]

The Rest - Edit Inside Cells
Edit the active cell with cursor at end of the line.

F2

The Rest - Edit Inside Cells
Start a new line in the same cell.

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

Enter

The Rest - Edit Inside Cells
Complete a cell entry and move up in the selection.

Shift + Enter

The Rest - Edit Inside Cells
Complete a cell entry and move to the right / to the left in the selection.

Tab / Shift + Tab

The Rest - Edit Inside Cells
Cancel a cell entry.

Esc

The Rest - Edit Inside Cells
Delete the character to the left of the insertion point, or delete the selection.

Backspace

The Rest - Edit Inside Cells
Delete the character to the right of the insertion point, or delete the selection.

Delete

The Rest - Edit Inside Cells
Delete text to the end of the line.

Ctrl + Delete

The Rest - Edit Inside Cells
Insert current date.

Ctrl + ; (semicolon)

The Rest - Edit Inside Cells
Insert current time.

Ctrl + Shift + : (colon)

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 + T

The Rest - Edit Active or Selected Cells
Fill complete cell down (Copy above cell).

Ctrl + D

The Rest - Edit Active or Selected Cells
Fill complete cell to the right (Copy cell from the left).

Ctrl + R

The Rest - Edit Active or Selected Cells
Fill cell values down and edit (Copy above cell values).

Ctrl + "

The Rest - Edit Active or Selected Cells
Fill cell formulas down and edit (Copy above cell formulas).

Ctrl + ' (apostrophe)

The Rest - Edit Active or Selected Cells
Insert a table (display Create Table dialog box).

Ctrl + L

The Rest - Edit Active or Selected Cells
Delete Cell/Row/Column Menu

Ctrl + -

The Rest - Edit Active or Selected Cells
Delete row / delete column.

Ctrl + - with row / column selected

The Rest - Edit Active or Selected Cells
Insert Cell/Row/Column Menu

Ctrl + Shift + [ + ]

The Rest - Edit Active or Selected Cells
Insert row/ insert column.

Ctrl + Shift + [ + with row / column selected

The Rest - Edit Active or Selected Cells
Insert / Edit a cell comment.

Shift + F2

The Rest - Edit Active or Selected Cells
Delete comment.

Shift + f10 , then m

The Rest - Edit Active or Selected Cells
Create and insert chart with data in current range as embedded Chart Object.

Alt + F1

The Rest - Edit Active or Selected Cells
Create and insert chart with data in current range in a separate Chart sheet.

F11

The Rest - Edit Active or Selected Cells
Insert a hyperlink.

Ctrl + K

The Rest - Edit Active or Selected Cells
Activate a hyperlink.

enter (in a cell with a hyperlink)

The Rest - Hide and Show Elements
Hide the selected rows.

Ctrl + 9

The Rest - Hide and Show Elements
Unhide any hidden rows within the selection.

Ctrl + Shift + 9

The Rest - Hide and Show Elements
Hide the selected columns.

Ctrl + 0 (zero)

The Rest - Hide and Show Elements
Unhide any hidden columns within the selection*.

Ctrl + Shift + 0 (zero)

The Rest - Hide and Show Elements
Alternate between displaying cell values and displaying cell formulas. Accent grave /not a quotation mark.

Ctrl + ` (grave accent)

The Rest - Hide and Show Elements
Group rows or columns.

Alt + Shift + Arrow Right

The Rest - Hide and Show Elements
Ungroup rows or columns.

Alt + Shift + Arrow Left

The Rest - Hide and Show Elements
Alternate between hiding and displaying objects.

Ctrl + 6

The Rest - Hide and Show Elements
Display or hides the outline symbols.

Ctrl + 8

The Rest - Hide and Show Elements
Alternate between hiding objects, displaying objects, and displaying placeholders for objects.

Ctrl + 6

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 a

The Rest - Adjust Column Width and Row Height
Adjust Columns width to specific value: Option, Cow, width

Alt + o , c w

The Rest - Adjust Column Width and Row Height
Adjust Row height to fit content: Option, Row, Adjust

Alt + o , r a

The Rest - Adjust Column Width and Row Height
Adjust Row height to specific value: Option, Row, Height

Alt + o , r e

The Rest - Format Cells
Format cells dialog.

Ctrl + 1

The Rest - Format Cells
Apply or remove bold formatting.

Ctrl + b (or ctrl + 2 )

The Rest - Format Cells
Apply or remove italic formatting.

Ctrl + i (or ctrl + 3 )

The Rest - Format Cells
Apply or remove an underline.

Ctrl + u (or ctrl + 4 )

The Rest - Format Cells
Apply or remove strikethrough formatting.

Ctrl + 5

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.

Ctrl + Shift + F

The Rest - Format Cells
Display the Style dialog box.

Alt + ' (apostrophe / single quote)

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.

Ctrl + Shift + ^

The Rest - Number Formats
Repeat last formatting action: Apply previously applied Cell Formatting to a different Cell

F4

The Rest - Apply Borders to Cells
Apply outline border from cell or selection

Ctrl + Shift + &

The Rest - Apply Borders to Cells
Remove outline borders from cell or selection

Ctrl + Shift + _ (underscore)

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

Ctrl + 1 , then Ctrl + Arrow Right / Arrow Left

The Rest - Apply Borders to Cells
Set top border

Alt + t *

The Rest - Apply Borders to Cells
Set bottom Border

Alt + b *

The Rest - Apply Borders to Cells
Set left Border

Alt + l *

The Rest - Apply Borders to Cells
Set right Border

Alt + r *

The Rest - Apply Borders to Cells
Set diagonal and down border

Alt + d *

The Rest - Apply Borders to Cells
Set diagonal and up border

Alt + u *

The Rest - Align Cells
Align Right

Alt + h , a r

The Rest - Align Cells
Align Center

Alt + h , a c

The Rest - Align Cells
Align Left

Alt + h , a l

The Rest - Formulas
Start a formula.

=

The Rest - Formulas
Insert the AutoSum formula.

Alt + =

The Rest - Formulas
Display the Insert Function dialog box.

Shift + F3

The Rest - Formulas
Display Formula Window after typing formula name.

Ctrl + A

The Rest - Formulas
Insert Arguments in formula after typing formula name. .

Ctrl + Shift + A

The Rest - Formulas
Insert a function into a formula .

Shift + F3

The Rest - Formulas
Enter a formula as an array formula.

Ctrl + Shift + Enter

The Rest - Formulas
After typing cell reference (e.g. =E3) makes reference absolute (=$E$4)

F4

The Rest - Formulas
Calculate all worksheets in all open workbooks.

F9

The Rest - Formulas
Calculate the active worksheet.

Shift + F9

The Rest - Formulas
Calculate all worksheets in all open workbooks, regardless of whether they have changed since the last calculation.

Ctrl + Alt + 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 + Alt + Shift + F9

The Rest - Formulas
Toggle expand or collapse formula bar.

Ctrl + Shift + U

The Rest - Formulas
Toggle Show formula in cell instead of values

Ctrl + `

The Rest - Names
Define a name or dialog.

Ctrl + F3

The Rest - Names
Create names from row and column labels.

Ctrl + Shift + F3

The Rest - Names
Paste a defined name into a formula.

F3

The Rest - Dialog Boxes
Move between options in the active drop-down list box or between some options in a group of options.

Arrow Keys

The Rest - Dialog Boxes
Switch to the next/ previous tab in dialog box.

Ctrl + Tab / Ctrl + Shift + Tab

The Rest - Dialog Boxes
In a dialog box: perform the action for the selected button, or select/clear a check box.

Space

The Rest - Dialog Boxes
Move to the next / previous option.

Tab / Shift + Tab

The Rest - Dialog Boxes
Move to an option in a drop-down list box starting with the letter

a ... z

The Rest - Dialog Boxes
Select an option, or select or clear a check box.

Alt + a ... alt + Z

The Rest - Dialog Boxes
Open the selected drop-down list box.

Alt + Arrow Down

The Rest - Dialog Boxes
Perform the action assigned to the default command button in the dialog box.

Enter

The Rest - Dialog Boxes
Cancel the command and close the dialog box.

Esc

The Rest - Auto Filter
On the field with column head, display the AutoFilter list for the current column .

Alt + Arrow Down

The Rest - Auto Filter
Select the next item / previous item in the AutoFilter list.

Arrow Down / Arrow Up

The Rest - Auto Filter
Close the AutoFilter list for the current column.

Alt + Arrow Up

The Rest - Auto Filter
Select the first item / last item in the AutoFilter list.

Home / End

The Rest - Auto Filter
Filter the list by using the selected item in the AutoFilter list.

Enter

The Rest - Auto Filter
Apply filter on selected column headings.

Ctrl + Shift + L

The Rest - Work with Smart Art Graphics
Select elements.

Arrow Keys

The Rest - Work with Smart Art Graphics
Remove Focus from Selection.

Esc

The Rest - Work with Smart Art Graphics
Edit Selection Text in if possible (in formula bar).

F2

Navigate Inside Worksheets
Move one cell up, down, left, or right in a worksheet.

Arrow Keys

Navigate Inside Worksheets
Move one screen down / one screen up in a worksheet.

Page Down / Page Up

Navigate Inside Worksheets
Move one screen to the right / to the left in a worksheet.

Alt + Page Down / Alt + Page Up

Navigate Inside Worksheets
Move one cell to the right / to the left in a worksheet.

Tab / Shift + Tab

Navigate Inside Worksheets
Move to the edge of next data region (cells that contains data)

Ctrl + Arrow Keys

Navigate Inside Worksheets
Move to the beginning of a row in a worksheet.

Home

Navigate Inside Worksheets
Move to the beginning of a worksheet.

Ctrl + Home

Navigate Inside Worksheets
Move to the last cell with content on a worksheet.

Ctrl + End

Navigate Inside Worksheets
Display the Find and Replace dialog box (with Find selected).

Ctrl + F

Navigate Inside Worksheets
Display the Find and Replace dialog box (with Replace selected).

Ctrl + H

Navigate Inside Worksheets
Repeat last find.

Shift + F4

Navigate Inside Worksheets
Display the 'Go To' dialog box.

Ctrl + g (or f5 )

Navigate Inside Worksheets
Inside a cell: Move one word to the left / to the right.

Ctrl + Arrow Left / Ctrl + Arrow Right

Navigate Inside Worksheets
Inside a cell: Move to the beginning / to the end of a cell entry.

Home / End

Navigate Inside Worksheets
Display the AutoComplete list e.g. in cell with dropdowns or autofilter.

Alt + Arrow Down

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.

End

Manage Multipe Worksheets
Insert a new worksheet in current workbook.

Shift + F11 / Alt + Shift + F1

Manage Multipe Worksheets
Move to the next / previous worksheet in current workbook.

Ctrl + Page Down / Ctrl + Page Up

Manage Multipe Worksheets
Select the current and next sheet(s) / select and previous sheet(s).

Shift + Ctrl + Page Down / Shift + Ctrl + Page Up

Manage Multipe Worksheets
Rename current worksheet (format, sheet, rename)

Alt + o then h r

Manage Multipe Worksheets
Delete current worksheet (Edit, delete)

Alt + e then l

Manage Multipe Worksheets
Move current worksheet (Edit, move)

Alt + e then m

Manage Multiple Workbooks
Move to the next pane / previous pane in a workbook that has been split.

F6 / Shift + F6

Manage Multiple Workbooks
Close the selected workbook window.

Ctrl + F4

Manage Multiple Workbooks
Create a new blank workbook (Excel File)

Ctrl + N

Manage Multiple Workbooks
Move to next / previous workbook window.

Ctrl + Tab / Ctrl + Shift + Tab

Manage Multiple Workbooks
Display the Control menu for Main Excel window.

Alt + Space

Manage Multiple Workbooks
Minimize current workbook window to an icon. Also restores ('un-maximizes') all workbook windows.

Ctrl + F9

Manage Multiple Workbooks
Maximize or restores the selected workbook window.

Ctrl + F10

Manage Multiple Workbooks
Move Workbook Windows which are not maximized.

Ctrl + F7

Manage Multiple Workbooks
Perform size command for workbook windows which are not maximzed.

Ctrl + F8

Manage Multiple Workbooks
Close Excel.

Alt + F4

Various Excel Features
Open File.

Ctrl + O

Various Excel Features
Save the active file with its current file name, location, and file format.

Ctrl + S

Various Excel Features
Display the Save As dialog box.

F12

Various Excel Features
Turn key tips on or off.

f10 (or alt )

Various Excel Features
Print File (Opens print menu).

Ctrl + P

Various Excel Features
Display the Excel Help task pane.

F1

Various Excel Features
Display the Spelling dialog box.

F7

Various Excel Features
Display the Thesaurus dialog box.

Shift + F7

Various Excel Features
Display the Macro dialog box.

Alt + F8

Various Excel Features
Open the Visual Basic Editor to create Macros.

Alt + F11

Work with the Excel Ribbon
Minimize or restore the Ribbon.s

Ctrl + F1

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

Alt / F10

Work with the Excel Ribbon
Display the shortcut menu for the selected command.

Shift + F10

Work with the Excel Ribbon
Activate the selected command or control in the Ribbon, Open the selected menu or gallery in the Ribbon..

Space / Enter

Work with the Excel Ribbon
Finish modifying a value in a control in the Ribbon, and move focus back to the document.

Enter

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

F1

Data Forms
Move to the next / previous field which can be edited.

Tab / Shift + Tab

Data Forms
Move to the first field in the next / previous record.

Enter / Shift + Enter

Data Forms
Move to the same field 10 records forward / back.

Page Down / Page Up

Data Forms
Move to a new record.

Ctrl + Page Down

Data Forms
Move to the first record.

Ctrl + Page Up

Data Forms
Move to the beginning / end of a field.

Home / End

Pivot Tables
Navigate inside Pivot tables.

Arrow Keys

Pivot Tables
Select the first / last visible item in the list.

Home / End

Pivot Tables
Move the selected field into the Column area.

Alt + C

Pivot Tables
Move the selected field into the Data area.

Alt + D

Pivot Tables
Display the PivotTable Field dialog box.

Alt + L

Pivot Tables
Move the selected field into the Page area.

Alt + P

Pivot Tables
Move the selected field into the Row area.

Alt + R

Pivot Tables
Select the entire PivotTable report.

Ctrl + Shift +* (asterisk)

Pivot Tables
Display the list for the current field in a 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 page field in a PivotChart report.

arrow keys to select the page field in a PivotChart report, and then alt + Arrow Down

Pivot Tables
Display the selected item.

Enter

Pivot Tables
Select or clear a check box in the list.

Space

Pivot Tables
select the PivotTable toolbar.

Ctrl + tab ctrl + Shift + Tab

Pivot Tables
On a field button: select the area you want to move the selected field to.

enter then arrow down / Arrow Up

Pivot Tables
Group selected PivotTable items.

Alt + Shift + Arrow Right

Pivot Tables
Ungroup selected PivotTable items.

Alt + Shift + Arrow Left

Similar combinations for other applications


Adobe Photoshop CS5 (Windows)
Apply value and keep text box active
Photoshop CS5 Panels - All Panels

Shift + Enter


Civilization V (Windows)
End Turn
General Hotkeys

Enter


Microsoft Projects 2010 (Windows)
With active selection: move up / move down
Navigate Gantt Chart and Select Tasks

Enter / Shift + Enter


Google Chrome (Windows)
Edit the element
Manage Chrome DevTools - Elements Panel

Enter


Firebug (Windows)
Finish editing
CSS-Panel

Enter


Firebug (Linux)
Finish editing
CSS-Panel

Enter


Microsoft Windows 7 (Windows)
Open folder or start application
Managing 'Windows' in Windows 7 - Navigate File List and Navigation Pane

Enter


Microsoft Outlook 2010 (Windows)
Open message
Messages in Main View - Message List and Single Messages

Enter


Microsoft Projects 2010 (Windows)
Accept an entry
Edit Fields

Enter


Google Earth 5 (MacOS)
Zooms into selected item
Places Panel

Enter


Firebug (MacOS)
Finish editing
CSS-Panel

Enter


Thunderbird (Windows)
Open message (in new window or tab)
Navigate Messages

Ctrl + O / Enter


Thunderbird (Linux)
Open message (in new window or tab)
Navigate Messages

Ctrl + O / Enter


Thunderbird (MacOS)
Open message (in new window or tab)
Navigate Messages

Command + O / Enter


Eclipse Helios (Windows)
Enter line below current line
Edit Text

Shift + Enter


Firefox (Linux)
Complete a .net address in address bar: adds "http" prefix and ".net" suffix to entry, then loads the page. Add alt to combination to load page in background tab.
Address Bar

Shift + Enter


Microsoft OneNote 2010 (Windows)
Open a hyperlink. The cursor must be placed anywhere within the formatted hyperlink text.
Specific OneNote Shortcuts for Selecting, Editing, and Formatting

enter


Firefox (Windows)
Complete a .net address in address bar: adds "http" prefix and ".net" suffix to entry, then loads the page. Add alt to combination to load page in background tab.
Address Bar

Shift + Enter


Microsoft OneNote 2010 (Windows)
Insert a line break without starting a new paragraph.
Specific OneNote Shortcuts for Selecting, Editing, and Formatting

shift + enter


Google Chrome (Windows)
Multi-line entry
Manage Chrome DevTools - Console Panel

Shift + Enter


Google Chrome (Windows)
Execute
Manage Chrome DevTools - Console Panel

Enter


Microsoft Projects 2010 (Windows)
Perform the action for the selected item
Navigate Projects Help

Enter


Google Mail (Windows)
Edit task details, including due date or notes.
Tasks in Gmail

Shift + Enter


Google Chrome (Linux)
Edit the element
Manage Chrome DevTools - Elements Panel

Enter


Firefox (Linux)
Open selected link in current tab
Inside Webpages

Enter


Firefox (Windows)
Open selected link in current tab
Inside Webpages

Enter


Firefox (Linux)
Open selected link in new window
Inside Webpages

Shift + Enter


Firefox (Windows)
Open selected link in new window
Inside Webpages

Shift + Enter


Microsoft OneNote 2010 (Windows)
Create another row when at the end cell of a table. Press ENTER a second time to finish the table.
Creating and Manipulating OneNote Tables

enter


Access 2010 (Windows)
Perform the action assigned to the default button in the dialog box
Manage Access Features - Dialog Boxes

Enter


Microsoft OneNote 2010 (Windows)
Create a row above the current one in a table (when the cursor is at the beginning of any row).
Creating and Manipulating OneNote Tables

enter


Access 2010 (Windows)
Add the selected field to the form or report detail section
Manage Access Features - Field List Pane

Enter


Microsoft Word 2007 (Windows)
A line break
Edit and move text and graphics: Insert special characters

Shift + Enter


Microsoft OneNote 2010 (Windows)
Insert a line break.
Adding Items to a Page

shift + enter


Microsoft Windows 7 (Windows)
Open folder or start application
Windows Explorer - Navigate File List and Navigation Pane

Enter


Google Chrome (Linux)
Multi-line entry
Manage Chrome DevTools - Console Panel

Shift + Enter


Google Chrome (Linux)
Execute
Manage Chrome DevTools - Console Panel

Enter


Tally 9.0 (Windows)
To view the next level of details and / or condense the next level of details
General Shortcuts

Shift + Enter


Google Chrome (Windows)
Find next / find previous match
Search

Enter / Shift + Enter with text found on webpage


Access 2010 (Windows)
Save changes to the current record
Manage Access Features - Insert Data

Shift + Enter


Microsoft Outlook 2010 (Windows)
Open message
Messages in Compose View - Message List and Single Messages

Enter


Microsoft OneNote 2010 (Windows)
While searching all notebooks, go to the selected result and dismiss Search.
Searching Notes

enter


Microstation v8i (Windows)
Smart LockIn Rectangular coordinates,
Microstation AccuDraw/ AccuSnap Shortcuts - Drawing Plane

Enter


Phoenix Viewer (Windows)
Chat
World

Enter


Mindjet Mindmanager 2012 (Windows)
Add topic (sibling, next, same level)
Most used - Same level

Enter


Mindjet Mindmanager 2012 (Windows)
Add topic as previous (sibling, same level)
Most used - Same level

Shift + Enter


Access 2010 (Windows)
Move from a table's title bar to the last cell you edited
Manage Access Features - Database Diagram

Enter


Tekla Structures 14.0 (Windows)
Repeat the last command
General shortcuts

Enter


Access 2010 (Windows)
Move down / move up
Manage Access Features - Pivot Table

Enter / Shift + Enter


Access 2010 (Windows)
Select cell above current cell
Manage Access Features - Pivot Table

Shift + Enter


Microsoft Windows 7 (Windows)
Open folder or start application
Windows Admin - Navigate File List and Navigation Pane

Enter


Microsoft Word 2007 (Windows)
New paragraphs in a cell
Edit and move text and graphics: Insert paragraphs and tab characters in a table

Enter


Mindjet Mindmanager 2012 (Windows)
Add topic (sibling, next, same level)
Reorganizing - Same level

Enter


Google Chrome (Linux)
Find next / find previous match
Search

Enter / Shift + Enter with text found on webpage


Mindjet Mindmanager 2012 (Windows)
Add topic as previous (sibling, same level)
Reorganizing - Same level

Shift + Enter


Adobe Photoshop CS5 (Windows)
Apply value and keep text box active
Extract and Pattern Maker (plug-in) - All Panels

Shift + Enter


Adobe Illustrator CS5 (MacOS)
Apply a value and keep focus in edit field
Panel Shortcuts - Transform Panel

Shift + Enter


Adobe Illustrator CS5 (Windows)
Apply a value and keep focus in edit field
Panel Shortcuts - Transform Panel

Shift + Enter


Total Commander 8 (Windows)
Change directory / run program / run associated program / execute command line if not empty. If the source directory shows the contents of an archive, further information on the packed file is given.
Main Shortcuts

Enter


Total Commander 8 (Windows)
1. Runs command line / program under cursor with preceding command /c and leave the program's window open. Only works if NOCLOSE.PIF is in your Windows directory! 2. With ZIP files: use alternative choice of these (as chosen in Packer config): (Treat archives like directories call associated program, i.e. winzip or quinzip) 3. In the list of last used dirs (History, Ctrl+D), open the directory on a new Tab.
Main Shortcuts

Shift + Enter


Access 2010 (Windows)
Restore the selected minimized window when all windows are minimized
Manage Access Features - Manage Windows

Enter


Access 2010 (Windows)
Perform action for currently selected item
Manage Access Features - Help Window

Enter


Open Office Impress (Linux)
Activate a placeholder object in a new presentation (only if the frame is selected).
Select and Move Elements

Enter


Microsoft Outlook 2010 (Windows)
Open message
Calendar Shortcuts - Message List and Single Messages

Enter


Microsoft Windows 8 (Windows)
Open folder or start application
Windows Explorer - Navigate File List and Navigation Pane

Enter


Opera (Linux)
Activate
Focus

Enter


Adobe Photoshop CS4 (MacOS)
Apply/cancel an operation of the Magnetic Lasso
Shortcut Keys for selecting and moving objects

Enter / Esc / Command + . (period)


Microsoft Windows 7 (Windows)
Open folder or start application
Ease of Access and Magnifier - Navigate File List and Navigation Pane

Enter


Access 2010 (Windows)
Perform the action assigned to the default button in the dialog box
Working with Text and Data - Dialog Boxes

Enter


Adobe Photoshop CS4 (MacOS)
Apply
Shortcut Keys for transforming selections, selection borders, and paths

Enter


Evernote (Windows)
Places focus in the note editor of the selected note.
Note List

Enter


Access 2010 (Windows)
Add the selected field to the form or report detail section
Working with Text and Data - Field List Pane

Enter


Opera (Linux)
Follow selected link
Link

Enter


Adobe Illustrator CS5 (Windows)
Apply a value and keep focus in edit field
Additional Shortcuts - Transform Panel

Shift + Enter


Opera (Linux)
Open selected link in new window
Link

Shift + Enter


Opera (Linux)
Open bookmark
Bookmarks

Enter


Opera (Linux)
Open bookmark in new tab
Bookmarks

Shift + Enter


Adobe Photoshop CS4 (MacOS)
Apply value and keep text box active
Shortcut Keys for using panels

Shift + Enter


Photoshop Lightroom 4 (Windows)
Switch to Loupe view
Comparing photos in the Library module

E / Enter


Access 2010 (Windows)
Save changes to the current record
Working with Text and Data - Insert Data

Shift + Enter


Jaws 11.0 (Windows)
Open Link in new window
Navigation in HTML (Internet browsing)

Shift + Enter


Microsoft Windows 7 (Windows)
Launch active icon
Navigating Desktop

Enter


Microsoft Windows 8 (Windows)
Launch active object
Navigating Desktop

Enter


Microsoft PowerPoint 2010 (Windows)
Select text within an object (with an object selected).
Work with Text and Objects

Enter


Photoshop Lightroom 4 (MacOS)
Switch to Loupe view
Comparing photos in the Library module

E / Enter


Microsoft Windows 7 (Windows)
Replaces clicking the mouse for many selected commands
Dialog Boxes

Enter


Access 2010 (Windows)
Move from a table's title bar to the last cell you edited
Working with Text and Data - Database Diagram

Enter


Access 2010 (Windows)
Move down / move up
Working with Text and Data - Pivot Table

Enter / Shift + Enter


Access 2010 (Windows)
Select cell above current cell
Working with Text and Data - Pivot Table

Shift + Enter


InDesign CS5 (MacOS)
Apply value and keep focus on option
Panels

Shift + Enter


Microsoft PowerPoint 2010 (Windows)
Start a new paragraph in table.
Basic Text Navigation and Formatting

Enter


Microsoft Outlook 2010 (Windows)
Move to next field, or add line to multiline field
Business Card View

Enter


Microsoft Outlook 2010 (Windows)
Move to previous field without leaving active card
Business Card View

Shift + Enter


Adobe Illustrator CS5 (MacOS)
Insert soft return
Working with Type

Shift + Enter


Adobe Illustrator CS5 (MacOS)
Apply value and keep text box active
Panel Shortcuts

Shift + Enter


iTunes (Windows)
Play the currently selected song immediately
Playback shortcuts

Enter


iTunes (MacOS)
Play the currently selected song from the beginning
Playback shortcuts

Enter


FreeMind 0.9.0 (Windows)
Add sibling node
New node commands

Enter


FreeMind 0.9.0 (Windows)
Add sibling before
New node commands

Shift + Enter


IntelliJ (Linux)
Start new line
Editing

Shift + Enter


Microsoft PowerPoint 2010 (Windows)
Open the selected menu, or perform the action assigned to the selected button.
PowerPoint Taks Panes

Space / Enter


Access 2010 (Windows)
Restore the selected minimized window when all windows are minimized
Working with Text and Data - Manage Windows

Enter


HoneyView 5.03 (Windows)
Select Image
Main Shortcuts

Enter


IntelliJ (Windows)
Start new line
Editing

Shift + Enter


HoneyView 5.03 (Windows)
select image
Main Shortcuts

Enter


Microsoft PowerPoint 2010 (Windows)
Start a new paragraph.
Move around in Tables

Enter


Access 2010 (Windows)
Perform action for currently selected item
Working with Text and Data - Help Window

Enter


Microsoft PowerPoint 2010 (Windows)
Perform the action for the selected item on a smart tag menu.
Manage Smart Tags

Enter


iTunes (Windows)
Click the currently selected control
With full keyboard navigation enabled

Enter


Photoshop Lightroom 4 (Windows)
Play slide show
Slideshow module

Enter


Microsoft PowerPoint 2010 (Windows)
Perform the action assigned to a default button in a dialog box.
Work with Dialog Boxes

Enter


Access 2010 (Windows)
Perform the action assigned to the default button in the dialog box
Working with Access Views - Dialog Boxes

Enter


Microsoft PowerPoint 2010 (Windows)
Select a focused item.
Work with the Selection pane.

Space / Enter


Access 2010 (Windows)
Add the selected field to the form or report detail section
Working with Access Views - Field List Pane

Enter


Microsoft PowerPoint 2010 (Windows)
Cancel selection of a focused item.
Work with the Selection pane.

Shift + Space / Shift + Enter


Photoshop Lightroom 4 (MacOS)
Play slide show
Slideshow module

Enter


Microsoft Excel 2013 (Windows)
Move active cell down / up in a selection
Navigate Inside Selected Text Blocks

Enter / Shift + Enter


FL Studio (Windows)
Toggle max/min Playlist
Window Navigation

Enter


Access 2010 (Windows)
Save changes to the current record
Working with Access Views - Insert Data

Shift + Enter


Adobe Illustrator CS5 (Windows)
Insert soft return
Working with Type

Shift + Enter


Presonus Studio One (Windows)
Start
Transport Menu

Enter


Microsoft Excel 2013 (Windows)
Complete a cell entry and move down in the selection With multiple cells selected: fill cell range with current cell
Edit Content of Cells

Enter


Directory Opus (Windows)
Path entry
Misc.

Shift + Enter


Adobe Illustrator CS5 (Windows)
Apply value and keep text box active
Panel Shortcuts

Shift + Enter


Microsoft Excel 2013 (Windows)
Complete a cell entry and move up in the selection
Edit Content of Cells

Shift + Enter


Adobe Acrobat Pro (Windows)
Previous Screen
Navigation - Navigating a PDF

Page Up / Shift + Enter


FileMaker Pro (MacOS)
Toggle the current tool with the Selection tool.
Layout Mode Shortcuts - Layout Tools

Enter / Shift + Enter on numeric keypad.


Adobe Acrobat Pro (Windows)
Next screen
Navigation - Navigating a PDF

Page Down / Shift + Enter


Access 2010 (Windows)
Move from a table's title bar to the last cell you edited
Working with Access Views - Database Diagram

Enter


Adobe Flash Professional (Windows)
Play
Timeline

Enter


Adobe Photoshop CS5 (MacOS)
Apply/cancel an operation of the Magnetic Lasso
Select and Move Objects

Enter / Esc / Command + . (period)


Microsoft Word 2013 (Windows)
Insert paragraph break
Insert Special Characters, Text Elements, and Breaks

Enter


Adobe Acrobat Pro (Windows)
Expand or collapse panel in focus (press F6 to move focus to Tools pane, then tab to desired panel)
Navigation - Navigating task panes

Space / Enter


Microsoft Word 2013 (Windows)
Insert line break without breaking paragraph
Insert Special Characters, Text Elements, and Breaks

Shift + Enter


Adobe Acrobat Pro (Windows)
Open the menu and move the focus to the first menu option when focus is on a command with a submenu or submenu element with a flyout
Navigation - Navigating task panes

Space / Enter


Access 2010 (Windows)
Move down / move up
Working with Access Views - Pivot Table

Enter / Shift + Enter


Access 2010 (Windows)
Select cell above current cell
Working with Access Views - Pivot Table

Shift + Enter


Adobe Acrobat Pro (Windows)
Run the command in focus
Navigation - Navigating task panes

Space / Enter


Twitter (Web Application)
Open Tweet details
Actions

Enter


Adobe Photoshop CS5 (MacOS)
Apply
Transform Selections, Selection Borders, and Paths

Enter


Adobe Acrobat Pro (Windows)
Activate highlighted link
Navigation - Navigating the Help window

Enter


Adobe Photoshop CS5 (Windows)
Apply/cancel an operation of the Magnetic Lasso
Select and Move Objects

Enter / Esc / Ctrl + . (period)


Autodesk Maya 2015 (Windows)
Complete current tool
General Tools

Enter


Feedly (Web Application)
Open selected article
Selected Article Actions

enter


Adobe Photoshop CS5 (Windows)
Apply
Transform Selections, Selection Borders, and Paths

Enter


Adobe Acrobat Pro (Windows)
Open pop-up note (or text field in Comments List) for comment that has focus
Comments

Enter


Adobe Acrobat Pro (Windows)
Select a highlighted control in the top bar
Navigation

Enter / Space


Adobe Acrobat Pro (Windows)
Activate selected tool, item (such as a movie clip or bookmark), or command
Navigation

Space / Enter


Access 2010 (Windows)
Restore the selected minimized window when all windows are minimized
Working with Access Views - Manage Windows

Enter


Microsoft Excel 2013 (Windows)
Activate the selected command or control in the Ribbon, Open the selected menu or gallery in the Ribbon
Ribbon Shortcuts

Space / Enter


Microsoft Excel 2013 (Windows)
Finish modifying a value in a control in the Ribbon, and move focus back to the document
Ribbon Shortcuts

Enter


Adobe Acrobat Pro (Windows)
Press the Go Back button in a folder if focus is on the button.
PDF Portfolios

Enter / Space


Adobe Acrobat Pro (Windows)
If pressed when focus is on a row in the file list representing a subfolder, navigate to a subfolder, or open an attachment in Preview mode.
PDF Portfolios

Enter


Access 2010 (Windows)
Perform action for currently selected item
Working with Access Views - Help Window

Enter


FileMaker Pro (Windows)
Issue a command in a selected button’s menu
Layout Mode Shortcuts - Relationships Graph

Enter / Space to display the menu, Up Arrow or Down Arrow to make a selection in the menu, then Enter to issue the command


FL Studio (Windows)
Flip separator (since program version 11.5.8)
Piano Roll Action

Shift + Enter


Atom (text editor) 1.0 (Linux)
Open selected item
Tree View

Enter


Microsoft Excel 2013 (Windows)
Display the selected item
Pivot Tables

Enter


Atom (text editor) 1.0 (Windows)
Open selected item
Tree View

Enter


Notepad++ 6 (Windows)
Split line downwards, or create new line
Edit menu

Enter


Notepad++ 6 (Windows)
Split line downwards, or create new line
Edit menu

Shift + Enter


Microsoft Excel 2013 (Windows)
Perform the action assigned to the default command button in the dialog box
Dialog Boxes

Enter


Microsoft Excel 2013 (Windows)
Filter the list by using the selected item in the AutoFilter list
Auto Filter

Enter


Microsoft Excel 2013 (Windows)
Move to the first field in the next / previous record
Data Forms

Enter / Shift + Enter


FileMaker Pro (MacOS)
Toggle the current tool with the Selection tool.
Text Shortcuts - Layout Tools

Enter / Shift + Enter on numeric keypad.


Access 2010 (Windows)
Perform the action assigned to the default button in the dialog box
The Rest - Dialog Boxes

Enter


Adobe After Effects CC (Windows)
Rename selected Layer, Composition, Folder, etc
Basics

Enter


Adobe After Effects CC (MacOS)
Rename selected Layer, Composition, Folder, etc
Basics

Enter


Access 2010 (Windows)
Add the selected field to the form or report detail section
The Rest - Field List Pane

Enter


GTDNext.com (Windows)
Start a new action at the current level of indent
Center Pane Shortcuts

Enter


Camtasia 2 (MacOS)
Replay current caption segment
Timeline & Editing

Enter


Skype for Business (Lync) 2016 (Windows)
Add line break
Instant Messaging

Shift + Enter


Camtasia 2 (MacOS)
Rewind to start
Timeline & Editing

Enter


Microsoft OneNote 2016 (Windows)
Insert a line break without starting a new paragraph
Format

Shift + Enter


GTDNext.com (Windows)
Toggles to enter Notes for the item
Center Pane Shortcuts

Shift + Enter


Access 2010 (Windows)
Save changes to the current record
The Rest - Insert Data

Shift + Enter


Google Mail (MacOS)
Edit task details, including due date or notes.
Tasks in Gmail

Shift + Enter


Nirvana (Web Application)
Save
Capturing

Enter


Nirvana (Web Application)
Save to top of current list
Rapid Entry

Shift + Enter


Onshape (Windows)
Accept command
General

Enter


Nirvana (Web Application)
Save to bottom of current list
Rapid Entry

Enter


Onshape (Windows)
Accept and repeat command
General

Shift + Enter


GTDNext.com (Windows)
Select the current list
Left Navigation Area Shortcuts

Enter


Onshape (MacOS)
Accept command
General

Enter


Onshape (MacOS)
Accept and repeat command
General

Shift + Enter


Nirvana (Web Application)
Save at bottom of list
Rapid Entry

Enter


Nirvana (Web Application)
Save at top of list
Rapid Entry

Shift + Enter


Microsoft OneNote 2016 (Windows)
Create another row when at the end cell of a table. Press Enter a second time to finish the table
OneNote Tables

Enter


Sonos Controller (Windows)
Play selected song next
22 Shortcuts for Sonos Controller (Windows)

Shift + Enter


Microsoft OneNote 2016 (Windows)
Create row above the current one in table (when the cursor is at the beginning of any row)
OneNote Tables

Enter


Access 2010 (Windows)
Move from a table's title bar to the last cell you edited
The Rest - Database Diagram

Enter


Adobe Photoshop CC (Windows)
Apply value and keep text box active
Basic Shortcuts for Photoshop CC 2015 - Shortcuts for all Panels

Shift + Enter


Autodesk Maya 2017 (Windows)
Complete current tool
General Tools

Enter


FileMaker Pro (Windows)
Issue a command in a selected button’s menu
Text Shortcuts - Relationships Graph

Enter / Space to display the menu, Up Arrow or Down Arrow to make a selection in the menu, then Enter to issue the command


Photoshop Lightroom CC (MacOS)
Switch to Loupe view
Comparing Photos in the Library Module

E / Enter


Photoshop Lightroom CC (Windows)
Switch to Loupe view
Comparing Photos in the Library Module

E / Enter


Adobe Photoshop CC (MacOS)
Apply value and keep text box active
Basic Shortcuts for PhotoShop CC 2015 - Shortcuts for all Panels

Shift + Enter


Access 2016 (Windows)
Restore the window
Windows/Content Switching/Navigation

Enter


Access 2010 (Windows)
Move down / move up
The Rest - Pivot Table

Enter / Shift + Enter


Access 2010 (Windows)
Select cell above current cell
The Rest - Pivot Table

Shift + Enter


Google Slides (Windows)
Play the selected video
Working Point Navigation Action

Enter


Microsoft OneNote 2016 (Windows)
While searching all notebooks, go to selected result and dismiss search
Search Notes

Enter


Microsoft PowerPoint 2016 (Windows)
Activate selected commend/Open Selected menu on ribbon
Navigation Operation

Spacebar / Enter


Microsoft Excel 2016 (Windows)
Move to the first field in the next/ previous record
Select Cells - Data Forms

Enter / Shift + Enter


FileMaker Pro (MacOS)
Toggle the current tool with the Selection tool.
Database Management Shortcuts - Layout Tools

Enter / Shift + Enter on numeric keypad.


Plex (Windows)
Select current item
Graphics(Audio/Video) Control

Enter


Plex (MacOS)
Select current item
Graphics(Audio/Video) Control

Enter


Plex (Windows)
Select current item
Navigation Controls

Enter


Access 2010 (Windows)
Restore the selected minimized window when all windows are minimized
The Rest - Manage Windows

Enter


Plex (MacOS)
Select current item
Navigation Controls

Enter


Microsoft PowerPoint 2016 (Windows)
Finish modifying value
Edit and General Text Operations

Enter


Access 2010 (Windows)
Perform action for currently selected item
The Rest - Help Window

Enter


Apple Keynote (MacOS)
Complete a cell entry and select the cell
Chart data editor

Enter


Microsoft PowerPoint 2016 (Windows)
Go to Slide
Slide Operations(Presentation time)

+ Enter


FileMaker Pro (Windows)
Issue a command in a selected button’s menu
Database Management Shortcuts - Relationships Graph

Enter / Space to display the menu, Up Arrow or Down Arrow to make a selection in the menu, then Enter to issue the command


Apple Keynote (MacOS)
Open formula editor for cell containing formula
Formula Shortcuts(Tables)

= / Return / Enter


Apple Keynote (MacOS)
Save changes
Formula Shortcuts(Tables)

Return / Enter / Click Accept


Microsoft Excel 2016 (Windows)
Move to the first field in the next/ previous record
Format Cells - Data Forms

Enter / Shift + Enter


Photoshop Lightroom CC (Windows)
Play slide show
Slideshow Module

Enter


Photoshop Lightroom CC (MacOS)
Play slide show
Slideshow Module

Enter


Adobe Illustrator CC (Windows)
Apply value and keep textbox active
Panel Shortcuts

Shift + Enter


Microsoft Outlook 2016 (Windows)
Open an item
Views: Table View

Enter


Microsoft Outlook 2016 (Windows)
Close the active card (in an open card)
View: Business Cards/Address cards

Enter


Microsoft Outlook 2016 (Windows)
Add a line in a multiline field (when a field in a card is selected)
View: Business Cards/Address cards

Enter


Microsoft Outlook 2016 (Windows)
Open the selected items
View: Timeline (Tasks) - When an item is selected

Enter


Adobe Photoshop CC (Windows)
Apply value and keep text box active
Manage Panels - Shortcuts for all Panels

Shift + Enter


Nuke 10 (Windows)
Choose selected menu item
Panel Properties

Enter


InDesign CC (Windows)
Forced link break
Type Menu Shortcuts

Shift + Enter


Nuke 10 (Linux)
Choose selected menu item
Panel Properties

Enter


Adobe Photoshop CC (MacOS)
Apply value and keep text box active
Manage Panels - Shortcuts for all Panels

Shift + Enter


Hexagon 2 (Windows)
Validate
View Shortcuts(Numeric Pad)

Enter


Hexagon 2 (Windows)
Validate
General Shortcuts

Enter


FileMaker Pro (Windows)
Perform a find. Disabled when a script is paused.
Find Mode Shortcuts

Enter


Microsoft Excel 2016 (Windows)
Move to the first field in the next/ previous record
Formulas - Data Forms

Enter / Shift + Enter


3D Coat (Windows)
Draw extruded curve
Splines

Enter


Dynamics CRM 2015 (Windows)
Complete the command for the active option or button
Form Keyboard Shortcuts

Enter


Dynamics CRM 2015 (Windows)
Open search
Form Keyboard Shortcuts

Spacebar / Enter


Dynamics GP 2015 (Windows)
Default button on a window
Window Navigation Shortcuts

Enter


Dynamics CRM 2015 (Windows)
Open lookup drop-down list
Form Keyboard Shortcuts

Enter


Dynamics CRM 2015 (Windows)
Open a record found in lookup with forms in Edit mode
Form Keyboard Shortcuts

Enter


Dynamics GP 2015 (Windows)
Default button on a window
Tools Shortcuts

Enter


Dynamics SL 2015 (Windows)
Complete the command for the active option or button
Navigation in forms

Enter


Dynamics AX 2015 (Windows)
Select the default button on a dialog form.
Working with Forms

Enter


Dynamics SL 2015 (Windows)
Open a lookup drop-down list
Navigation in forms

Enter


Dynamics SL 2015 (Windows)
Open a record found in lookup with forms in Edit mode
Navigation in forms

Enter


Dynamics SL 2015 (Windows)
Move to the cell below/When cell is not in edit mode
Grid/View Shortcuts

Down Arrow / Enter


Dynamics SL 2015 (Windows)
Select an option in an open drop-down list
Grid/View Shortcuts

Enter


Microsoft Projects 2016 (Windows)
Open the selected folder or file.
Working with dialog boxes

Enter


Dynamics CRM 2015 (Windows)
Open the selected record
General Purpose Shortcuts

Enter


Dynamics CRM 2015 (Windows)
Complete the command for the active option or button
Dialog Box Shortcuts

Enter


Microsoft Projects 2016 (Windows)
Perform the action assigned to a default button in a dialog box.
Working with dialog boxes

Enter


Microsoft Excel 2016 (Windows)
Move to the first field in the next/ previous record
Manage Workbooks - Data Forms

Enter / Shift + Enter


Microsoft Projects 2016 (Windows)
Move to the next task or resource.
Working with dialog boxes

Enter


Microsoft Projects 2016 (Windows)
Move to the previous task or resource.
Working with dialog boxes

Shift + Enter


Dynamics AX 2015 (Windows)
Perform the action for the selected Expand All, Collapse All, hidden text,/ hyperlink.
General Shortcuts

Enter


Microsoft Projects 2016 (Windows)
Start a new paragraph.
Working with Table

Enter


CyberLink PhotoDirector 8 (Windows)
Set as current when comparing 2 photos
Workspace

Enter


Microsoft Projects 2016 (Windows)
Perform the action for the selected item on the action menu.
Access and Use Action

Enter


Adobe Photoshop CC (Windows)
Apply an operation of the Magnetic Lasso; press Escape to cancel
Select and Move Objects

Enter


Microsoft Projects 2016 (Windows)
Select the previous field in the Network Diagram box.
Network Diagram

Shift + Enter


Adobe Photoshop CC (MacOS)
Apply an operation of the Magnetic Lasso; press Escape to cancel
Select and Move Objects

Enter


Adobe Photoshop CC (Windows)
Apply
Transform Selections, Borders, and Paths

Enter


AutoCad Architecture 2017 (Windows)
Ends the current paragraph, starting a new one on thenext line
Text Editing

Enter


Microsoft Projects 2016 (Windows)
Select text within an object (with an object selected).
Working with OfficeArt Objects

Enter


Adobe Photoshop CC (MacOS)
Apply
Transform Selections, Borders, and Paths

Enter


Adobe Flash Professional (MacOS)
Play
Timeline

Enter


Apple Pages (MacOS)
Complete a cell entry and select the cell
Editing chart data

Enter


Microsoft Excel 2016 (Windows)
Move to the first field in the next/ previous record
Excel Auto Tables and Data Forms - Data Forms

Enter / Shift + Enter


GitLab (Web Application)
Open Selection
Project File Searching Shortcuts

Enter


1Password (Windows)
Shift focus from folders or categories area to list area.
Main Program Shortcuts

Enter


GitLab (Web Application)
Open Selection
Project File Browsing Shortcuts

Enter


Todoist (Web Application)
Save a newly created task and create a new one below it
Task Editing Shortcuts

Enter


Todoist (Web Application)
Save existing task and create new one below it
Task Editing Shortcuts

Shift + Enter


Eclipse Helios (MacOS)
Insert Line Below current line
Text Editing Shortcuts

Shift + Enter


Asana (Web Application)
New Task
Task Action Shortcuts(On Windows Plateform)

Enter


ZenDesk (Windows)
Drill into an item
Navigation Shortcuts

Enter


Microsoft Excel 2016 (Windows)
Complete cell entry and move one cell down/ up
Edit Cell Content

Enter / Shift + Enter


IntelliJ (MacOS)
Start New line
Editing Shortcuts

Shift + Enter


Trello (Web Application)
Open Cards
General Shortcuts

Enter


Microsoft Projects 2016 (Windows)
Move within a selection down one field.
Move in Side Pane

Enter


Microsoft Projects 2016 (Windows)
Move within a selection up one field.
Move in Side Pane

Shift + Enter


SalesForce (Web Application)
Activate a Command
Console Controls

Enter


Microsoft Projects 2016 (Windows)
Accept an entry.
Select and Edit in Entry bar

Enter


TextMate 2 (MacOS)
Continue Line Comment
Source Shortcut

Enter


Atlasian JIRA Agile (Web Application)
Add a new line
Agile Shortcuts

Enter


Atlasian JIRA Agile (Web Application)
Submit Changes
Agile Shortcuts

Enter


JetBrains RubyMine (Windows)
Start New line
Editing Shortcuts

Shift + Enter


JetBrains RubyMine (MacOS)
Start New line
Editing Shortcuts

Shift + Enter


Slack (MacOS)
Create a new line in your message
Message Shortcuts

Shift + Enter


JetBrains RubyMine (Linux)
Start New line
Editing Shortcuts

Shift + Enter


Slack (Windows)
Create a new line in your message
Message Shortcuts

Shift + Enter


Google News (Web Application)
Open headline of current story
Actions

Enter


Microsoft Excel 2016 (Windows)
Move active cell down/ up in selection
Navigate Multi-Cell Selections

Enter / Shift + Enter


JetBrains PyCharm (MacOS)
Start New line
Editing Shortcuts

Shift + Enter


TextMate 2 (MacOS)
Continue Block Comment
PHP Shortcuts

Enter


JetBrains AppCode (MacOS)
Start New line
Editing Shortcuts

Shift + Enter


GTA V Cheats (Windows)
Phone Select
Cellphone Controls

Enter


Rocket.Chat (Web Application)
New line in Message Compose Input
On Windows Plateform

Shift + Enter


FileZilla (Windows)
Transfers the currently selected item if it is a file or expands it if it is a directory
28 Shortcuts for FileZilla (Windows)

Enter


Rocket.Chat (Web Application)
New line in Message Compose Input
On Mac Plateform

Shift + Enter


JetBrains PyCharm (Windows)
Start New line
Editing

Shift + Enter


Adobe XD (Experience Design) (Windows)
Edit Text
Operations Menu

Enter


Adobe XD (Experience Design) (MacOS)
Edit Text
Operations Menu

Enter


Autodesk Mudbox 2017 (Windows)
End a Curve
Curve

Enter


Zimbra Collaboration Suite 8 (Windows)
Press Button
Buttons

Enter


Autodesk SketchBook Pro (Windows)
Fill/Commit the Result
Tools

Enter


Zimbra Collaboration Suite 8 (Windows)
Select current item
PopUp Menus

Enter


Desk.com (Windows)
Open case
Filter View

Enter / O


Desk.com (MacOS)
Open case
Filter View

Enter / O


Zimbra Collaboration Suite 8 (Windows)
Double Click Selected Item
Lists

Enter


Zimbra Collaboration Suite 8 (Windows)
Save Changes to Dialog
Dialog Boxes

Enter / Spacebar


Autodesk SketchBook Pro (Windows)
Play/Stop
Actions

Enter


Clarizen (Web Application)
Opens the sub items menu if Available else Go to Selected SubItem Page
Navigation

Enter


Clarizen (Web Application)
If only One cell is Selected Opens the popup editor else Do Nothing
Main Grid

Enter


JetBrains PhpStorm (Windows)
Start New line
Editing

Shift + Enter


Clarizen (Web Application)
Adds a new line when the cursor is in a multi-line text box
PopUp/Item editor

Enter


Clarizen (Web Application)
Save and Create New (where applicable)
PopUp/Item editor

Shift + Enter


SharePoint 2016 (Windows)
Expand Menus, such as the Drop-down menu for a list item
Global Shortcuts

Shift + Enter


Clarizen (Web Application)
Adds a new line when the cursor is in a multi-line text box
Other PopUps

Enter


JetBrains PhpStorm (Linux)
Start New line
Editing

Shift + Enter


SharePoint 2016 (Windows)
Insert a new line(Not in HTML)
Rich Text Editing

Shift + Enter


Clarizen (Web Application)
Save and adds New if applicable
Other PopUps

Shift + Enter


Clarizen (Web Application)
Performs relevant action if the focus is on a button (OK, Cancel, Today etc.)
Range Filter

Enter


Clarizen (Web Application)
Performs Relevant Action if the Focus is on a Button (OK, Cancel etc.)
Global filter Pane

Enter


Clarizen (Web Application)
Adds new line in the message
Social Media

Enter


Freshdesk (Web Application)
Open Ticket
Tickets

Enter


Clarizen (Web Application)
Save note
Miscellanous Shortcuts

Ctrl + Enter / Shift + Enter


Microsoft Excel 2016 (MacOS)
Perform the action assigned to the default command button (the button with the bold outline, often the OK button)
Work in windows and dialogs

Enter


Microsoft Teams (Windows)
Start a new line
Messaging Shortcuts

Shift + Enter


Microsoft Excel 2016 (MacOS)
Complete a cell entry and move forward in the selection
Enter data on a sheet

Enter


Microsoft Excel 2016 (MacOS)
Complete a cell entry and move up in the selection
Enter data on a sheet

Shift + Enter


Daz 3D Bryce 7 (Windows)
Stop Fly around
Fly Around View

Enter


Daz 3D Bryce 7 (MacOS)
Stop Fly around
Fly Around View

Enter


Microsoft Excel 2016 (MacOS)
Complete a cell entry
Work in cells or the Formula bar

Enter


Cyberduck (MacOS)
View selected issue
Navigating Issues

O / Enter


Opera (Windows)
Activate
Focus

Enter


Opera (MacOS)
Activate
Focus

Enter


ACDSee (Windows)
Close View Mode and Returns to Previous Mode
View Mode

Enter


Corel Ventura 10 (Windows)
Line Break
Special Characters

Shift + Enter


Corel Quattro Pro X8 (Windows)
Enters Data and Exit Edit Mode
EditMode Shortcuts

Enter


Microsoft Excel 2016 (MacOS)
Complete a cell entry
Format and edit data

Enter


Opera (MacOS)
Follow selected link
Link

Enter


Opera (MacOS)
Open selected link in new tab
Link

Shift + Enter


Opera (Windows)
Follow selected link
Link

Enter


Opera (Windows)
Open selected link in new tab
Link

Shift + Enter


Microsoft Excel 2016 (MacOS)
Move from top to bottom within the selection (down)*
Work with a selection

Enter


Microsoft Excel 2016 (MacOS)
Move from bottom to top within the selection (up)*
Work with a selection

Shift + Enter


Opera (MacOS)
Open bookmark
Bookmarks

Enter


Opera (MacOS)
Open bookmark in new tab
Bookmarks

Shift + Enter


Opera (Windows)
Open bookmark
Bookmarks

Enter


Opera (Windows)
Open bookmark in new tab
Bookmarks

Shift + Enter