Keyboard Shortcuts

Question 1

Jump to Bottom of Data

Answer 1

Ctrl-Down Arrow

Question 2

Jump to Top of Data

Answer 2

Ctrl-Up Arrow

Question 3

Go to Previous Sheet

Answer 3

Ctrl-Page Up

Question 4

Go to Next Sheet

Answer 4

Ctrl-Page Down

Question 5

Select All Data in Column

Answer 5

Ctrl-Shift-Down Arrow

Question 6

Select Whole Column

Answer 6

Ctrl-Space

Question 7

Select All Data in Row

Answer 7

Shift-Space

Question 8

Select All Data in Region

Answer 8

Ctrl-A

Question 9

Filter

Answer 9

Ctrl-Shift-L

Question 10

Find

Answer 10

Ctrl-F

Question 11

Flash Fill

Answer 11

Ctrl-E

Question 12

Select Discontinuous Cells

Answer 12

Shift-F8

Question 13

Spell Check

Answer 13

F7

Question 14

Automatically Add Sum Totals for Columns and/or Rows

Answer 14

Alt-=

Question 15

Remove Duplicates

Answer 15

Alt-A-M

Question 16

Sort A-Z

Answer 16

Alt-A-S-A

Question 17

Sort Z-A

Answer 17

Alt-A-S-D

Question 18

Delete Row / Delete Column

Answer 18

Ctrl-minus

Question 19

Copy Selected Object or Data

Answer 19

Ctrl-D

Question 20

Format Cells

Answer 20

Ctrl-1

Question 21

Create Data Table

Answer 21

Alt-A-W-T

Question 22

Autoformat Data Tables

Answer 22

Alt-O-A

Question 23

Format As Currency

Answer 23

Ctrl-Shift-4

Question 24

Format As 2 Decimal Place Number

Answer 24

Ctrl-Shift-1

Question 25

Paste as Value

Answer 25

Ctrl-Alt-V-V-Enter or Alt-E-S-V-Enter

Question 26

Paste as Formulas

Answer 26

Alt-E-S-F-Enter

Question 27

Insert Row / Insert Column

Answer 27

Ctrl-Shift-plus

Question 28

Things to do with Left Click & Drag (both Row & Column)

Answer 28

Left Click & Drag&raquo_space; Move
Shift - Left Click & Drag&raquo_space; Insert
Ctrl - Shift - Left Click & Drag&raquo_space; Duplicate

Question 29

Filter by Value

Answer 29

Keyboard Menu -E-V

Question 30

Cycle through Excel Instance

Answer 30

Ctrl-Tab or Ctrl-Shift-Tab

Question 31

Create Table

Answer 31

Ctrl-T

Question 32

Copy to the right

Answer 32

Ctrl-R

Question 33

Resize object sticking to the Grid

Answer 33

By Pressing Alt

Question 34

Move Object by locking one of the axis

Answer 34

By Pressing Shift

Question 35

View all the formulas

Answer 35

Ctrl - `

Question 36

Display All Values From Top till Previous Cell

Answer 36

Alt - Down Arrow

Question 37

Save As Dialog Box

Answer 37

F12

Question 38

Go to Dialog Box

Answer 38

F5 or Ctrl-G
Go to Special From this dialog box&raquo_space; Alt - S

Question 39

Insert Hyperlink

Answer 39

Ctrl - K

Question 40

Insert Default Chart

Answer 40

Select The Data & Alt-F1

Question 41

Hide Row / Column

Answer 41

Row = Ctrl-0
Column = Ctrl-9

Question 42

Select Visible Cell or Check if any row/column hidden

Answer 42

Alt-;

Question 43

Highlights the values which doesn’t have formulas in them. The values which has formulas is not highlighted.

Answer 43

F5 - Alt - S - O - X

Question 44

Open User Form To Enter Data in Table

Answer 44

Convert the data into Table & then:
Alt - D - O

Question 45

Create default chart

Answer 45

Select the data & Alt - F1

Question 46

Select multiple cell without pressing Ctrl Key

Answer 46

Shift - F8

Question 47

Rename Sheet

Answer 47

Alt - H - O - R

Question 48

Delete the sheet

Answer 48

Alt - H - D - S

Question 49

Autoformatting

Answer 49

Alt - O - A

Question 50

Full Screen

Answer 50

Alt - V - U