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