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