Microsoft Excel 2010 (Windows)

Data Forms

Move to the beginning / end of a field.

Home / End

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 Projects 2010 (Windows)
Jump first cell / jump to last cell in row
Navigate Gantt Chart and Select Tasks

Home / End


Civilization V (Windows)
Capital City View
General Hotkeys

Home / End


Adobe Reader 9 (Linux)
Jump to beginning/ jump to end of document
Navigation

Home / End


Eclipse Helios (Windows)
Jump to beginning / jump to end of indention. Press home twice to jump to beginning of line
Navigate in Editor

Home / End


Eclipse Helios (Windows)
Jump to beginning / jump to end of source
Navigate in Editor

Ctrl + Home / End


Microsoft OneNote 2010 (Windows)
Move to the beginning / end of the line.
Basic Editing and Formatting

home / end


Microsoft Windows 7 (Windows)
Jump to first / jump to last item
Managing 'Windows' in Windows 7 - Navigate File List and Navigation Pane

Home / End


Microsoft Windows 7 (Windows)
Jump to beginning / jump to end of item name
Managing 'Windows' in Windows 7 - Navigate File List and Navigation Pane

F2 , then home / End


Thunderbird (Windows)
Go to first message / go to last message
Navigate Messages

Home / End


Remember the Milk (Web Application)
Pan map in direction indicated (larger step than arrow keys)
Locations

page up / page down , home / end


Eclipse Helios (Windows)
Expand selection to end / to beginning of line
Select Text

Shift + End / Home


Adobe Photoshop CS5 (Windows)
Move to the beginning / to the end of the timeline
Photoshop CS5 Panels - Animation Panel (Timeline Mode, PS extended)

Home / End


Adobe Photoshop CS5 (MacOS)
Move to the beginning / to the end of the timeline
Photoshop CS5 Panels - Animation Panel (Timeline Mode, PS extended)

Home / End


Thunderbird (Linux)
Go to first message / go to last message
Navigate Messages

Home / End


Thunderbird (MacOS)
Go to first message / go to last message
Navigate Messages

Home / End


Android Emulator (Windows)
Home Button
Main Device Keys

Home


Adobe Photoshop CS4 (MacOS)
Go to first tile in Tile History (Pattern Maker only)
Shortcut Keys for working with Extract, Liquify, and Pattern Maker

Home


Adobe Photoshop CS4 (MacOS)
Go to last tile in Tile History (Pattern Maker only)
Shortcut Keys for working with Extract, Liquify, and Pattern Maker

End


Microsoft Word 2007 (Windows)
Go to beginning of document.
Working with documents: Full Screen Reading view

Home


Microsoft Word 2007 (Windows)
Go to end of document.
Working with documents: Full Screen Reading view

End


Firefox (Linux)
Jump to beginning / end of webpage
Inside Webpages

Home / End


Firefox (Windows)
Jump to beginning / end of webpage
Inside Webpages

Home / End


Google Mail (Windows)
Jump to beginning of page / end of page
Control Main Browser Window (General Browser Shortcuts)

End / Home


Firefox (MacOS)
Go to Bottom of Page
Navigation Controls

End


Firefox (MacOS)
Go to Top of Page
Navigation Controls

Home


Access 2010 (Windows)
Select first / select last command in menu
Manage Access Features - Menus

Home / End


Microsoft Outlook 2010 (Windows)
Go to beginning/end of current view
Messages in Main View - Navigate Calendar

Home / End


Access 2010 (Windows)
Move beginning / move to end of an entry
Manage Access Features - Text Boxes

Home / End


Inpage (Windows)
To go to the beginning of the line
To move cursor

Home


Inpage (Windows)
To go to the end of the line
To move cursor

End


Google Chrome (Windows)
Jump to beginning / to end of webpage
View Webpages

Home / End


Microsoft Windows 7 (Windows)
Jump to first / jump to last item
Windows Explorer - Navigate File List and Navigation Pane

Home / End


Microsoft Windows 7 (Windows)
Jump to beginning / jump to end of item name
Windows Explorer - Navigate File List and Navigation Pane

F2 , then home / End


Access 2010 (Windows)
Move cursor to the beginning / to the end of the field
Manage Access Features - Edit Text and Data

Home / End


VistaSwitcher (Windows)
Select a window from the list
Window List Selection

arrow keys or pageup / pagedown or home / End


Firefox (MacOS)
Back to Beginning
Media Control

Home


Firefox (MacOS)
Forward to End
Media Control

End


Google Chrome (Linux)
Jump to beginning / end of address bar
Address Bar

Home / End in address bar


Google Docs (Windows)
Jump to the end of a line / beginning of a line
Navigate Google Docs

End / Home


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

Home / End


Google Chrome (Linux)
Jump to beginning / to end of webpage
View Webpages

Home / End


Google Docs (MacOS)
Jump to the end of a line / beginning of a line
Navigate Google Docs

End / Home


Access 2010 (Windows)
Go to the first cell / go to last cell in row
Manage Access Features - Database Diagram

Home / End


Microsoft Word 2007 (Windows)
To the end of a line
Edit and move text and graphics: Move through your document

End


Microsoft Word 2007 (Windows)
To the beginning of a line
Edit and move text and graphics: Move through your document

Home


Mindjet Mindmanager 2012 (Windows)
Move topic top/bottom (remains on same level in hierarchy)
Most used - Move topics

Ctrl + Alt + Home / End


Adobe Photoshop CS5 (MacOS)
Go to first tile in Tile History
Photoshop CS5 Panels - Pattern Maker Only

Home


Adobe Photoshop CS5 (MacOS)
Go to last tile in Tile History
Photoshop CS5 Panels - Pattern Maker Only

End


Adobe Photoshop CS5 (Windows)
Go to first tile in Tile History
Photoshop CS5 Panels - Pattern Maker Only

Home


Adobe Photoshop CS5 (Windows)
Go to last tile in Tile History
Photoshop CS5 Panels - Pattern Maker Only

End


Microsoft Windows 7 (Windows)
Jump to first / jump to last item
Windows Admin - Navigate File List and Navigation Pane

Home / End


Microsoft Excel 2011 (MacOS)
Move to the beginning of the row
Moving and scrolling in a sheet or workbook

Home


Microsoft Windows 7 (Windows)
Jump to beginning / jump to end of item name
Windows Admin - Navigate File List and Navigation Pane

F2 , then home / End


Microsoft Outlook 2010 (Windows)
Go to beginning/end of current view
Messages in Compose View - Navigate Calendar

Home / End


Tekla Structures 14.0 (Windows)
Zoom original
General shortcuts

Home


Tekla Structures 14.0 (Windows)
Zoom previous
General shortcuts

End


Mindjet Mindmanager 2012 (Windows)
Move topic top/bottom (remains on same level in hierarchy)
Reorganizing - Move topics

Ctrl + Alt + Home / End


Sublime Text (Windows)
Move to beginning of line/ end of line
Navigation - Standard Navigation

Home / End


Open Office Impress (Linux)
Jump to first slide in the slide show.
Slide Shows

Home


Microsoft Excel 2011 (MacOS)
Move to the beginning of the line
Entering data on a sheet

Home


Open Office Impress (Linux)
Jump to the last slide in the slide show.
Slide Shows

End


Opera (Linux)
Go to top
Navigation

Home


Adobe Photoshop CS5 (MacOS)
Move to the beginning / to the end of the timeline
Extract and Pattern Maker (plug-in) - Animation Panel (Timeline Mode, PS extended)

Home / End


Opera (Linux)
Go to bottom
Navigation

End


Sublime Text (Windows)
Extend selection to beginning/ end of line
Navigation - Standard Selections

Shift + Home / End


Mindjet Mindmanager 2012 (Windows)
uppermost/bottom on the same level
Moving the blue box

Home / End


Sublime Text (Windows)
Extend selection to beginning of file/ end of file
Navigation - Standard Selections

Ctrl + Shift + Home / End


Mindjet Mindmanager 2012 (Windows)
central/lowest
Moving the blue box

Ctrl + Home / End


Adobe Photoshop CS5 (Windows)
Move to the beginning / to the end of the timeline
Extract and Pattern Maker (plug-in) - Animation Panel (Timeline Mode, PS extended)

Home / End


Adobe Photoshop CS4 (MacOS)
Move view to upper-left corner or lower right corner
Shortcut Keys for viewing images

Home / End


Sublime Text (Windows)
Move to beginning of line/ end of line
Selections - Standard Navigation

Home / End


Oracle SQL Developer 4 (Windows)
Jump to beginning of line/ end of line
Code Editor

Home / End


Microsoft Windows 8 (Windows)
Jump to first / jump to last item
Windows Explorer - Navigate File List and Navigation Pane

Home / End


Oracle SQL Developer 4 (Windows)
Expand selection to beginning/ end of line
Code Editor

Shift + Home / End


Microsoft Windows 8 (Windows)
Jump to beginning / jump to end of item name
Windows Explorer - Navigate File List and Navigation Pane

F2 , then Home / End


Oracle SQL Developer 4 (Windows)
Expand selection to beginning/ end of file
Code Editor

Ctrl + Shift + Home / End


Sublime Text (Windows)
Extend selection to beginning/ end of line
Selections - Standard Selections

Shift + Home / End


Sublime Text (Windows)
Extend selection to beginning of file/ end of file
Selections - Standard Selections

Ctrl + Shift + Home / End


Microsoft Windows 7 (Windows)
Jump to first / jump to last item
Ease of Access and Magnifier - Navigate File List and Navigation Pane

Home / End


Microsoft Windows 7 (Windows)
Jump to beginning / jump to end of item name
Ease of Access and Magnifier - Navigate File List and Navigation Pane

F2 , then home / End


Access 2010 (Windows)
Select first / select last command in menu
Working with Text and Data - Menus

Home / End


Evernote (Windows)
Go to the first note in list / last note in list
Note List

Home / End


Access 2010 (Windows)
Move beginning / move to end of an entry
Working with Text and Data - Text Boxes

Home / End


Microsoft Outlook 2010 (Windows)
Go to beginning/end of current view
Calendar Shortcuts - Navigate Calendar

Home / End


Access 2010 (Windows)
Move cursor to the beginning / to the end of the field
Working with Text and Data - Edit Text and Data

Home / End


Android Emulator (Linux)
Home Button
Main Device Keys

Home


InDesign CS5 (MacOS)
Move to start or end of line
Navigating Through and Editing Text

Home / End


Microsoft Windows 7 (Windows)
Select first / select last object on desktop
Navigating Desktop

Home / End


Microsoft Windows 8 (Windows)
Select first / select last object on desktop
Navigating Desktop

Home / End


InDesign CS5 (MacOS)
Select start or end of line
Navigating Through and Editing Text

Shift + Home /+ End


Photoshop Lightroom 4 (Windows)
Go to beginning/end of Grid view
Comparing photos in the Library module

Home / End


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

Home / End


Photoshop Lightroom 4 (MacOS)
Go to beginning/end of Grid view
Comparing photos in the Library module

Home / End


Adobe Photoshop CS5 (MacOS)
Go to first tile in Tile History
Extract and Pattern Maker (plug-in) - Pattern Maker Only

Home


Adobe Photoshop CS5 (MacOS)
Go to last tile in Tile History
Extract and Pattern Maker (plug-in) - Pattern Maker Only

End


Microsoft Windows 7 (Windows)
Move to the beginning / to the end of a topic
Windows Help

Home / End


Access 2010 (Windows)
Go to the first cell / go to last cell in row
Working with Text and Data - Database Diagram

Home / End


CATIA V5 (Windows)
Display the top of the graph
38 Shortcuts for CATIA V5 (Windows)

Home


CATIA V5 (Windows)
Display the bottom of the graph
38 Shortcuts for CATIA V5 (Windows)

End


Microsoft PowerPoint 2010 (Windows)
Move to the end of a line.
Basic Text Navigation and Formatting

End


Microsoft PowerPoint 2010 (Windows)
Move to the beginning of a line.
Basic Text Navigation and Formatting

Home


Adobe Photoshop CS5 (Windows)
Go to first tile in Tile History
Extract and Pattern Maker (plug-in) - Pattern Maker Only

Home


InDesign CS5 (MacOS)
Select first/last XML node
Working with XML

Home / End


Adobe Photoshop CS5 (Windows)
Go to last tile in Tile History
Extract and Pattern Maker (plug-in) - Pattern Maker Only

End


Adobe Photoshop CS4 (MacOS)
Move to the beginning of the timeline
Shortcut Keys for using the Animation panel in Timeline Mode (Photoshop Extended)

Home


Adobe Photoshop CS4 (MacOS)
Move to the end of the timeline
Shortcut Keys for using the Animation panel in Timeline Mode (Photoshop Extended)

End


Microsoft Outlook 2010 (Windows)
Select first / select last card in list
Business Card View

Home / End


Adobe Photoshop CS5 (MacOS)
Move view to upper-left corner or lower right corner
View images

Home / End


Adobe Photoshop CS5 (Windows)
Move view to upper-left corner or lower right corner
View Images

Home / End


HoneyView 5.03 (Windows)
first image / last image
Main Shortcuts

Home / End


Youtube Player (Windows)
Jump to the end of the video (if video not in playlist)
Navigate Video

End


Audacity 2 (Linux)
Skip to start
Frequently Used

Home


Audacity 2 (Linux)
Skip to end
Frequently Used

End


Audacity 2 (Linux)
Skip to start
Transport Menu

Home


Audacity 2 (Linux)
Skip to end
Transport Menu

End


Access 2010 (Windows)
Select first / select last command in menu
Working with Access Views - Menus

Home / End


Microsoft PowerPoint 2010 (Windows)
Move to the beginning of the entry.
Work with Dialog Boxes

Home


Microsoft PowerPoint 2010 (Windows)
Move to the end of the entry.
Work with Dialog Boxes

End


Access 2010 (Windows)
Move beginning / move to end of an entry
Working with Access Views - Text Boxes

Home / End


Microsoft Excel 2013 (Windows)
Move to the beginning of a row in a worksheet
Navigate Worksheets

Home


Microsoft Excel 2013 (Windows)
Inside a cell: Move to the beginning / to the end of a cell entry
Navigate Worksheets

Home / End


Microsoft Excel 2013 (Windows)
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
Navigate Worksheets

End


Microsoft Word 2013 (Windows)
Jump to the end of a line / beginning of a line
Navigate in Word Documents

End / Home


Microsoft Word 2013 (Windows)
Jump to end / to beginning of document
Navigate in Word Documents

Ctrl + End / Home


Microsoft Excel 2013 (Windows)
Inside a cell: Select from the insertion point to the beginning / to the end of the cell
Basic and Advanced Cell Selections

Shift + Home / End


Access 2010 (Windows)
Move cursor to the beginning / to the end of the field
Working with Access Views - Edit Text and Data

Home / End


Microsoft Word 2013 (Windows)
Extend selection to the end / to beginning of a line
Select Text, Move, and Delete Text

Shift + End / Home


Microsoft Word 2013 (Windows)
Extend selection to end / to beginning of document
Select Text, Move, and Delete Text

Ctrl + Shift + End / Home


Audacity 2 (Windows)
Skip to start
Transport Menu

Home


Audacity 2 (Windows)
Skip to end
Transport Menu

End


Virtual DJ (Windows)
skip_beat -1
All Shortcuts

End


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

Home / End


Virtual DJ (Windows)
skip_beat -16
All Shortcuts

Home


Adobe Acrobat Pro (Windows)
First page
Navigation - Navigating a PDF

Home / Shift + Ctrl + Page Up / Shift + Ctrl + Arrow Up


Adobe Acrobat Pro (Windows)
Last page
Navigation - Navigating a PDF

End / Shift + Ctrl + Page Down / Shift + Ctrl + Arrow Down


Presonus Studio One (Windows)
Start
Navigation

Home


Presonus Studio One (Windows)
End
Navigation

End


Access 2010 (Windows)
Go to the first cell / go to last cell in row
Working with Access Views - Database Diagram

Home / End


Adobe Flash Professional (Windows)
Go to First Scene
Timeline

Home


Adobe Flash Professional (Windows)
Go to Last Scene
Timeline

End


Axialis IconWorkshop (Windows)
Set floating selection to background
Draw Menu

End / Home


FL Studio (Windows)
Move the playback marker to the start of the Playlist
Playlist Action

Home


FileMaker Pro (Windows)
Move to beginning of the line / to end of the lien
Layout Mode Shortcuts - Text Navigation

Home / End


FileMaker Pro (Windows)
Select to beginning of text / to end of text
Layout Mode Shortcuts - Select Text

Ctrl + Shift + Home / End


Linux Mint (Linux)
Select the first or last item in the window
File Manager (Nemo) - Selecting Items

Home / End


Windows 10 Command Prompt (Windows)
Extend selection to the beginning/ to the end of screen buffer
Select Text (Expanded with Windows 10)

Ctrl + Shift + Home / End


Windows 10 Command Prompt (Windows)
Jump to beginning, jump to end of the line
Navigate Text

Home / End


Microsoft Windows 10 (Windows)
Jump to first / jump to last item
Navigate File List and Navigation Pane

Home / End


Microsoft Excel 2013 (Windows)
Select the first / last visible item in the list
Pivot Tables

Home / End


Adobe Acrobat Pro (Windows)
If in the body of the file list, move to the first or last row
PDF Portfolios

Home / End


Microsoft Excel 2013 (Windows)
Select the first item / last item in the AutoFilter list
Auto Filter

Home / End


Google Chrome (MacOS)
Jump to beginning / end of address bar
Address Bar

Home / End in address bar


Microsoft Excel 2013 (Windows)
Move to the beginning / end of a field
Data Forms

Home / End


Google Chrome (MacOS)
Jump to beginning / to end of webpage
View Webpages

Home / End


Access 2010 (Windows)
Select first / select last command in menu
The Rest - Menus

Home / End


Access 2010 (Windows)
Move beginning / move to end of an entry
The Rest - Text Boxes

Home / End


Camtasia 8 (Windows)
Select from current position to the end of the timeline / to beginnig of timeline
Editor Timeline Navigation

Ctrl + Shift + End / Home


GTDNext.com (Windows)
Go to end of line
Center Pane Shortcuts

End


Access 2010 (Windows)
Move cursor to the beginning / to the end of the field
The Rest - Edit Text and Data

Home / End


Microsoft OneNote 2016 (Windows)
Move to beginning/ end of the line
Basic Editing and Formatting

Home / End


Microsoft OneNote 2016 (Windows)
Move to top/ bottom of current page
Basic Editing and Formatting

Ctrl + Home / End


FileMaker Pro (Windows)
Move to beginning of the line / to end of the lien
Text Shortcuts - Text Navigation

Home / End


Microsoft OneNote 2016 (Windows)
Select to the beginning/ end of line
Basic Editing and Formatting

Shift + Home / End


FileMaker Pro (Windows)
Select to beginning of text / to end of text
Text Shortcuts - Select Text

Ctrl + Shift + Home / End


Google Mail (MacOS)
Jump to beginning of page / end of page
Control Main Browser Window (General Browser Shortcuts)

End / Home


Microsoft OneNote 2016 (Windows)
Go to first/ last page in the section
Manage Pages, Notebooks and Sections

Alt + Home / End


Skype for Business (Lync) 2016 (Windows)
Move top / move to bottom of list
Conversation Environment

Home / End


Skype for Business (Lync) 2016 (Windows)
With thumbnails in focus - Move to first / move to last slide thumbnail
PowerPoint Sharing

Home / End


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

Home / End


Adobe After Effects CC (Windows)
Go to beginning / go to end of Composition, Layer, or Footage item (or Ctrl+Alt+Left Arrow/Right Arrow)
Time Navigation

Home / End


Adobe After Effects CC (MacOS)
Go to beginning or end of work area
Time Navigation

Shift + Home / End


Adobe After Effects CC (MacOS)
Go to beginning / go to end of Composition, Layer, or footage item (or Command+Option+Left Arrow/Right Arrow)
Time Navigation

Home / End


Access 2010 (Windows)
Go to the first cell / go to last cell in row
The Rest - Database Diagram

Home / End


Google Slides (Windows)
Move to 1st slide / Move to last slide
Working Point Navigation Action

Home / End


Microsoft PowerPoint 2016 (Windows)
End of line
Navigation Operation

End


Microsoft PowerPoint 2016 (Windows)
Starting of line
Navigation Operation

Home


Photoshop Lightroom CC (MacOS)
Go to beginning/ end of Grid view
Comparing Photos in the Library Module

Home / End


Photoshop Lightroom CC (Windows)
Go to beginning/ end of Grid view
Comparing Photos in the Library Module

Home / End


Access 2016 (Windows)
Move to beginning
Windows/Content Switching/Navigation

Home


Access 2016 (Windows)
Move to End
Windows/Content Switching/Navigation

End


Onshape (Windows)
First/ last sheet
Drawings

Home / End


Microsoft Excel 2016 (Windows)
Move to the beginning/ end of a field
Select Cells - Data Forms

Home / End


Onshape (MacOS)
First/ last sheet
Drawings

Home / End


Corel VideoStudio X9.5 (Windows)
Go to starting segment
Navigation/Direction Shortcuts

Home


Corel VideoStudio X9.5 (Windows)
Go to ending segment
Navigation/Direction Shortcuts

End


Microsoft Visio 2016 (Windows)
Move to the beginning
Window/Navigation Shortcut

Home


Microsoft Visio 2016 (Windows)
Move to the end of entry
Window/Navigation Shortcut

End


Adobe Audition CC (Windows)
Set time indicator to beginning
Audio General Operations

Home


Adobe Audition CC (Windows)
Set time indicator to end
Audio General Operations

End


Adobe Audition CC (MacOS)
Set time indicator to beginning
Audio General Operations

Home


Adobe Audition CC (MacOS)
Set time indicator to end
Audio General Operations

End


FileMaker Pro (Windows)
Move to beginning of the line / to end of the lien
Database Management Shortcuts - Text Navigation

Home / End


Adobe Premiere CC (Windows)
Go to sequence clip start
Clipping Shortcuts

Home


Adobe Premiere CC (Windows)
Go to sequence clip end
Clipping Shortcuts

End


FileMaker Pro (Windows)
Select to beginning of text / to end of text
Database Management Shortcuts - Select Text

Ctrl + Shift + Home / End


Adobe Premiere CC (MacOS)
Go to sequence clip start
Clipping Shortcuts

Home


Adobe Premiere CC (MacOS)
Go to sequence clip end
Clipping Shortcuts

End


Apple Keynote (MacOS)
Move to the begining
Chart data editor

Home


Apple Keynote (MacOS)
Move to the end
Chart data editor

End


Apple Numbers (MacOS)
Go to beginning of spreadsheet
Navigation Shortcuts

Home


Apple Numbers (MacOS)
Go to end of spreadsheet
Navigation Shortcuts

End


Microsoft PowerPoint 2016 (Windows)
End Slideshow
Slide Operations(Presentation time)

Esc / End


Microsoft Excel 2016 (Windows)
Move to the beginning/ end of a field
Format Cells - Data Forms

Home / End


Microsoft Outlook 2016 (Windows)
Select the first/last group
Groups

Home / End


FileMaker Pro (MacOS)
Scroll to the beginning / end of the document
Navigation and Window Display

Home / End


Corel Painter 2017 (MacOS)
First frame of stack
Navigation Shortcuts

Home


Corel Painter 2017 (MacOS)
Last frame of stack
Navigation Shortcuts

End


Corel Painter 2017 (Windows)
First frame of stack
Navigation Shortcuts

Home


Corel Painter 2017 (Windows)
Last frame of stack
Navigation Shortcuts

End


Microsoft Outlook 2016 (Windows)
Select the first/last card in the list
View: Business Cards/Address cards

Home / End


Apple Keynote (MacOS)
Scroll to top of canvas
Text Editing

Home


Apple Keynote (MacOS)
Scroll to end of canvas
Text Editing

End


Nuke 10 (Windows)
Go to last frame
2D Viewer

End


Nuke 10 (MacOS)
Go to last frame
2D Viewer

End


Adobe After Effects CC (Windows)
Select text from insertion point to beginning / end of line
Text

Shift + Home / End


Apple Keynote (MacOS)
Go to first slide
Slideshow

Home


Nuke 10 (Linux)
Go to last frame
2D Viewer

End


Adobe After Effects CC (Windows)
Move cursor to beginning / end of line
Text

Home / End


Apple Keynote (MacOS)
Go to last slide
Slideshow

End


Microsoft Outlook 2016 (Windows)
Move to the beginning/end of a line (when a field in a card is selected)
View: Business Cards/Address cards

Home / End


Adobe After Effects CC (Windows)
Select text from cursor to beginning / end of text Frame
Text

Ctrl + Shift + Home / End


Microsoft Outlook 2016 (Windows)
Select the first/last item on the timeline (if items are not grouped) or the first item in the group
View: Timeline (Tasks) - When an item is selected

Home / End


Anime Studio (Windows)
Reset view
General Shortcuts

Home


Adobe After Effects CC (MacOS)
Select text from insertion point to beginning / end of line
Text

Shift +
Home / End


Adobe After Effects CC (MacOS)
Move cursor to beginning / end of line
Text

Home / End


Adobe After Effects CC (MacOS)
Select text from cursor to beginning / end of text Frame
Text

Command + Shift +
Home / End


Microsoft Outlook 2016 (Windows)
Select the first/last group on the timeline
View: Timeline (Tasks) - When a group is selected

Home / End


Finale (MacOS)
Left one screen
Navigation Shortcuts

Home


Finale (MacOS)
Right One screen
Navigation Shortcuts

End


Microsoft Outlook 2016 (Windows)
Select the time that begins your work day
View: Calendar - Day View

Home


Microsoft Outlook 2016 (Windows)
Select the time that ends your work day
View: Calendar - Day View

End


Finale (Windows)
Left one screen
Navigation Shortcuts

Home


Finale (Windows)
Right One screen
Navigation Shortcuts

End


Microsoft Outlook 2016 (Windows)
Go to the start/end of work hours for the selected day
View: Calendar - Week View

Home / End


Microsoft Outlook 2016 (Windows)
Go to the first day of the week
View: Calendar - Month View

Home


Microsoft Excel 2016 (Windows)
Move to the beginning/ end of a field
Formulas - Data Forms

Home / End


Anime Studio (Windows)
Zoom(to show all)
Graph Shortcuts

End


Apple Motion (MacOS)
Go to the start of a project
General Interface

Home


Apple Motion (MacOS)
Go to the end of a project
General Interface

End


CINEMA 4D (Windows)
Jump Home
Structure Manager

Home


Dynamics NAV 2015 (Windows)
Moving to the First field on a line
Normal Shortcuts

Home


Zoho Writer (Windows)
Go to Beginning of line from the current cursor position
Navigation keys

Home


Zoho Writer (Windows)
Go to End of line from the current cursor position
Navigation keys

End


Dynamics NAV 2015 (Windows)
Move to the Last Field on a line
Normal Shortcuts

End


CINEMA 4D (Windows)
Jump End
Structure Manager

End


Anime Studio (MacOS)
Reset view
General Shortcuts

Home


Microsoft Word 2016 (Windows)
End of line
Navigation Operation

End


Apple Photos (Windows)
Move to the top of the photo library
Organize

Home


Microsoft Word 2016 (Windows)
Starting of line
Navigation Operation

Home


Apple Photos (Windows)
Move to the bottom of the photo library
Organize

End


Apple Motion (MacOS)
Go to the start of a project
Mark Menu

Home


Apple Motion (MacOS)
Go to the end of a project
Mark Menu

End


Windows Movie Maker (Windows)
Go to the last item
Navigation

End


iMovie (MacOS)
Move playhead to beginning of movie
Navigation

Home


Windows Movie Maker (Windows)
Go to the first item
Navigation

Home


Anime Studio (MacOS)
Zoom(to show all)
Graph Shortcuts

End


GIMP (Linux)
Select Top/Bottom Layer
Layer

Home / End


Adobe Photoshop CC (Windows)
Scroll to to upper-left/ lower-right corner
Manage Views

Home / End


Adobe Photoshop CC (MacOS)
Scroll to to upper-left/ lower-right corner
Manage Views

Home / End


Microsoft Excel 2016 (Windows)
Move to the beginning/ end of a field
Manage Workbooks - Data Forms

Home / End


Microsoft Projects 2016 (Windows)
Move to the beginning of the entry.
Navigation Shortcuts

Home


Microsoft Projects 2016 (Windows)
Move to the end of the entry.
Navigation Shortcuts

End


GIMP (MacOS)
Select Top/Bottom Layer
Layer Shortcuts

Home / End


Ace Projects (Windows)
Go to line end
Navigation Shortcuts

Alt + Right Arrow / End


GIMP (Windows)
Select Top/Bottom Layer
Layer Shortcuts

Home / End


Microsoft Projects 2016 (Windows)
Move to the end of a line.
Moving around cells/text

End


Microsoft Projects 2016 (Windows)
Move to the beginning of a line.
Moving around cells/text

Home


Autodesk Inventor 2017 (Windows)
Zoom selected
View

End


Autodesk Inventor 2017 (Windows)
Zoom all
View

Home


Adobe Acrobat Pro (MacOS)
First page
Navigation - Navigating a PDF

Home / Shift + Command + Page Up / Shift + Command + Up Arrow


Adobe Acrobat Pro (MacOS)
Last page
Navigation - Navigating a PDF

End / Shift + Command + Page Down / Shift + Command + Down Arrow


AutoCad Architecture 2017 (Windows)
Moves the cursor to the start of the current line
Text Editing

Home


AutoCad Architecture 2017 (Windows)
Moves the cursor to the end of the current line
Text Editing

End


Apple Photos (MacOS)
Move to the top of the photo library
Organize

Home


Apple Photos (MacOS)
Move to the bottom of the photo library
Organize

End


Adobe Flash Professional (MacOS)
Go to First Scene
Timeline

Home


Adobe Flash Professional (MacOS)
Go to Last Scene
Timeline

End


Zoho Writer (MacOS)
Go to Beginning of line from the current cursor position
Navigation Shortcuts

Home


Microsoft Projects 2016 (Windows)
Move to the beginning of the line.
Working with OfficeArt Objects

Home


Apple Pages (MacOS)
Move to the beginning of the row
Editing chart data

Home


Zoho Writer (MacOS)
Go to End of line from the current cursor position
Navigation Shortcuts

End


Microsoft Projects 2016 (Windows)
Move to the end of the line.
Working with OfficeArt Objects

End


Apple Pages (MacOS)
Move to the last filled cell to the right in the current row
Editing chart data

End


Autodesk 3ds Max 2017 (Windows)
Go to start frame
Key and Time controls

Home


Autodesk 3ds Max 2017 (Windows)
Go to end frame
Key and Time controls

End


Microsoft Excel 2016 (Windows)
Move to the beginning/ end of a field
Excel Auto Tables and Data Forms - Data Forms

Home / End


Microsoft Excel 2016 (Windows)
Move to the beginning of row
Navigate Worksheets

Home


Final Cut Pro (MacOS)
To beginning of media
Navigation

Home


Final Cut Pro (MacOS)
To end of media
Navigation

End


Microsoft Excel 2016 (Windows)
Jump to beginning/ end of cell
Edit Cell Content

Home / End


Microsoft Excel 2016 (Windows)
Select from the insertion point to beginning/ end of cell
Edit Cell Content

Shift + Home / End


Adobe Acrobat Pro (MacOS)
If in the body of the file list, move to the first or last row
PDF Portfolios

Home / End


Todoist (Web Application)
Navigate to default Page
Task Add Shortcuts(Windows 10 Only)

Home


Slack (Windows)
Scroll Up
Navigation Controls

Home / PgUp


Slack (Windows)
Scroll Down
Navigation Controls

End / PgDn


Microsoft Excel 2016 (Windows)
Select the first item/ last item in the AutoFilter list
Auto Filter

Home / End


Windows 10 File Explorer (Windows)
Go to first itme/ last item
Left Navigation Pane Shortctus

Home / End


Bash (Linux)
Go to Beginning of Line
Navigation

Home / Ctrl + A


Bash (Linux)
Go to End of Line
Navigation

Ctrl + E / End


Windows 10 File Explorer (Windows)
Go to first itme/ last item
Folder Content (Main Pane) - Navigate Files/ Folders

Home / End


Cloud9 (MacOS)
Goto Start/ End
Goto

Command + Home / End


Cloud9 (Windows)
Goto Start/End
Navigate

Ctrl + Home / End


Zimbra Collaboration Suite 8 (Windows)
Select First Item
Lists

Home


Zimbra Collaboration Suite 8 (Windows)
Select Last Item
Lists

End


Cloud9 (Windows)
Select To End/ Start
Selections

Ctrl + Shift + End / Home


Daz 3D Bryce 7 (Windows)
Top of List
Advance Motion Lab

Home


Daz 3D Bryce 7 (MacOS)
Top of List
Advance Motion Lab

Home


Daz 3D Bryce 7 (Windows)
Bottom of List
Advance Motion Lab

End


Daz 3D Bryce 7 (MacOS)
Bottom of List
Advance Motion Lab

End


jEdit (Windows)
1st Non-space Character
Moving the Caret

Home


jEdit (Windows)
Last Non-space Character
Moving the Caret

End


Adobe Bridge CC (MacOS)
Move to First Item
35 Shortcuts for Adobe Bridge CC (MacOS)

Home


Adobe Bridge CC (MacOS)
Move to Last Item
35 Shortcuts for Adobe Bridge CC (MacOS)

End


Adobe Bridge CC (Windows)
Move to First Item
35 Shortcuts for Adobe Bridge CC (Windows)

Home


Adobe Bridge CC (Windows)
Move to Last Item
35 Shortcuts for Adobe Bridge CC (Windows)

End


Blender 3D (Windows)
All Objects are Displayed in Center
Object Mode

Home


Microsoft Excel 2016 (MacOS)
Move to the beginning of the row
Move and scroll in a sheet or workbook

Home


Microsoft Excel 2016 (MacOS)
Move to the beginning of the line
Enter data on a sheet

Home


Opera (Windows)
Go to top
Navigation

Home


Opera (Windows)
Go to bottom
Navigation

End


Corel Ventura 10 (Windows)
Move Cursot ro Beginning/End of Line
Cursor Movement

Home / End


Opera (MacOS)
Go to top
Navigation

Home


Opera (MacOS)
Go to bottom
Navigation

End


Pinnacle Studio Ultimate 20 (Windows)
Go to Start
Navigation

E / Home


Pinnacle Studio Ultimate 20 (Windows)
Go to End
Navigation

R / End


ACDSee (Windows)
Display Last Selected Item
View Mode

End


Steinberg Cubase 9 (Windows)
End
Navigate

End


Steinberg Cubase 9 (MacOS)
End
Navigate

End


Steinberg Cubase 9 (Windows)
Home
Navigate

Home


Steinberg Cubase 9 (MacOS)
Home
Navigate

Home


InCopy CC (Windows)
Go to beginning/end of line
Navigation Shortcuts

Home / End


InCopy CC (MacOS)
Go to beginning/end of line
Navigation Shortcuts

Home / End


InCopy CC (Windows)
Go to beginning/end of story
Navigation Shortcuts

Ctrl + Home / End


InCopy CC (MacOS)
Go to beginning/end of story
Navigation Shortcuts

Command + Home / End


InCopy CC (Windows)
Select to the start/end of the line
Navigation Shortcuts

Shift + Home / End


HTML-Kit (Windows)
Go to End of Line
87 Shortcuts for HTML-Kit (Windows)

End


InCopy CC (MacOS)
Select to the start/end of the line
Navigation Shortcuts

Shift + Home / End


InCopy CC (Windows)
Select to beginning/end of story
Navigation Shortcuts

Ctrl + Shift + Home / End


Corel Ventura 10 (Windows)
Select Start Node of Curve
Node Editing

Home


Corel Ventura 10 (Windows)
Select End Node of Curve
Node Editing

End


InCopy CC (MacOS)
Select to beginning/end of story
Navigation Shortcuts

Command + Shift + Home / End


Microsoft Word 2016 (MacOS)
Go to the beginning of a comment
Review a document

Home


Corel Draw X8 (Windows)
Cursor start of a line
Cursor Moves Using Text Tool

Home


Corel Draw X8 (Windows)
Cursor to end of line
Cursor Moves Using Text Tool

End


Edius (Windows)
Move to end
General

END


Edius (Windows)
Move to start
General

HOME


MAGIX Movie Edit Pro (Windows)
Playback marker to end
PlayBack Functions

End


Final Fantasy XV (Windows)
Toggle between 1st/3rd person mode
Camera

Home


Final Fantasy XV (Windows)
Return camera to saved position
Camera

End


Kingsoft Spreadsheets 2016 (Windows)
Moves to Cell in Upper Left Corner of Window
Navigation Shortcuts

Home


InCopy CC (MacOS)
Move to first/last cell in row
Tables

Option + Home / End