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

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

30
Q

Move from corner to corner of data set

A

Ctrl + . (period)

31
Q

Cut cell range

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

35
Q

Toggle show formula

36
Q

Insert table

37
Q

Add hyperlink

38
Q

Undo the undo

39
Q

Hard coding today’s date

40
Q

Current time:

A

Ctrl + Shift + ;

41
Q

General number formatting

A

Ctrl + Shift + ~

42
Q

Shift & Outline border to the selected cells.

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.

47
Q

Hide selected rows.

48
Q

Hide selected columns.

49
Q

Display Formulas/Alternate in the worksheet.

50
Q

To insert Hyperlink.

51
Q

Opens up the Find and Replace dialog box.

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.

53
Q

Hides or displays the standard toolbar.

54
Q

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

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.

57
Q

The reverse of the F6 shortcut.

58
Q

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

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.

61
Q

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

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.

MS Office 2013 (1 decks)

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