Excel shortcuts Flashcards

1
Q

add border

A

ctrl + shift + 7

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

edit cell

A

F2

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

time

A

ctrl + :

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

insert date

A

ctrl + ;

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

go to very top of sheet

A

ctrl + home

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

go to bottom of sheet

A

ctrl + end

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

switch sheets

A

ctrl + <page> </page>

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

add comment

A

shift + F2

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

repeat last command

A

F4

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

select column

A

Ctrl + <spacebar> </spacebar>

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

select row

A

shift + <spacebar></spacebar>

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

format current cell

A

Ctrl + 1

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

default date format dd-mmm-yy

A

ctrl + shift + 3

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

will change cell reference in formula bar to Absolute (add the ‘$’s)

A

F4

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

autosum, shorcut for SUM function

A

Alt + =

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

show all formulas

A

Ctrl + `

Ctrl + <left></left>

17
Q

select all

NOTE: do this inside potential table

A

ctrl + a

18
Q

toggle corners of potential table

A

ctrl + .

ctrl + <period></period>

19
Q

create table

A

Ctrl + t

20
Q

quick COPY data, after selecting cells

A

ctrl + left click –> drag

21
Q

quick INSERT data, after selecting cells

A

shift _ left click –> drag

This is useful!