Excel shortcuts

Question 1

add border

Answer 1

ctrl + shift + 7

Question 2

edit cell

Answer 2

F2

Question 3

time

Answer 3

ctrl + :

Question 4

insert date

Answer 4

ctrl + ;

Question 5

go to very top of sheet

Answer 5

ctrl + home

Question 6

go to bottom of sheet

Answer 6

ctrl + end

Question 7

switch sheets

Answer 7

ctrl + <page> </page>

Question 8

add comment

Answer 8

shift + F2

Question 9

repeat last command

Answer 9

F4

Question 10

select column

Answer 10

Ctrl + <spacebar> </spacebar>

Question 11

select row

Answer 11

shift + <spacebar></spacebar>

Question 12

format current cell

Answer 12

Ctrl + 1

Question 13

default date format dd-mmm-yy

Answer 13

ctrl + shift + 3

Question 14

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

Answer 14

F4

Question 15

autosum, shorcut for SUM function

Answer 15

Alt + =

Question 16

show all formulas

Answer 16

Ctrl + `

Ctrl + <left></left>

Question 17

select all

NOTE: do this inside potential table

Answer 17

ctrl + a

Question 18

toggle corners of potential table

Answer 18

ctrl + .

ctrl + <period></period>

Question 19

create table

Answer 19

Ctrl + t

Question 20

quick COPY data, after selecting cells

Answer 20

ctrl + left click –> drag

Question 21

quick INSERT data, after selecting cells

Answer 21

shift _ left click –> drag

This is useful!