Excel ShortCuts

Shift+Enter Move up through a selection
Ctrl+↑ Jump to the top of a column
Ctrl+↓ Jump to the bottom of a column
Ctrl+. Jump to the corner of a selection (Note: Rotate to each corner by repeating this keystroke)
Ctrl+w Close the active workbook window
Ctrl+Shift+F6 Switch to previous workbook window
Ctrl+Tab Switch to the next open worksheet
Ctrl+Shift+Tab Switch to the previous open worksheet (Mac)
F11 Start a new chart sheet
Shift+F11 Insert a new sheet
Ctrl+y Repeat the last action
Ctrl+d  Fill selected cell with the content in the cell above selected cell
Ctrl+r Fill selected cell with the content in the cell to the left of selected cell

Ctrl+F Find and replace values
Ctrl+Shift+% Show all values as percentages
Ctrl+Shift+$ Show all values as currency (Note: Replace $ with your own country’s currency key)
Ctrl+Shift+~ Show all values in general number format
Ctrl+Shift+& Apply an outline border to selected cells
Ctrl+2 Apply or remove bold formatting to selected cells
Ctrl+3 Apply or remove italic formatting to selected cells
Ctrl+9 Hide selected rows
Ctrl+Shift+( Unhide selected rows
Ctrl+0 Hide selected columns
Ctrl+Shift+) Unhide selected columns
Ctrl+; Insert current date
Ctrl+Shift+: Insert current time
Ctrl+k Insert a hyperlink

Selecting Rows & Columns
Shift+↑ Shift+↓ Expand the selection by one cell either upward (↑) or downward (↓)
Ctrl+Shift+ArrowKey Expand the selection to the last non-empty cell
Ctrl+[spacebar] Select entire column
Shift+[spacebar] Select entire row
Ctrl+a Select entire sheet
Alt+; Select only the visible cells in the current selection

= Start a formula
Alt+=  Insert AutoSum formula
F2 Edit Active Cell
Ctrl+a Display the Formula Builder after you type a valid function name in a formula

F7 Open spelling & grammar check
Shift+F2 Insert a comment

Last Edit: 11/12/17 by Juan Osborne