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