EXCEL SHORTCUSTS
| Select the whole column
Selection
CTRL + SPACE |
| Select the whole row
Selection
SHIFT + SPACE |
| Select table
Selection
SHIFT + CTRL + SPACE bar |
| Save
Selection
CTRL + s |
| Select visible cells only
Selection
ALT + ; |
| Select entire region
Selection
CTRL + A |
| Select range from start cell to far left
Selection
SHIFT + Home |
| Select range from start cell to end in direction of arrow
Selection
SHIFT + End + arrow |
| Select a continuous range of data (e.g. pivot), no matter where your cursor is.
Selection
CTRL + * |
| Select blank cells
Selection
F5 + ALT + S + K + ENTER |
| Select all cells with comments
Selection
CTRL + SHIFT + O |
| Select all cells that are directly or indirectly referred to by formulas in the selection
Selection
CTRL + SHIFT + { |
| Select all cells with formulas that refer directly or indirectly to the active cell
Selection
CTRL + SHIFT + } |
| Selects all the way to a1 from cursor position
Selection
CTRL + SHIFT + HOME |
| Select cells in the direction of arrow
Selection
CTRL + SHIFT + Arrow |
| Previous sheet
Navigation
CTRL + Page Up |
| Next sheet
Navigation
CTRL + Page Down |
| Launch GO TO Dialog (from here you can select special or jump to a cell or range)
Navigation
F5 |
| Go to top left (will go to top left of freezed pane if set)
Navigation
CTRL + Home |
| Go to last non-blank cell
Navigation
CTRL + end |
| Go to previous sheet
Navigation
CTRL + PgUp |
| Go to next sheet
Navigation
CTRL + PgDn |
| Print
Navigation
CTRL + p |
| Toggle between workbooks in a given session of excel.
Navigation
CTRL + TAB |
| Change the type of cell reference from relative to absolute or semi-absolute
Formulas
F4 |
| Repeat whatever you did last
Formulas
F4 |
| Debug portions of a formula (select and press)
Formulas
F9 |
| Sum range
Formulas
ALT + = |
| Enter array formula
Formulas
CTRL + SHIFT + Enter |
| Select array formula range
Formulas
CTRL + / |
| Display range names (can be used when typing formulas)
Formulas
F3 |
| Evaluate formulas. (its easy to remember when working with some “tuf” formulas!)
Formulas
ALT + TUF |
| Copy a formula from above cell and edit
Formulas
CTRL + ' |
| Display the formula palette after you type a valid function name in a formula
Formulas
CTRL + A (while writing a formula) |
| Alternate between displaying cell values and displaying cell formulas
Formulas
CTRL + ` (Single Left Quotation Mark) |
| Calculate formulas
Formulas
F9 |
| Select all precedent cells
Formulas
CTRL + [ |
| Select all dependent cells
Formulas
CTRL + ] |
| Format Selection (cells, objects, charts)
Formatting
CTRL + 1 |
| Bold a cell’s content
Formatting
CTRL + B |
| Format Painter – Paste formats from selection
Formatting
ALT + EST |
| Format as number with 2 dp
Formatting
CTRL + SHIFT + 1 |
| Format as local currency
Formatting
CTRL + SHIFT + 4 |
| Format as percentage with 0 dp
Formatting
CTRL + SHIFT + 5 |
| Hide row
Formatting
CTRL + 9 |
| Hide column
Formatting
CTRL + 0 |
| Unhide row
Formatting
CTRL + SHIFT + 9 |
| Unhide column
Formatting
CTRL + SHIFT + 0 |
| Display the style command format menu
Formatting
ALT + ' |
| Sets/removes strikeout in current cell
Formatting
CTRL + 5 |
| Show/hide the top bar when you have a group
Formatting
Crtl + 8 |
| Single border around selected cells
Formatting
CTRL + SHIFT + 7 |
| Sort
Formatting
ALT + DS |
| Insert hyperlink
Formatting
CTRL + K |
| Freeze panes
Formatting
ALT + WFF |
| Remove grid lines or (alt+t)ov(alt+g)[enter]
Formatting
ALT + WVG (2007+) |
| To wrap lines
Formatting
ALT + HW (2007+) |
| Save as
Excel Options
F12 |
| Collapse the ribbon (press again to expand)
Excel Options
CTRL + F1 |
| Opens print preview
Excel Options
CTRL + F2 |
| Maximize the current window
Excel Options
ALT + SPACE X |
| Activate next window
Excel Options
ALT + TAB |
| Activate previous window
Excel Options
ALT + SHIFT + TAB |
| Close an excel workbook
Excel Options
crtl + F4 |
| Split screens
Excel Options
ALT + W + S |
| Create a pivot table in new sheet (of course after selecting the range)
Everything Else
ALT + DPF |
| Create a pivot table in the same sheet.
Everything Else
ALT + DPN |
| Show visual basic editor
Everything Else
ALT + F11 |
| Macro dialog
Everything Else
ALT + F8 |
| Apply/remove filter
Everything Else
ALT + DFF |
| Keep filter on columns, but show all rows
Everything Else
ALT + DFS |
| Insert pivot table
Everything Else
ALT + NVT |
| Turn filter on or off
Everything Else
CTRL + SHIFT + L |
| Paste values only
Editing
ALT + ESV |
| Edit a cell, place cursor at the end
Editing
F2 |
| Show in-cell drop down with previously entered values
Editing
ALT + Down arrow |
| Fills down value from cell above
Editing
CTRL + D |
| Add a comment or Edit comment
Editing
SHIFT + F2 |
| Insert new sheet
Editing
SHIFT + F11 |
| Insert row
Editing
CTRL + + |
| Delete row
Editing
CTRL + - |
| Copy
Editing
CTRL + C |
| Paste
Editing
CTRL + V |
| Cut
Editing
CTRL + X |
| Undo
Editing
CTRL + Z |
| Get a line break inside the cell
Editing
ALT + Enter (while editing the cell) |
| Clear all contents
Editing
ALT + EAA |
| Copy
Editing
CTRL + insert |
| Paste
Editing
SHIFT + Insert |
| Make chart/pivot chart
Editing
F11 |
| Edit a cell in Apple Macs
Editing
CTRL + U |
| Copy the value from the cell above the active cell into the cell or the formula bar
Editing
CTRL + SHIFT + " |
| Copies whatever is in the cell to the left of it.
Editing
CTRL + R |
| Delete box (cell, row, column)
Editing
ALT + ED |
| Insert box (cell, row, column)
Editing
ALT + IE |
| Enter current date
Auto Complete
CTRL + ; |
| Enter current time
Auto Complete
CTRL + : |
