excel shortcuts

Question 1

how to zoom in and out

Answer 1

CTRL, ALT, + to zoom in
CTRL, ALT, - to zoom out

Question 2

hide/show ribbon

Answer 2

CTRL f1

Question 3

Quick Access Toolbar

Answer 3

Save common shortcuts

ALT F T Q

Question 4

Navigate horizontally

Answer 4

alt + pg up/down

Question 5

how to get to the end of the document

Answer 5

CTRL + end

Question 6

How to get to the start of the document

Answer 6

CTRL + home

Question 7

how to deselect the original cell

Answer 7

Shift + Backspace

Question 8

how to go to a specific cell

Answer 8

F5 or CTRL, G

Question 9

how to select an area of cells

Answer 9

CTRL A

Question 10

how to anchor just the row

Answer 10

double press F4

Question 11

how to anchor just the column

Answer 11

triplepress f4

Question 12

entire row

Answer 12

shift spacebar

Question 13

entire column

Answer 13

ctrl spacebar

Question 14

how to paste only formatting

Answer 14

CTRL + C, ALT E S T

Question 15

how to learn ALT E S easily

Answer 15

ALT E S is for special pasting

• then lookat the underlined stuff which indicates the letter for the shortcut

Question 16

what is the default shortcut for changing formats

Answer 16

CTRL + 1

Question 17

how to create space in the custom formats

Answer 17

Question 18

how to name a sell

Answer 18

Alt + F3

Question 19

How to change names

Answer 19

go to name manager in the formula tab (ALT + M + N)

Question 20

Shortcut for formula only

Answer 20

CTRL + button below ESC

Question 21

how to make all the hardcoded cells blue

Answer 21

Click F5

then do ALT + S to get to ‘special’

then do S for ‘constants’
then uncheck text by clicking ‘x’

Question 22

shortcut for adding worksheet

Answer 22

ALT H I S

Question 23

Shortcut for getting rid of gridlines

Answer 23

ALT W VG

Question 24

Shortcut for renaming a worksheet

Answer 24

ALT H O R