Windows Excel Keyboard Shortcuts Cheat Sheet

ADVERTISEMENT

Swift Tips for
Excel Shortcuts
`
b
Ctrl
Ctrl
Display cell values/formulas
Bold
~
c
Ctrl
Ctrl
General format
Copy
1
d
Ctrl
Ctrl
Display Format Cells dialog box
Fill down
e
!
Ctrl
Ctrl
Number format
Flash Fill
f
2
Ctrl
Ctrl
Bold
Find
g
@
Ctrl
Ctrl
Time format
Display Go To dialog box
h
3
Ctrl
Italics
Ctrl
Replace
i
#
Ctrl
Date format
Ctrl
Italics
k
4
Ctrl
Ctrl
Underline
Display Insert Hyperlink dialog box
l
$
Ctrl
Ctrl
Currency to two decimal places
Display Create Table dialog box
n
5
Ctrl
Ctrl
Strikethrough
Create new workbook
o
%
Ctrl
Ctrl
Percentage
Display Open dialog box
O
6
Ctrl
Hide or display objects
Ctrl
Select all cells with comments
p
^
Ctrl
Exponentiation to two decimal places
Ctrl
Display print options
P
&
Ctrl
Outline border
Ctrl
Display Font tab of Format Cells box
q
8
Ctrl
Hide or display outline symbols
Ctrl
Quick Analysis
r
*
Ctrl
Ctrl
Select current region
Fill right
s
9
Ctrl
Ctrl
Hide selected rows
Save
t
(
Ctrl
Ctrl
Unhide hidden rows
Display Create Table dialog box
u
0
Ctrl
Hide selected columns
Ctrl
Underline
U
-
Ctrl
Displays the Delete dialog box
Ctrl
Expand or collapse Formula Bar
v
_
Ctrl
Removes border
Ctrl
Paste
+
v
Ctrl
Displays the Insert dialog box
Ctrl
Alt
Paste Special
w
;
Ctrl
Enter the current date
Closes active workbook window
Ctrl
x
:
Ctrl
Ctrl
Enter the current time
Cut
y
'
Ctrl
Copy formula from one cell up
Ctrl
Repeat last action
z
"
Ctrl
Copy value from one cell up
Ctrl
Undo
a
PgUp
Ctrl
Select entire area/worksheet
Ctrl
Next worksheet tab to left
A
PgDn
Ctrl
Ctrl
Insert argument name parentheses
Next worksheet tab to right
Find powerful Excel tips, tricks, and ideas at

ADVERTISEMENT

00 votes

Related Articles

Related forms

Related Categories

Parent category: Education
Go