Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

MS Office 2013 > Excel 2013 Keyboard Shortcuts > Flashcards

Excel 2013 Keyboard Shortcuts Flashcards

Learn commonly used Excel 2013 keyboard shortcuts

1
Q

Create new workbook

A

Ctrl + N

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

Open workbook

A

Ctrl + O

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

Save workbook

A

Ctrl + S

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

Save as

A

F12

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

Print file

A

Ctrl + P

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

Open print preview

A

Ctrl + F2

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

Close current workbook

A

Ctrl + F4

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

Close Excel

A

Alt + F4

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

Copy a formula exactly …

A

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

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

Open the Format Cells window…

A

Ctrl + 1

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

Highlight an entire data set …

A

Ctrl + * (asterisk)

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

Jump

A

Ctrl + Arrow

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

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

A

Ctrl + Up Arrow

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

Go to cell A1

A

Ctrl + Home

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

Go to last row and column in data set.

A

Ctrl + End

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

Highlight a portion of a column

A

Click, Shift, Click

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

Currency Number Format

A

Ctrl + Shift + 4

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

Sum

A

Alt + = (equal)

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

Alt keys

A

Alt

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

Pivot Table

A

Alt, N, V, T

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

Page Setup

A

Alt, P, S, P

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

Starting at the top highlight an entire column with data

A

Ctrl + Shift + Down Arrow

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

Undo

A

Ctrl + Z

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

Puts thing in a cell and moves selected cell down

A

Enter

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

Puts thing in a cell and stays in selected cell

A

Ctrl + Enter

26
Q

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

A

Tab

27
Q

Put thing in a cell and moves selected cell up

A

Shift + Enter

28
Q

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

A

Shift + Tab

29
Q

Toggle absolute cell reference

A

F4

30
Q

Move from corner to corner of data set

A

Ctrl + . (period)

31
Q

Cut cell range

A

Ctrl + X

32
Q

Paste everything copied including source column width…

A

Press Ctrl + V, Tap Ctrl, Tap W

33
Q

Turn on / turn off filters

A

Ctrl + Shift + 1

34
Q

Edit a cell

A

F2

35
Q

Toggle show formula

A

Ctrl + ~

36
Q

Insert table

A

Ctrl + T

37
Q

Add hyperlink

A

Ctrl + K

38
Q

Undo the undo

A

Ctrl + Y

39
Q

Hard coding today’s date

A

Ctrl + ;

40
Q

Current time:

A

Ctrl + Shift + ;

41
Q

General number formatting

A

Ctrl + Shift + ~

42
Q

Shift & Outline border to the selected cells.

A

CTRL

43
Q

Change Date format with day, month and year.

A

CTRL Shift #

44
Q

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

A

CTRL Shift @

45
Q

For the current time.

A

CTRL Shift :

46
Q

For current date.

A

CTRL ;

47
Q

Hide selected rows.

A

CTRL 9

48
Q

Hide selected columns.

A

CTRL 0

49
Q

Display Formulas/Alternate in the worksheet.

A

CTRL `

50
Q

To insert Hyperlink.

A

CTRL+K

51
Q

Opens up the Find and Replace dialog box.

A

CTRL+H

52
Q

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.

A

CTRL+R

53
Q

Hides or displays the standard toolbar.

A

CTRL+7

54
Q

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

A

ALT+F1

55
Q

Inserts a new worksheet into a workbook.

A

ALT+SHIFT+F1

56
Q

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

A

F6

57
Q

The reverse of the F6 shortcut.

A

SHIFT+F6

58
Q

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

A

CTRL+F6

59
Q

Applies the currency format to the selected cells.

A

CTRL+SHIFT+$

60
Q

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

A

CTRL+`

61
Q

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

A

CTRL+D

62
Q

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

A

CTRL+R

MS Office 2013 (1 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions