Excel shortcuts Flashcards
1
Q
add border
A
ctrl + shift + 7
2
Q
edit cell
A
F2
3
Q
time
A
ctrl + :
4
Q
insert date
A
ctrl + ;
5
Q
go to very top of sheet
A
ctrl + home
6
Q
go to bottom of sheet
A
ctrl + end
7
Q
switch sheets
A
ctrl + <page> </page>
8
Q
add comment
A
shift + F2
9
Q
repeat last command
A
F4
10
Q
select column
A
Ctrl + <spacebar> </spacebar>
11
Q
select row
A
shift + <spacebar></spacebar>
12
Q
format current cell
A
Ctrl + 1
13
Q
default date format dd-mmm-yy
A
ctrl + shift + 3
14
Q
will change cell reference in formula bar to Absolute (add the ‘$’s)
A
F4
15
Q
autosum, shorcut for SUM function
A
Alt + =
