60+ Microsoft excel Shortcuts to improve your spreadsheet
knowledge
Navigation
|
CTRL + TAB
|
To toggle between open workbooks,
hold CTRL, then press tab
|
|
CTRL + Pg Up
|
Switches to the preceding sheet in
the same workbook
|
|
CTRL + Pg Dn
|
Switches to the next sheet in the
same workbook
|
|
CTRL + F9
|
Minimize Workbook
|
|
CTRL + F10
|
Maximize Workbook
|
|
CTRL + End
|
Moves to the last cell in a
working area
|
|
CTRL + Home
|
Moves to the first cell of a
worksheet
|
|
CTRL + ←
|
Moves to leftmost cell of a data
block
|
|
CTRL + →
|
Moves to rightmost cell of data
block
|
|
CTRL + ↓
|
Moves to top-most cell of data
block
|
|
CTRL + ↑
|
Moves to bottom-most cell of data
block
|
|
Tab
|
Moves between selected cells in a
range
|
|
Home
|
Moves to beginning of the current
row
|
|
Pg Up
|
Scrolls the window up one screen
|
|
Pg Dn
|
Scrolls the window down one screen
|
|
ALT + Pg Dn
|
Scrolls the window right one
screen
|
|
ALT + Pg Up
|
Scrolls the window left one screen
|
|
End, Enter
|
Moves to the last cell in the the current row that contains data
|
|
F5 or CTRL + G
|
Go to a specific cell or range
|
|
CTRL + F
|
Find a specified cell value
|
|
CTRL + F1
|
Toggle Task Pane
|
Selection
|
CTRL + SHIFT + ←
|
Select from current cell to
leftmost cell of a data block
|
|
CTRL + SHIFT + →
|
Select from current cell to
rightmost cell of data block
|
|
CTRL + SHIFT + ↓
|
Select from current
cell to top-most cell of data block
|
|
CTRL + SHIFT + ↑
|
Select from current cell to bottom-most
cell of data block
|
|
CTRL + A
|
Selects entire worksheet or data
set (when not entering or editing a formula)
|
|
CTRL + SHIFT + *
|
Selects entire block of data
|
|
CTRL + spacebar
|
Selects entire column
|
|
SHIFT + spacebar
|
Selects entire row
|
|
CTRL + D
|
Fills selected range of cells
downward
|
|
CTRL + R
|
Fills selected range of cells to
the right
|
|
ALT + Enter
|
New Line within a cell (carriage
return)
|
|
CTRL + 1
|
Display the Format Cells dialog
box
|
|
CTRL + '
|
View Formulas instead of Values in
all Cells.
Repeat to get back to Values view |
|
CTRL + SHIFT + ~
|
Applies gen. number style
|
|
CTRL + SHIFT + $
|
Currency number style
|
|
CTRL + SHIFT + %
|
Percent number style
|
|
CTRL + SHIFT + ^
|
Exponential number style
|
|
CTRL + SHIFT + #
|
Date number style
|
|
CTRL + SHIFT + @
|
Time number style
|
|
CTRL + SHIFT + !
|
Comma number style
|
|
CTRL + SHIFT + &
|
Adds outline border
|
|
CTRL + SHIFT + _
|
Removes outline border
|
|
F11
|
to create a chart as a new
worksheet from highlighted cells
|
|
'
|
Place ' before anything you don't
want excel auto formatting for you
|
|
DoubleClick Format Painter Button
|
Copy text format and Paint the
format on multiple objects
|
Editing
|
CTRL + O
|
Open existing workbook
|
|
CTRL + N
|
Open new workbook
|
|
SHIFT + F11
|
Insert Worksheet
|
|
Double-Click or F2
|
Edit contents of a cell
|
|
SHIFT + F2
|
Edit cell comment
|
|
Auto fill
|
Double-Click on the lower right
corner of a cell
|
|
CTRL + SHIFT + "+"
|
Insert Row
|
|
CTRL + SHIFT + "-"
|
Delete Row
|
|
CTRL + "-"
|
Delete Cell
|
|
CTRL + ;
|
Enters current date
|
|
CTRL + SHIFT + :
|
Enters current time
|
|
CTRL + H
|
Find and Replace text
|
|
CTRL + C
|
Copies text to the Clipboard
|
|
CTRL + X
|
Cuts text to Clipboard
|
|
CTRL + V
|
Paste text to the Clipboard
|
|
CTRL + Z
|
Undoes the most recent command
|
|
CTRL + Y or F4
|
Redoes an undone command
|
|
CTRL + K
|
Insert Hyperlink
|
|
F9
|
Calculate all sheets in all open
workbooks
|
|
SHIFT + F3
|
Insert a function into a formula
|
|
SHIFT + F9
|
Calculate the active worksheet
|
|
CTRL + select worksheets
|
Modify multiple sheets at once
|
|
ALT+S+C+A
|
Unhide search
|
0 Comments
Please do not spam