Brainscape's Knowledge GenomeTM

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


See full index

EXCEL > SHORTCUTS > Flashcards

SHORTCUTS Flashcards

1
Q

Tab

A

Move to the next cell, to the right of the currently selected cell.

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

Ctrl+A

A

Select all contents of a worksheet.

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

Ctrl+B

A

Bold all cells in the highlighted section.

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

Ctrl+C

A

Copy all cells in the highlighted section.

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

Ctrl+D

A

Fill down. Fills the cell beneath with the contents of the selected cell. To fill more than one cell, select the source cell and press Ctrl+Shift+Down to select multiple cells. Then press Ctrl+D to fill them with the contents of the original cell.

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

Ctrl+F

A

Search current sheet.

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

Ctrl+G

A

Go to a certain area.

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

Ctrl+H

A

Find and replace.

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

Ctrl+I

A

Puts italics on all cells in the highlighted section.

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

Ctrl+K

A

Inserts a hyperlink.

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

Ctrl+N

A

Creates a new workbook.

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

Ctrl+O

A

Opens a workbook.

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

Ctrl+P

A

Print the current sheet.

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

Ctrl+R

A

Fill right. Fills the cell to the right with the contents of the selected cell. To fill more than one cell, select the source cell and press Ctrl+Shift+Right to select multiple cells. Then press Ctrl+R to fill them with the contents of the original cell.

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

Ctrl+S

A

Saves the open worksheet.

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

Ctrl+U

A

Underlines all cells in the highlighted section.

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

Ctrl+V

A

Pastes everything copied onto the clipboard.

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

Ctrl+W

A

Closes the current workbook.

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

Ctrl+X

A

Cuts all cells in the highlighted section.

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

Ctrl+Y

A

Repeats the last entry.

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

Ctrl+Z

A

Undo the last action.

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

Ctrl+1

A

Changes the format of the selected cells.

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

Ctrl+2

A

Bolds all cells in the highlighted section

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

Ctrl+3

A

Puts italics all cells in the highlighted section.

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

Ctrl+4

A

Underlines all cells in highlighted section.

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

Ctrl+5

A

Puts a strikethrough all cells in the highlighted section.

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

Ctrl+6

A

Shows or hides objects.

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

Ctrl+7

A

Shows or hides the toolbar.

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

Ctrl+8

A

Toggles the outline symbols.

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

Ctrl+9

A

Hides rows.

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

Ctrl+0

A

Hides columns.

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

Ctrl+Shift+:

A

Enters the current time.

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

Ctrl+;

A

Enters the current date.

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

Ctrl+`

A

Changes between displaying cell values or formulas in the worksheet.

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

Ctrl+’

A

Copies a formula from the cell above.

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

Ctrl+Shift+”

A

Copies value from cell above.

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

Ctrl+-

A

Deletes the selected column or row.

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

Ctrl+Shift+=

A

Inserts a new column or row.

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

Ctrl+Shift+~

A

Switches between showing Excel formulas or their values in cells.

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

Ctrl+Shift+@

A

Applies time formatting.

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

Ctrl+Shift+!

A

Applies comma formatting.

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

Ctrl+Shift+$

A

Applies currency formatting.

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

Ctrl+Shift+#

A

Applies date formatting.

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

Ctrl+Shift+%

A

Applies percentage formatting.

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

Ctrl+Shift+^

A

Applies exponential formatting.

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

Ctrl+Shift+*

A

Selects the current region around the active cell.

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

Ctrl+Shift+&

A

Places border around selected cells.

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

Ctrl+Shift+_

A

Removes a border.

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

Ctrl++

A

Insert.

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

Ctrl+-

A

Delete.

51
Q

Ctrl+Shift+(

A

Unhide rows.

52
Q

Ctrl+Shift+)

A

Unhide columns.

53
Q

Ctrl+/

A

Selects the array containing the active cell.

54
Q

Ctrl+[

A

Selects all cells referenced by formulas in the highlighted section.

55
Q

Ctrl+]

A

Selects cells that contain formulas that reference the active cell.

56
Q

Ctrl+Shift+{

A

Selects all cells directly or indirectly referenced by formulas in the highlighted section.

57
Q

Ctrl+Shift+}

A

Selects cells which contain formulas that directly or indirectly reference the active cell.

58
Q

Ctrl+Shift+| (pipe)

A

Selects the cells within a column that don’t match the formula or static value in the active cell.

59
Q

Ctrl+Enter

A

Fills the selected cells with the current entry.

60
Q

Ctrl+Spacebar

A

Selects the entire column.

61
Q

Ctrl+Shift+Spacebar

A

Selects the entire worksheet.

62
Q

Ctrl+Home

A

Move to cell A1.

63
Q

Ctrl+End

A

Move to last cell on worksheet.

64
Q

Ctrl+Tab

A

Move between Two or more open Excel files.

65
Q

Ctrl+Shift+Tab

A

Activates the previous workbook.

66
Q

Ctrl+Shift+A

A

Inserts argument names into a formula.

67
Q

Ctrl+Shift+F

A

Opens the drop-down menu for fonts.

68
Q

Ctrl+Shift+O

A

Selects all of the cells that contain comments.

69
Q

Ctrl+Shift+P

A

Opens the drop-down menu for point size.

70
Q

Shift+Insert

A

Pastes what is stored on the clipboard.

71
Q

Shift+Page Up

A

In a single column, highlights all cells above that are selected.

72
Q

Shift+Page Down

A

In a single column, highlights all cells above that are selected.

73
Q

Shift+Home

A

Highlights all text to the left of the cursor.

74
Q

Shift+End

A

Highlights all text to the right of the cursor.

75
Q

Shift+Up Arrow

A

Extends the highlighted area up one cell.

76
Q

Shift+Down Arrow

A

Extends the highlighted area down one cell.

77
Q

Shift+Left Arrow

A

Extends the highlighted area left one character.

78
Q

Shift +Right Arrow

A

Extends the highlighted area right one character.

79
Q

Alt+Tab

A

Cycles through applications.

80
Q

Alt+Spacebar

A

Opens the system menu.

81
Q

Alt+Backspace

A

Undo.

82
Q

Alt+Enter

A

While typing text in a cell, pressing Alt+Enter will move to the next line, allowing for multiple lines of text in one cell.

83
Q

Alt+=

A

Creates a formula to sum all of the above cells.

84
Q

Alt+’

A

Allows formatting on a dialog box.

85
Q

F1

A

Opens the help menu.

86
Q

F2

A

Edits the selected cell.

87
Q

F3

A

After a name has been created, F3 will paste names.

88
Q

F4

A

Repeats last action. For example, if you changed the color of text in another cell, pressing F4 will change the text in cell to the same color.

89
Q

F5

A

Goes to a specific cell. For example, C6.

90
Q

F6

A

Move to the next pane.

91
Q

F7

A

Spell check selected text or document.

92
Q

F8

A

Enters Extend Mode.

93
Q

F9

A

Recalculates every workbook.

94
Q

F10

A

Activates the menu bar.

95
Q

F11

A

Creates a chart from selected data.

96
Q

F12

A

Save As option.

97
Q

Shift+F1

A

Opens the “What’s This?” window.

98
Q

Shift+F2

A

Allows the user to edit a cell comment.

99
Q

Shift+F3

A

Opens the Excel formula window.

100
Q

Shift+F5

A

Brings up a search box.

101
Q

Shift+F6

A

Move to previous pane.

102
Q

Shift+F8

A

Add to selection.

103
Q

Shift+F9

A

Performs calculate function on active sheet.

104
Q

Ctrl+F3

A

Open Excel Name Manager.

105
Q

Ctrl+F4

A

Closes current Window.

106
Q

Ctrl+F5

A

Restores window size.

107
Q

Ctrl+F6

A

Next workbook.

108
Q

Ctrl+Shift+F6

A

Previous workbook.

109
Q

Ctrl+F7

A

Moves the window.

110
Q

Ctrl+F8

A

Resizes the window.

111
Q

Ctrl+F9

A

Minimize current window.

112
Q

Ctrl+F10

A

Maximize currently selected window.

113
Q

Ctrl+F11

A

Inserts a macro sheet.

114
Q

Ctrl+F12

A

Opens a file.

115
Q

Ctrl+Shift+F3

A

Creates names by using those of either row or column labels.

116
Q

Ctrl+Shift+F6

A

Moves to the previous worksheet window.

117
Q

Ctrl+Shift+F12

A

Prints the current worksheet.

118
Q

Alt+F1

A

Inserts a chart.

119
Q

Alt+F2

A

Save As option.

120
Q

Alt+F4

A

Exits Excel.

121
Q

Alt+F8

A

Opens the macro dialog box.

122
Q

Alt+F11

A

Opens the Visual Basic editor.

123
Q

Alt+Shift+F1

A

Creates a new worksheet.

124
Q

Alt+Shift+F2

A

Saves the current worksheet.

EXCEL (1 decks)

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