Excel 2013 Keyboard Shortcuts

Question 1

Create new workbook

Answer 1

Ctrl + N

Question 2

Open workbook

Answer 2

Ctrl + O

Question 3

Save workbook

Answer 3

Ctrl + S

Question 4

Save as

Answer 4

F12

Question 5

Print file

Answer 5

Ctrl + P

Question 6

Open print preview

Answer 6

Ctrl + F2

Question 7

Close current workbook

Answer 7

Ctrl + F4

Question 8

Close Excel

Answer 8

Alt + F4

Question 9

Copy a formula exactly …

Answer 9

First, double click on cell to open Edit Mode. Ctrl + C to copy formula. Click Esc. Ctrl + V to paste contents in new cell.

Question 10

Open the Format Cells window…

Answer 10

Ctrl + 1

Question 11

Highlight an entire data set …

Answer 11

Ctrl + * (asterisk)

Question 12

Jump

Answer 12

Ctrl + Arrow

Question 13

Go to the top of a column in a data set…

Answer 13

Ctrl + Up Arrow

Question 14

Go to cell A1

Answer 14

Ctrl + Home

Question 15

Go to last row and column in data set.

Answer 15

Ctrl + End

Question 16

Highlight a portion of a column

Answer 16

Click, Shift, Click

Question 17

Currency Number Format

Answer 17

Ctrl + Shift + 4

Question 18

Sum

Answer 18

Alt + = (equal)

Question 19

Alt keys

Answer 19

Alt

Question 20

Pivot Table

Answer 20

Alt, N, V, T

Question 21

Page Setup

Answer 21

Alt, P, S, P

Question 22

Starting at the top highlight an entire column with data

Answer 22

Ctrl + Shift + Down Arrow

Question 23

Undo

Answer 23

Ctrl + Z

Question 24

Puts thing in a cell and moves selected cell down

Answer 24

Enter

Question 25

Puts thing in a cell and stays in selected cell

Answer 25

Ctrl + Enter

Question 26

Puts thing in a cell and moves selected cell to the right

Answer 26

Tab

Question 27

Put thing in a cell and moves selected cell up

Answer 27

Shift + Enter

Question 28

Put thing in a cell and moves selected cell to the left

Answer 28

Shift + Tab

Question 29

Toggle absolute cell reference

Answer 29

F4

Question 30

Move from corner to corner of data set

Answer 30

Ctrl + . (period)

Question 31

Cut cell range

Answer 31

Ctrl + X

Question 32

Paste everything copied including source column width...

Answer 32

Press Ctrl + V, Tap Ctrl, Tap W

Question 33

Turn on / turn off filters

Answer 33

Ctrl + Shift + 1

Question 34

Edit a cell

Answer 34

F2

Question 35

Toggle show formula

Answer 35

Ctrl + ~

Question 36

Insert table

Answer 36

Ctrl + T

Question 37

Add hyperlink

Answer 37

Ctrl + K

Question 38

Undo the undo

Answer 38

Ctrl + Y

Question 39

Hard coding today's date

Answer 39

Ctrl + ;

Question 40

Current time:

Answer 40

Ctrl + Shift + ;

Question 41

General number formatting

Answer 41

Ctrl + Shift + ~

Question 42

Shift & Outline border to the selected cells.

Answer 42

CTRL

Question 43

Change Date format with day, month and year.

Answer 43

CTRL Shift #

Question 44

Change Time format with hour and minute, AM or PM.

Answer 44

CTRL Shift @

Question 45

For the current time.

Answer 45

CTRL Shift :

Question 46

For current date.

Answer 46

CTRL ;

Question 47

Hide selected rows.

Answer 47

CTRL 9

Question 48

Hide selected columns.

Answer 48

CTRL 0

Question 49

Display Formulas/Alternate in the worksheet.

Answer 49

CTRL `

Question 50

To insert Hyperlink.

Answer 50

CTRL+K

Question 51

Opens up the Find and Replace dialog box.

Answer 51

CTRL+H

Question 52

Uses the Fill Right command to copy the contents and format of the leftmost cell of a selected range into the cells to the right.

Answer 52

CTRL+R

Question 53

Hides or displays the standard toolbar.

Answer 53

CTRL+7

Question 54

This creates a chart out of the data in the current range (selected cells).

Answer 54

ALT+F1

Question 55

Inserts a new worksheet into a workbook.

Answer 55

ALT+SHIFT+F1

Question 56

Switches between the worksheet, Ribbon, task pane, and Zoom controls.

Answer 56

F6

Question 57

The reverse of the F6 shortcut.

Answer 57

SHIFT+F6

Question 58

Switches to the next workbook window when multiple workbook windows are open.

Answer 58

CTRL+F6

Question 59

Applies the currency format to the selected cells.

Answer 59

CTRL+SHIFT+$

Question 60

Alternates between showing the value of a cell and the formula in the worksheet. Great for complex worksheets.

Answer 60

CTRL+`

Question 61

Fill down command on the selected cells. Fill down copies the content and format of the topmost cell into the cells below.

Answer 61

CTRL+D

Question 62

Fill right command on the selected cells. Fill right copies the content and format of the leftmost cell to the cells to the right.

Answer 62

CTRL+R