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