Microsoft Excel 2010 (Windows)

The Rest - Manage Active Selections

Move active cell right / left in a selection.

Tab / Shift + Tab

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


Microsoft Outlook 2010 (Windows)
Cycle forward / backward between screen elements (Navigation Pane, Message List, Search, Reading Pane)
Messages in Main View - Main Window

Tab / Shift + Tab


Microsoft OneNote 2010 (Windows)
Increase indent by one level in right-to-left text.
Various Other OneNote Shortcuts - Special language settings

tab


Microsoft OneNote 2010 (Windows)
Decrease indent by one level in right-to-left text.
Various Other OneNote Shortcuts - Special language settings

shift + tab


Adobe Photoshop CS5 (MacOS)
Show/Hide all panels
Photoshop CS5 Panels - All Panels

Tab


Adobe Photoshop CS5 (MacOS)
Show/Hide all panels except the toolbox and options bar
Photoshop CS5 Panels - All Panels

Shift + Tab


Adobe Photoshop CS5 (Windows)
Show/Hide all panels
Photoshop CS5 Panels - All Panels

Tab


Adobe Photoshop CS5 (Windows)
Show/Hide all panels except the toolbox and options bar
Photoshop CS5 Panels - All Panels

Shift + Tab


Microsoft Outlook 2010 (Windows)
Cycle forward / cycle backward between Screen Elements (e.g. Navigation Pane, Message List, Search, Reading Pane)
Messages in Main View - Message List and Single Messages

Tab / Shift + Tab


Microsoft Projects 2010 (Windows)
With active selection: move to the right / move to the left
Navigate Gantt Chart and Select Tasks

Tab / Shift + Tab


Google Chrome (Windows)
Edit next / edit previous property
Manage Chrome DevTools - Styles Panel

Tab / Shift + Tab


Firebug (Windows)
Jump to next / jump to previous field
CSS-Panel

Tab / Shift + Tab


Microsoft Windows 7 (Windows)
Switch focus forward/ backward between Address bar, Search Bar, Toolbar, Navigation Pane, and File List (Default is usually File List)
Managing 'Windows' in Windows 7 - Basics

Tab / Shift + Tab


Remember the Milk (Web Application)
Save input and move to next input field
Selection

tab


Firebug (Linux)
Jump to next / jump to previous field
CSS-Panel

Tab / Shift + Tab


Adobe Photoshop CS4 (MacOS)
Cycle through controls on right from top (Extract, Liquify, and Pattern Maker)
Shortcut Keys for working with Extract, Liquify, and Pattern Maker

Tab


Adobe Photoshop CS4 (MacOS)
Cycle through controls on right from bottom (Extract, Liquify, and Pattern Maker)
Shortcut Keys for working with Extract, Liquify, and Pattern Maker

Shift + Tab


Thunderbird (Windows)
Switch focus between Folders Pane and Message List Pane
Navigate Messages

F6 / Tab / Shift + Tab


Firebug (MacOS)
Jump to next / jump to previous field
CSS-Panel

Tab / Shift + Tab


Microsoft Outlook 2010 (Windows)
Cycle between To, Cc, Subject, and Message Body
Messages in Main View - Manage Messages

Tab


Thunderbird (Linux)
Switch focus between Folders Pane and Message List Pane
Navigate Messages

F6 / Tab / Shift + Tab


Thunderbird (MacOS)
Switch focus between Folders Pane and Message List Pane
Navigate Messages

F6 / Tab / Shift + Tab


Microsoft Projects 2010 (Windows)
Select the next item / previous item
Navigate Projects Help

Tab / Shift + Tab


Eclipse Helios (Windows)
Increase / decrease indent of selected text
Indentions and Comments

Tab / Shift + Tab


Microsoft Outlook 2010 (Windows)
Select next/ select previous appointment in Calendar View
Messages in Main View - Create and Manage Appointments

Tab / Shift + Tab


Google Mail (Windows)
Increase / Decrease Indent
Tasks in Gmail

Tab / Shift + Tab


Access 2010 (Windows)
Toggle the focus forward between controls in the wizard
Manage Access Features - Wizards

Tab


Firefox (Linux)
Jump to next / jump to previous link
Inside Webpages

Tab / Shift + Tab


Firefox (Windows)
Jump to next / jump to previous link
Inside Webpages

Tab / Shift + Tab


Microsoft Outlook 2010 (Windows)
Jump to next / previous input field
Messages in Main View - Create and Manage Appointments

Tab / Shift + Tab


Google Mail (Windows)
Jump forward / jump backwards between input fields
Control Main Browser Window (General Browser Shortcuts)

Tab / Shift + Tab


Firefox (MacOS)
Move Focus to Next Actionable Item
Navigation Controls

Tab


Google Chrome (Linux)
Edit next / edit previous property
Manage Chrome DevTools - Styles Panel

Tab / Shift + Tab


Firefox (MacOS)
Move Focus to Previous Actionable Item
Navigation Controls

Shift + Tab


Microsoft OneNote 2010 (Windows)
Create a table by adding a second column to already typed text.Create another column in a table with a single row.
Creating and Manipulating OneNote Tables

tab


Access 2010 (Windows)
Move to the next / switch to previous option or option group
Manage Access Features - Dialog Boxes

Tab / Shift + Tab


Microsoft Outlook 2010 (Windows)
Select next/ select previous appointment
Messages in Main View - Navigate Calendar

Tab / Shift + Tab


Access 2010 (Windows)
Move to the upper Field List pane from the lower pane
Manage Access Features - Field List Pane

Shift + Tab


Microsoft Outlook 2010 (Windows)
Cycle forward / backward between screen elements (Navigation Pane, Message List, Search, Reading Pane)
Messages in Compose View - Main Window

Tab / Shift + Tab


Access 2010 (Windows)
Move to the lower Field List pane from the upper pane
Manage Access Features - Field List Pane

Tab


Microsoft Windows 7 (Windows)
Switch focus forward/ backward between Address bar, Search Bar, Toolbar, Navigation Pane, and File List (Default is usually File List)
Windows Explorer - Basics

Tab / Shift + Tab


Access 2010 (Windows)
Select next field / select previous field
Manage Access Features - Select and move Fields or Columns

Tab / Shift + Tab


SharpDevelop 4.0 (Windows)
Increase / decrease indent
Coding Shortcuts

Tab / Shift + Tab


Microsoft OneNote 2010 (Windows)
Increase / decrease indent by one level.
Working with Outlines

tab / shift + tab


Google Chrome (Windows)
Jump to next / previous link
Browse within Webpages

Tab / Shift + Tab with focus on webpage


Microsoft Outlook 2010 (Windows)
Cycle forward / cycle backward between Screen Elements (e.g. Navigation Pane, Message List, Search, Reading Pane)
Messages in Compose View - Message List and Single Messages

Tab / Shift + Tab


Notepad++ 5 (Windows)
Increase line indent
Edit - Indent

Tab


Notepad++ 5 (Windows)
Decrease line indent
Edit - Indent

Shift + Tab


Firefox (Linux)
Jump to next or previous form element
Forms

Tab / Shift + Tab


Firefox (Windows)
Jump to next or previous form element
Forms

Tab / Shift + Tab


Microsoft Outlook 2010 (Windows)
Cycle between To, Cc, Subject, and Message Body
Messages in Compose View - Manage Messages

Tab


Adobe Photoshop CS5 (MacOS)
Cycle through controls on right from top
Photoshop CS5 Panels - Extract and Pattern Maker

Tab


Microsoft Word 2007 (Windows)
Select the next cell's contents.
Edit and move text and graphics: Select text and graphics in a table

Tab


Adobe Photoshop CS5 (MacOS)
Cycle through controls on right from bottom
Photoshop CS5 Panels - Extract and Pattern Maker

Shift + Tab


Microsoft Word 2007 (Windows)
Select the preceding cell's contents.
Edit and move text and graphics: Select text and graphics in a table

Shift + Tab


Notepad++ 5 (Windows)
Increase line indent
Search - Indent

Tab


Notepad++ 5 (Windows)
Decrease line indent
Search - Indent

Shift + Tab


Access 2010 (Windows)
Move to next / move to previous field in current record
Manage Access Features - Navigate in Datasheet, Subdatasheet, and Form View

Tab / Shift + Tab


Adobe Photoshop CS5 (Windows)
Cycle through controls on right from top
Photoshop CS5 Panels - Extract and Pattern Maker

Tab


Adobe Photoshop CS5 (Windows)
Cycle through controls on right from bottom
Photoshop CS5 Panels - Extract and Pattern Maker

Shift + Tab


Microsoft Word 2007 (Windows)
One cell to the left (in a table)
Edit and move text and graphics: Move through your document

Shift + Tab


Microsoft Word 2007 (Windows)
One cell to the right (in a table)
Edit and move text and graphics: Move through your document

Tab


Google Chrome (Linux)
Jump to next / previous link
Browse within Webpages

Tab / Shift + Tab with focus on webpage


Access 2010 (Windows)
Move from table title bar to table title bar, or from cell to cell inside a table
Manage Access Features - Database Diagram

Tab


Access 2010 (Windows)
Move forward / backwards among tables, views, functions, or join line.
Manage Access Features - Query Designer

Tab / Shift + Tab


Microsoft Outlook 2010 (Windows)
Select next/ select previous appointment in Calendar View
Messages in Compose View - Create and Manage Appointments

Tab / Shift + Tab


Access 2010 (Windows)
Move to the right / to the left
Manage Access Features - Pivot Table

Tab / Shift + Tab


Microsoft Outlook 2010 (Windows)
Jump to next / previous input field
Messages in Compose View - Create and Manage Appointments

Tab / Shift + Tab


Microsoft Word 2007 (Windows)
To the next cell in a row
Edit and move text and graphics: Move around in a table

Tab


Microsoft Word 2007 (Windows)
To the previous cell in a row
Edit and move text and graphics: Move around in a table

Shift + Tab


Microsoft Windows 7 (Windows)
Switch focus forward/ backward between Address bar, Search Bar, Toolbar, Navigation Pane, and File List (Default is usually File List)
Windows Admin - Basics

Tab / Shift + Tab


Adobe Photoshop CS5 (MacOS)
Show/Hide all panels
Extract and Pattern Maker (plug-in) - All Panels

Tab


Adobe Photoshop CS5 (MacOS)
Show/Hide all panels except the toolbox and options bar
Extract and Pattern Maker (plug-in) - All Panels

Shift + Tab


Microsoft Outlook 2010 (Windows)
Select next/ select previous appointment
Messages in Compose View - Navigate Calendar

Tab / Shift + Tab


Google Docs (MacOS)
Increase paragraph indentation
Edit Documents

Tab


Google Docs (MacOS)
Decrease paragraph indentation
Edit Documents

Shift + Tab


Google Docs (Windows)
Increase paragraph indentation
Edit Documents

Tab


Google Docs (Windows)
Decrease paragraph indentation
Edit Documents

Shift + Tab


Adobe Photoshop CS5 (Windows)
Show/Hide all panels
Extract and Pattern Maker (plug-in) - All Panels

Tab


Adobe Photoshop CS5 (Windows)
Show/Hide all panels except the toolbox and options bar
Extract and Pattern Maker (plug-in) - All Panels

Shift + Tab


Microsoft Excel 2011 (MacOS)
Move between unlocked cells on a protected sheet
Moving and scrolling in a sheet or workbook

Tab


Tekla Structures 14.0 (Windows)
Next position / Previous position
General shortcuts

Tab / Shift + Tab


Microsoft Outlook 2010 (Windows)
Cycle forward / backward between screen elements (Navigation Pane, Message List, Search, Reading Pane)
Calendar Shortcuts - Main Window

Tab / Shift + Tab


Microsoft Excel 2011 (MacOS)
Complete a cell entry and move to the right in the selection
Entering data on a sheet

Tab


Microsoft Excel 2011 (MacOS)
Complete a cell entry and move to the left in the selection
Entering data on a sheet

Shift + Tab


Total Commander 8 (Windows)
Switch between left and right file list
Main Shortcuts

Tab


Total Commander 8 (Windows)
Switch between current file list and separate tree (if enabled)
Main Shortcuts

Shift + Tab


Microsoft Outlook 2010 (Windows)
Cycle forward / cycle backward between Screen Elements (e.g. Navigation Pane, Message List, Search, Reading Pane)
Calendar Shortcuts - Message List and Single Messages

Tab / Shift + Tab


Mindjet Mindmanager 2012 (Windows)
previous or next (often same as arrows)
Moving the blue box

Tab / Shift + Tab


Microsoft Windows 8 (Windows)
Switch focus forward/ backward between Address bar, Search Bar, Toolbar, Navigation Pane, and File List (Default is usually File List)
Windows Explorer - Basics

Tab / Shift + Tab


Access 2010 (Windows)
Go to next / go to previous text or hyperlink
Manage Access Features - Help Window

Tab / Shift + Tab


Open Office Impress (Linux)
Select objects in the order in which they were created.
Select and Move Elements

Tab


Open Office Impress (Linux)
Select objects in the reverse order in which they were created.
Select and Move Elements

Shift + Tab


Opera (Linux)
Cycle forwards focus within active context
Focus

Tab


Opera (Linux)
Cycle backwardss focus within active context
Focus

Shift + Tab


Microsoft Outlook 2010 (Windows)
Cycle between To, Cc, Subject, and Message Body
Calendar Shortcuts - Manage Messages

Tab


Microsoft Windows 7 (Windows)
Switch focus forward/ backward between Address bar, Search Bar, Toolbar, Navigation Pane, and File List (Default is usually File List)
Ease of Access and Magnifier - Basics

Tab / Shift + Tab


Photoshop Lightroom 4 (Windows)
Show/hide side panels
Working with Panels

Tab


Photoshop Lightroom 4 (Windows)
Show/hide all panels
Working with Panels

Shift + Tab


Access 2010 (Windows)
Toggle the focus forward between controls in the wizard
Working with Text and Data - Wizards

Tab


Photoshop Lightroom 4 (MacOS)
Show/hide side panels
Working with Panels

Tab


Photoshop Lightroom 4 (MacOS)
Show/hide all panels
Working with Panels

Shift + Tab


Access 2010 (Windows)
Move to the next / switch to previous option or option group
Working with Text and Data - Dialog Boxes

Tab / Shift + Tab


InDesign CS5 (MacOS)
Move to next/previous cell
Working with Tables

Tab / Shift + Tab


Microsoft Outlook 2010 (Windows)
Select next/ select previous appointment in Calendar View
Calendar Shortcuts - Create and Manage Appointments

Tab / Shift + Tab


Microsoft Outlook 2010 (Windows)
Jump to next / previous input field
Calendar Shortcuts - Create and Manage Appointments

Tab / Shift + Tab


Evernote (MacOS)
Increase List Level / Decrease List Level
Note Editor

Shift + + Tab / Shift + Tab


Microsoft Excel 2011 (MacOS)
Move from left to right within the selection, or move down one cell if only one column is selected
Working with a selection

Tab


Access 2010 (Windows)
Move to the upper Field List pane from the lower pane
Working with Text and Data - Field List Pane

Shift + Tab


Microsoft Excel 2011 (MacOS)
Move from right to left within the selection, or move up one cell if only one column is selected
Working with a selection

Shift + Tab


Access 2010 (Windows)
Move to the lower Field List pane from the upper pane
Working with Text and Data - Field List Pane

Tab


Access 2010 (Windows)
Select next field / select previous field
Working with Text and Data - Select and move Fields or Columns

Tab / Shift + Tab


Microsoft Outlook 2010 (Windows)
Select next/ select previous appointment
Calendar Shortcuts - Navigate Calendar

Tab / Shift + Tab


Opera (Linux)
Go to next element in form
Form

Tab


Opera (Linux)
Go to previous element in form
Form

Shift + Tab


Microsoft PowerPoint 2010 (Windows)
Go to the first or next hyperlink on a slide.
Show PowerPoint Presentation with Shortcuts

Tab


Microsoft PowerPoint 2010 (Windows)
Go to the last or previous hyperlink on a slide.
Show PowerPoint Presentation with Shortcuts

Shift + Tab


Microsoft Excel 2011 (MacOS)
Move to the next field / previous field that you can edit in the record
Data forms

Tab / Shift + Tab


Jaws 11.0 (Windows)
Next Link (Shift + Tab for previous
Navigation in HTML (Internet browsing)

Tab


Adobe Photoshop CS5 (MacOS)
Cycle through controls on right from top
Extract and Pattern Maker (plug-in) - Extract and Pattern Maker

Tab


Adobe Photoshop CS5 (MacOS)
Cycle through controls on right from bottom
Extract and Pattern Maker (plug-in) - Extract and Pattern Maker

Shift + Tab


Adobe Photoshop CS4 (MacOS)
Show/Hide all panels
Shortcut Keys for using panels

Tab


Adobe Photoshop CS4 (MacOS)
Show/Hide all panels except the toolbox and options bar
Shortcut Keys for using panels

Shift + Tab


Microsoft Excel 2011 (MacOS)
When a toolbar is active, select the next button or menu on the toolbar
Toolbars

Tab


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

Tab / Shift + tab until the object you want is selected


Microsoft Excel 2011 (MacOS)
When a toolbar is active, select the previous button or menu on the toolbar
Toolbars

Shift + Tab


Access 2010 (Windows)
Move to next / move to previous field in current record
Working with Text and Data - Navigate in Datasheet, Subdatasheet, and Form View

Tab / Shift + Tab


Adobe Photoshop CS5 (Windows)
Cycle through controls on right from top
Extract and Pattern Maker (plug-in) - Extract and Pattern Maker

Tab


Adobe Photoshop CS5 (Windows)
Cycle through controls on right from bottom
Extract and Pattern Maker (plug-in) - Extract and Pattern Maker

Shift + Tab


Microsoft Windows 7 (Windows)
Move forward / move backwards through options
Dialog Boxes

Tab / Shift + Tab


Microsoft Windows 7 (Windows)
Move between links
Windows Help

Tab


Access 2010 (Windows)
Move from table title bar to table title bar, or from cell to cell inside a table
Working with Text and Data - Database Diagram

Tab


Microsoft Excel 2011 (MacOS)
Move to the next text box
Dialog boxes

Tab


Microsoft Excel 2011 (MacOS)
Move to the previous text box
Dialog boxes

Shift + Tab


Access 2010 (Windows)
Move forward / backwards among tables, views, functions, or join line.
Working with Text and Data - Query Designer

Tab / Shift + Tab


Access 2010 (Windows)
Move to the right / to the left
Working with Text and Data - Pivot Table

Tab / Shift + Tab


Microsoft Outlook 2010 (Windows)
Switch between Navigation Pane, Tasks list, and To-Do Bar
Tasks Shortcuts

Shift + Tab


Microsoft PowerPoint 2010 (Windows)
Move to the next cell in table.
Basic Text Navigation and Formatting

Tab


Microsoft PowerPoint 2010 (Windows)
Move to the preceding cell in table.
Basic Text Navigation and Formatting

Shift + Tab


InDesign CS5 (MacOS)
Apply value and select next value
Panels

Tab


InDesign CS5 (MacOS)
Show/Hide all panels, Toolbox, and Control panel (with no insertion point)
Panels

Tab


InDesign CS5 (MacOS)
Show/Hide all panels except the Toolbox and Control panel (docked or not)
Panels

Shift + Tab


Microsoft Outlook 2010 (Windows)
Move to next / move to previous field
Business Card View

Tab / Shift + Tab


Avid Media Composer 7 (MacOS)
Moves from one active slider to next (In Effect Editor)
Effect Mode

Tab


Avid Media Composer 7 (Windows)
Moves from one active slider to next (In Effect Editor)
Effect Mode

Tab


Adobe Illustrator CS5 (MacOS)
Show/Hide all panels
Panel Shortcuts

Tab


Adobe Illustrator CS5 (MacOS)
Show/Hide all panels except the Tools panel and Control panel
Panel Shortcuts

Shift + Tab


IntelliJ (Linux)
Indent/unindent selected lines
Editing

Tab / Shift + Tab


Microsoft PowerPoint 2010 (Windows)
Move between options or areas in the dialog box.
Manage Open and Save As dialog boxes

Tab


IntelliJ (Windows)
Indent/unindent selected lines
Editing

Tab / Shift + Tab


Microsoft PowerPoint 2010 (Windows)
Move to the next cell.
Move around in Tables

Tab


Microsoft PowerPoint 2010 (Windows)
Move to the preceding cell.
Move around in Tables

Shift + Tab


Access 2010 (Windows)
Go to next / go to previous text or hyperlink
Working with Text and Data - Help Window

Tab / Shift + Tab


Adobe Photoshop CS5 (MacOS)
Cycle through controls on right from top
Liquify

Tab


Adobe Photoshop CS5 (MacOS)
Cycle through controls on right from bottom
Liquify

Shift + Tab


iTunes (Windows)
Select the next control
With full keyboard navigation enabled

Tab


Access 2010 (Windows)
Toggle the focus forward between controls in the wizard
Working with Access Views - Wizards

Tab


HoneyView 5.03 (Windows)
File/EXIF Info
Change Image View

Tab


Microsoft PowerPoint 2010 (Windows)
Move to the next option or option group.
Work with Dialog Boxes

Tab


Microsoft PowerPoint 2010 (Windows)
Move to the previous option or option group.
Work with Dialog Boxes

Shift + Tab


Adobe Photoshop CS5 (Windows)
Cycle through controls on right from top
Liquify

Tab


Adobe Photoshop CS5 (Windows)
Cycle through controls on right from bottom
Liquify

Shift + Tab


Access 2010 (Windows)
Move to the next / switch to previous option or option group
Working with Access Views - Dialog Boxes

Tab / Shift + Tab


Microsoft Excel 2013 (Windows)
Move one cell to the right / to the left in a worksheet
Navigate Worksheets

Tab / Shift + Tab


Gwenview (Linux)
When multiple images are displayed in View Mode, this switched to the image to the right of the currently selected image.
30 Shortcuts for Gwenview (Linux)

Tab


Access 2010 (Windows)
Move to the upper Field List pane from the lower pane
Working with Access Views - Field List Pane

Shift + Tab


Gwenview (Linux)
When multiple images are displayed in View Mode, this switched to the image to the left of the currently selected image.
30 Shortcuts for Gwenview (Linux)

Shift + Tab


Access 2010 (Windows)
Move to the lower Field List pane from the upper pane
Working with Access Views - Field List Pane

Tab


Access 2010 (Windows)
Select next field / select previous field
Working with Access Views - Select and move Fields or Columns

Tab / Shift + Tab


Microsoft PowerPoint 2010 (Windows)
Switch the keyboard focus within the Selection pane between tree view and the Show All and Hide All buttons.
Work with the Selection pane.

Tab / Shift + Tab


Audacity 2 (Windows)
Move to and open next label
Edit Menu

Tab


Audacity 2 (Windows)
Move to and open previous label
Edit Menu

Shift + Tab


Virtual DJ (Windows)
Select on active deck
All Shortcuts

Tab


FileMaker Pro (MacOS)
Select an object on the layout
Layout Mode Shortcuts - Select and Modify Objects

Tab / Shift + Tab repeatedly until the desired object is selected.


FileMaker Pro (Windows)
Select an object
Layout Mode Shortcuts - Select and Modify Objects

Tab / Shift + Tab repeatedly until the desired object is selected


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

Tab / Shift + Tab


FL Studio (Windows)
Cycle nested windows
Window Navigation

Tab


Microsoft Excel 2013 (Windows)
Complete a cell entry and move to the right / to the left in the selection
Edit Content of Cells

Tab / Shift + Tab


Adobe Illustrator CS5 (Windows)
Show/Hide all panels
Panel Shortcuts

Tab


Adobe Illustrator CS5 (Windows)
Show/Hide all panels except the Tools panel and Control panel
Panel Shortcuts

Shift + Tab


Access 2010 (Windows)
Move to next / move to previous field in current record
Working with Access Views - Navigate in Datasheet, Subdatasheet, and Form View

Tab / Shift + Tab


Presonus Studio One (Windows)
Focus next
Navigation

Tab


Presonus Studio One (Windows)
Focus previous
Navigation

Shift + Tab


Access 2010 (Windows)
Move from table title bar to table title bar, or from cell to cell inside a table
Working with Access Views - Database Diagram

Tab


Adobe Acrobat Pro (Windows)
Navigate to the next panel and panel control within an open Task pane
Navigation - Navigating task panes

Tab


Access 2010 (Windows)
Move forward / backwards among tables, views, functions, or join line.
Working with Access Views - Query Designer

Tab / Shift + Tab


Adobe Acrobat Pro (Windows)
Navigate to the previous panel and panel control within an open Task pane
Navigation - Navigating task panes

Shift + Tab


Access 2010 (Windows)
Move to the right / to the left
Working with Access Views - Pivot Table

Tab / Shift + Tab


Adobe Acrobat Pro (Windows)
Navigate to the next item in the active panel in the Create New Action, Edit Action, Create Custom Tool, or the Edit Custom Tool dialog boxes
Navigation - Navigating task panes

Tab


Adobe Acrobat Pro (Windows)
Navigate to the previous item in the active panel in the Create New Action, Edit Action, Create Custom Tool, or the Edit Custom Tool dialog boxes
Navigation - Navigating task panes

Shift + Tab


Adobe Acrobat Pro (Windows)
Move among the elements of the active navigation panel
Navigation - Navigation panels

Tab


Adobe Acrobat Pro (Windows)
Move focus to the next link within a pane
Navigation - Navigating the Help window

Tab


Adobe Acrobat Pro (Windows)
Move focus to the previous link within a pane
Navigation - Navigating the Help window

Shift + Tab


Adobe Acrobat Pro (Windows)
Move focus to next comment or form field
Comments

Tab


Adobe Acrobat Pro (Windows)
Move focus to previous comment or form field
Comments

Shift + Tab


FileMaker Pro (MacOS)
Switch between the relationships graph and the zoom controls
Layout Mode Shortcuts - Select and Arrange Table and Relationship

Tab


Adobe Acrobat Pro (Windows)
Navigate through the other controls in the top bar - Home, Tools, Document
Navigation

Arrow Right / Arrow Left / Tab / Shift + Tab


Microsoft Word 2013 (Windows)
In Navigation Pane: Move through Navigation Pane options
Ribbons and Navigation Pane

Tab / Shift + Tab


Adobe Acrobat Pro (Windows)
Move focus to next comment, link, or form field in the document pane
Navigation

Tab


Microsoft Word 2013 (Windows)
Jump to (and select) next / previous table cell
Tables

Tab / Shift + Tab


Adobe Acrobat Pro (Windows)
Move focus to previous comment, link, or form field in the document pane
Navigation

Shift + Tab


Windows 10 Command Prompt (Windows)
Autocomplete Folder or File Name
Enter and Manipulate Text

Tab


Adobe Acrobat Pro (Windows)
Move forward or backward among the current column header selected for sorting, the current row with focus, and the Go Back button if in a folder
PDF Portfolios

Tab / Shift + Tab


Microsoft Word 2013 (Windows)
Promote / Demote a paragraph (or Alt+Shift+Arrow Left/Arrow Right)
Outline View

Tab / Shift + Tab


FileMaker Pro (Windows)
Move the selection from the relationships graph to the command buttons and proceed from left to right
Layout Mode Shortcuts - Relationships Graph

Tab


FileMaker Pro (Windows)
Move the selection through the command buttons from right to left and to the relationships graph from the Add Table command
Layout Mode Shortcuts - Relationships Graph

Shift + Tab


Access 2010 (Windows)
Go to next / go to previous text or hyperlink
Working with Access Views - Help Window

Tab / Shift + Tab


FileMaker Pro (MacOS)
Select an object on the layout
Text Shortcuts - Select and Modify Objects

Tab / Shift + Tab repeatedly until the desired object is selected.


FileMaker Pro (Windows)
Select an object
Text Shortcuts - Select and Modify Objects

Tab / Shift + Tab repeatedly until the desired object is selected


Sonar 2015 (Windows)
Go to next audio transient or MIDI note in selected tracks (or current track if there is no selection)
Track View

Tab


Sonar 2015 (Windows)
Go to previous audio transient or MIDI note in selected tracks (or current track if there is no selection)
Track View

Shift + Tab


Microsoft Excel 2013 (Windows)
Move to the next / previous option
Dialog Boxes

Tab / Shift + Tab


Microsoft Windows 10 (Windows)
Move forward / move backwards through options
Windows Dialog Boxes

Tab / Shift + Tab


Access 2010 (Windows)
Toggle the focus forward between controls in the wizard
The Rest - Wizards

Tab


Microsoft Excel 2013 (Windows)
Move to the next / previous field which can be edited
Data Forms

Tab / Shift + Tab


Access 2010 (Windows)
Move to the next / switch to previous option or option group
The Rest - Dialog Boxes

Tab / Shift + Tab


Access 2010 (Windows)
Move to the upper Field List pane from the lower pane
The Rest - Field List Pane

Shift + Tab


Access 2010 (Windows)
Move to the lower Field List pane from the upper pane
The Rest - Field List Pane

Tab


Access 2010 (Windows)
Select next field / select previous field
The Rest - Select and move Fields or Columns

Tab / Shift + Tab


Photoshop Lightroom CC (Windows)
Show/ hide side panels
Panel Shortcuts

Tab


Photoshop Lightroom CC (Windows)
Show/ hide all panels
Panel Shortcuts

Shift + Tab


Photoshop Lightroom CC (MacOS)
Show/ hide side panels
Panel Shortcuts

Tab


Photoshop Lightroom CC (MacOS)
Show/ hide all panels
Panel Shortcuts

Shift + Tab


GTDNext.com (Windows)
Indent (create sub-task)
Center Pane Shortcuts

Tab


GTDNext.com (Windows)
Outdent
Center Pane Shortcuts

Shift + Tab


Camtasia 2 (MacOS)
Next caption / previous caption
Timeline & Editing

Tab


Quickbooks Online (Web Application)
Calculate the Result
Calculate Amounts and Rates

Tab


Quickbooks Online (Windows)
Calculate the Result
Calculate Amounts and Rates

Tab


Quickbooks Online (Web Application)
Go forward / go backwards
Navigate Form Fields and Manage Drop-down Lists

Tab / Shift + Tab


Quickbooks Online (Windows)
Go forward / go backwards
Navigate Form Fields and Manage Drop-down Lists

Tab / Shift + Tab


Quickbooks Online (Web Application)
Select item and move to next field
Navigate Form Fields and Manage Drop-down Lists

Tab


Quickbooks Online (Windows)
Select item and move to next field
Navigate Form Fields and Manage Drop-down Lists

Tab


Microsoft Outlook 2016 (Windows)
Move between the Outlook window, the smaller panes in the Folder Pane, the Reading Pane, and the sections in the To-Do Bar
Basic Navigation

Tab


Quickbooks Online (Web Application)
Select the transaction type field in a new transaction row
Selecting Transactions in Account Registers

Shift + Tab


Quickbooks Online (Windows)
Select the transaction type field in a new transaction row
Selecting Transactions in Account Registers

Shift + Tab


Quickbooks Online (Web Application)
Select transaction and move to next field
Selecting Transactions in Account Registers

Tab


Quickbooks Online (Windows)
Select transaction and move to next field
Selecting Transactions in Account Registers

Tab


FileMaker Pro (MacOS)
Switch between the relationships graph and the zoom controls
Text Shortcuts - Select and Arrange Table and Relationship

Tab


Google Mail (MacOS)
Increase / Decrease Indent
Tasks in Gmail

Tab / Shift + Tab


Clink (Windows)
completion
Clink Commands

Tab


Google Mail (MacOS)
Jump forward / jump backwards between input fields
Control Main Browser Window (General Browser Shortcuts)

Tab / Shift + Tab


Skype for Business (Lync) 2016 (Windows)
With slide in focus - Access controls (Prev arrow, Next arrow, Thumbnails, and Notes)
PowerPoint Sharing

Tab


Adobe After Effects CC (Windows)
Open Composition Mini-Flowchart for active Composition
Compositions and Work Area

Tab


Access 2010 (Windows)
Move to next / move to previous field in current record
The Rest - Navigate in Datasheet, Subdatasheet, and Form View

Tab / Shift + Tab


Nirvana (Web Application)
For Focus
Rapid Entry

Tab / E


Microsoft OneNote 2016 (Windows)
Create able by adding a second column to already typed text.Create another column in table with a single row.
OneNote Tables

Tab


Adobe After Effects CC (MacOS)
Open Composition Mini-Flowchart for active Composition
Compositions and Work Area

Tab


Access 2016 (Windows)
Move to next cell
Database Operation

Tab


FileMaker Pro (Windows)
Move the selection from the relationships graph to the command buttons and proceed from left to right
Text Shortcuts - Relationships Graph

Tab


FileMaker Pro (MacOS)
Select an object on the layout
Database Management Shortcuts - Select and Modify Objects

Tab / Shift + Tab repeatedly until the desired object is selected.


FileMaker Pro (Windows)
Move the selection through the command buttons from right to left and to the relationships graph from the Add Table command
Text Shortcuts - Relationships Graph

Shift + Tab


Access 2010 (Windows)
Move from table title bar to table title bar, or from cell to cell inside a table
The Rest - Database Diagram

Tab


Adobe Photoshop CC (Windows)
Show/Hide all panels
Basic Shortcuts for Photoshop CC 2015 - Shortcuts for all Panels

Tab


Adobe Photoshop CC (Windows)
Show/Hide all panels except the toolbox and options bar
Basic Shortcuts for Photoshop CC 2015 - Shortcuts for all Panels

Shift + Tab


Access 2010 (Windows)
Move forward / backwards among tables, views, functions, or join line.
The Rest - Query Designer

Tab / Shift + Tab


Microsoft OneNote 2016 (Windows)
Increase/ decrease indent by one level
Outlines

Tab / Shift + Tab


FileMaker Pro (Windows)
Select an object
Database Management Shortcuts - Select and Modify Objects

Tab / Shift + Tab repeatedly until the desired object is selected


Adobe Photoshop CC (MacOS)
Show/Hide all panels
Basic Shortcuts for PhotoShop CC 2015 - Shortcuts for all Panels

Tab


Access 2010 (Windows)
Move to the right / to the left
The Rest - Pivot Table

Tab / Shift + Tab


Adobe Photoshop CC (MacOS)
Show/Hide all panels except the toolbox and options bar
Basic Shortcuts for PhotoShop CC 2015 - Shortcuts for all Panels

Shift + Tab


Microsoft PowerPoint 2016 (Windows)
To next object
Navigation Operation

Shift + Tab


Microsoft PowerPoint 2016 (Windows)
To previous object
Navigation Operation

Tab


Microsoft Excel 2016 (Windows)
Move to the next/ previous field which can be edited
Select Cells - Data Forms

Tab / Shift + Tab


Plex (Windows)
Exit main menu
Graphics(Audio/Video) Control

H / Tab


Plex (MacOS)
Exit main menu
Graphics(Audio/Video) Control

H / Tab


Corel VideoStudio X9.5 (Windows)
Select Scrubber/Trim handle
Navigation/Direction Shortcuts

Tab


Access 2010 (Windows)
Go to next / go to previous text or hyperlink
The Rest - Help Window

Tab / Shift + Tab


Apple Keynote (MacOS)
Complete a cell entry and move the selection right
Chart data editor

Tab


FileMaker Pro (MacOS)
Switch between the relationships graph and the zoom controls
Database Management Shortcuts - Select and Arrange Table and Relationship

Tab


Apple Keynote (MacOS)
Complete a cell entry and move the selection left
Chart data editor

Shift + Tab


FileMaker Pro (Windows)
Move the selection from the relationships graph to the command buttons and proceed from left to right
Database Management Shortcuts - Relationships Graph

Tab


Apple Keynote (MacOS)
Select next cell
Tables

Tab


FileMaker Pro (Windows)
Move the selection through the command buttons from right to left and to the relationships graph from the Add Table command
Database Management Shortcuts - Relationships Graph

Shift + Tab


Apple Keynote (MacOS)
Selected Previous cell
Tables

Shift + Tab


Microsoft Excel 2016 (Windows)
Move to the next/ previous field which can be edited
Format Cells - Data Forms

Tab / Shift + Tab


Apple Keynote (MacOS)
Next object
Objects on Canvas

Tab


FileMaker Pro (MacOS)
Move to next object / move to previous object (field, button, or tab)
Navigation and Window Display

Tab / Shift + Tab


Apple Keynote (MacOS)
Previous object
Objects on Canvas

Shift + Tab


Adobe Illustrator CC (MacOS)
Show/hide panel
Panel Shortcuts

Tab


Adobe Illustrator CC (MacOS)
Show/hide panels except Tools and Control
Panel Shortcuts

Shift + Tab


Adobe Illustrator CC (Windows)
Show/hide panel
Panel Shortcuts

Tab


Adobe Illustrator CC (Windows)
Show/hide panels except Tools and Control
Panel Shortcuts

Shift + Tab


FileMaker Pro (Windows)
Go to next object / previous object (field, button, or tab)
Navigation and Window Display

Tab / Shift + Tab


Apple Numbers (MacOS)
Select next cell
Table Editing

Tab


Apple Numbers (MacOS)
Select previous cell
Table Editing

Shift + Tab


Microsoft Outlook 2016 (Windows)
Move to the next/previous field and control (in an open card)
View: Business Cards/Address cards

Tab / Shift + Tab


Nuke 10 (Windows)
Toggle 2D/3D
2D Viewer

Tab


Nuke 10 (MacOS)
Toggle 2D/3D
2D Viewer

Tab


Nuke 10 (Linux)
Toggle 2D/3D
2D Viewer

Tab


Anime Studio (Windows)
Select connected points
General Shortcuts

Tab


Nuke 10 (Windows)
Next control in properties
Panel Properties

Tab


Adobe Photoshop CC (Windows)
Show/Hide all panels
Manage Panels - Shortcuts for all Panels

Tab


Adobe Photoshop CC (Windows)
Show/Hide all panels except the toolbox and options bar
Manage Panels - Shortcuts for all Panels

Shift + Tab


Nuke 10 (Windows)
Move to previous control in properties
Panel Properties

Shift + Tab


Nuke 10 (MacOS)
Next control in properties
Panel Properties

Tab


Nuke 10 (Linux)
Next control in properties
Panel Properties

Tab


Microsoft Outlook 2016 (Windows)
Select the previous appointment
View: Calendar - Day/Week/Month

Shift + Tab


Nuke 10 (MacOS)
Move to previous control in properties
Panel Properties

Shift + Tab


Nuke 10 (Linux)
Move to previous control in properties
Panel Properties

Shift + Tab


Adobe Photoshop CC (MacOS)
Show/Hide all panels
Manage Panels - Shortcuts for all Panels

Tab


Adobe Photoshop CC (MacOS)
Show/Hide all panels except the toolbox and options bar
Manage Panels - Shortcuts for all Panels

Shift + Tab


Nuke 10 (Windows)
Increase Indentation
Script Editor

Tab


Finale (MacOS)
Move between primary/secondary handles
Smart Shape Tool

Tab


Nuke 10 (Windows)
Decrease Indentation
Script Editor

Shift + Tab


Nuke 10 (Linux)
Increase Indentation
Script Editor

Tab


Nuke 10 (MacOS)
Increase Indentation
Script Editor

Tab


Nuke 10 (Linux)
Decrease Indentation
Script Editor

Shift + Tab


Nuke 10 (MacOS)
Decrease Indentation
Script Editor

Shift + Tab


Finale (Windows)
Move between primary/secondary handles
Smart Shape Tool

Tab


Microsoft Excel 2016 (Windows)
Move to the next/ previous field which can be edited
Formulas - Data Forms

Tab / Shift + Tab


Nuke 10 (Windows)
Tab node search menu
Node Graph

Tab


Nuke 10 (Linux)
Tab node search menu
Node Graph

Tab


Nuke 10 (MacOS)
Tab node search menu
Node Graph

Tab


Zoho Sheet (Windows)
Move to next cell in row
Navigate

Tab


Dynamics CRM 2015 (Windows)
Move to the next option, option group, or field
Form Keyboard Shortcuts

Tab


Zoho Sheet (Windows)
Move to previous cell in row
Navigate

Shift + Tab


Dynamics CRM 2015 (Windows)
Move to the previous option, option group, or field
Form Keyboard Shortcuts

Shift + Tab


Zoho Sheet (Windows)
Navigate to the next object
Shortcuts for Objects (Images,charts,buttons etc)

Tab


Zoho Sheet (Windows)
Navigate to the previous object
Shortcuts for Objects (Images,charts,buttons etc)

Shift + Tab


Dynamics GP 2015 (Windows)
Move to next field
Window Navigation Shortcuts

Tab


Dynamics GP 2015 (Windows)
Move to previous field
Window Navigation Shortcuts

Shift + Tab


Anime Studio (MacOS)
Select connected points
General Shortcuts

Tab


Dynamics CRM 2015 (Windows)
Move to another field or command
Form Keyboard Shortcuts

Tab


Dynamics GP 2015 (Windows)
Move to next field
Tools Shortcuts

Tab


Dynamics GP 2015 (Windows)
Move to previous field
Tools Shortcuts

Shift + Tab


Dynamics NAV 2015 (Windows)
Move to the Previous field
Page View and Review

Shift + Tab


Dynamics SL 2015 (Windows)
Move to the next option, option group, or field
Navigation in forms

Tab


Dynamics SL 2015 (Windows)
Move to the previous option, option group, or field
Navigation in forms

Shift + Tab


Zoho Sheet (MacOS)
Move to next cell in row
Navigate

Tab


Zoho Sheet (MacOS)
Move to previous cell in row
Navigate

Shift + Tab


Microsoft Word 2016 (Windows)
To next object
Navigation Operation

Shift + Tab


Zoho Sheet (MacOS)
Navigate to the next object
Shortcuts for Objects (Images,charts,buttons etc)

Tab


Microsoft Word 2016 (Windows)
To previous object
Navigation Operation

Tab


Zoho Sheet (MacOS)
Navigate to the previous object
Shortcuts for Objects (Images,charts,buttons etc)

Shift + Tab


Dynamics SL 2015 (Windows)
Move to next field
Grid/View Shortcuts

Tab / Right Arrow


Dynamics SL 2015 (Windows)
Move to previous field
Grid/View Shortcuts

Shift + Tab / Left Arrow


iMovie (MacOS)
Move between text filed
Navigation

Tab


Apple Calendar (MacOS)
Select the next event.
Event Shortcuts

Tab


Apple Calendar (MacOS)
Select the previous event.
Event Shortcuts

Shift + Tab


Microsoft Projects 2016 (Windows)
Move forward through options
Working with dialog boxes

Tab


Microsoft Projects 2016 (Windows)
Move back through options
Working with dialog boxes

Shift + Tab


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

Tab


Dynamics SL 2015 (Windows)
Move to Save button when the focus is on the column header (if any unsaved data)
Grid/View Shortcuts

Tab


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

Shift + Tab


Dynamics SL 2015 (Windows)
Move to Refresh button when the focus is on the column header
Grid/View Shortcuts

Tab


Dynamics CRM 2015 (Windows)
Move to the next / move to previous option or option group
Dialog Box Shortcuts

Tab / Shift + Tab


Microsoft Excel 2016 (Windows)
Move to the next/ previous field which can be edited
Manage Workbooks - Data Forms

Tab / Shift + Tab


Autodesk Inventor 2017 (Windows)
PROMOTE / Removes a part from a subassembly and makes it an individual part in the parent assembly
Assembly

Shift + Tab


1Password (MacOS)
Starting from a selected category in the sidebar, the first Tab will change the focus to the search field, and the second Tab will change the focus to the item list.
Main App Shortcuts

Tab /Shift+ Tab


Microsoft Projects 2016 (Windows)
Move to the next cell.
Working with Table

Tab


Microsoft Projects 2016 (Windows)
Move to the preceding cell.
Working with Table

Shift + Tab


Dynamics AX 2015 (Windows)
Move the cursor to the next hidden text/ hyperlink,/ Expand All/ Collapse All at the top of a topic.
General Shortcuts

Tab