Brainscape's Knowledge GenomeTM


Top Flashcards (Certified)
All Flashcards

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
Ctrl+4
Underlines all cells in highlighted section.
26
Ctrl+5
Puts a strikethrough all cells in the highlighted section.
27
Ctrl+6
Shows or hides objects.
28
Ctrl+7
Shows or hides the toolbar.
29
Ctrl+8
Toggles the outline symbols.
30
Ctrl+9
Hides rows.
31
Ctrl+0
Hides columns.
32
Ctrl+Shift+:
Enters the current time.
33
Ctrl+;
Enters the current date.
34
Ctrl+`
Changes between displaying cell values or formulas in the worksheet.
35
Ctrl+'
Copies a formula from the cell above.
36
Ctrl+Shift+"
Copies value from cell above.
37
Ctrl+-
Deletes the selected column or row.
38
Ctrl+Shift+=
Inserts a new column or row.
39
Ctrl+Shift+~
Switches between showing Excel formulas or their values in cells.
40
Ctrl+Shift+@
Applies time formatting.
41
Ctrl+Shift+!
Applies comma formatting.
42
Ctrl+Shift+$
Applies currency formatting.
43
Ctrl+Shift+#
Applies date formatting.
44
Ctrl+Shift+%
Applies percentage formatting.
45
Ctrl+Shift+^
Applies exponential formatting.
46
Ctrl+Shift+*
Selects the current region around the active cell.
47
Ctrl+Shift+&
Places border around selected cells.
48
Ctrl+Shift+_
Removes a border.
49
Ctrl++
Insert.
50
Ctrl+-
Delete.
51
Ctrl+Shift+(
Unhide rows.
52
Ctrl+Shift+)
Unhide columns.
53
Ctrl+/
Selects the array containing the active cell.
54
Ctrl+[
Selects all cells referenced by formulas in the highlighted section.
55
Ctrl+]
Selects cells that contain formulas that reference the active cell.
56
Ctrl+Shift+{
Selects all cells directly or indirectly referenced by formulas in the highlighted section.
57
Ctrl+Shift+}
Selects cells which contain formulas that directly or indirectly reference the active cell.
58
Ctrl+Shift+| (pipe)
Selects the cells within a column that don’t match the formula or static value in the active cell.
59
Ctrl+Enter
Fills the selected cells with the current entry.
60
Ctrl+Spacebar
Selects the entire column.
61
Ctrl+Shift+Spacebar
Selects the entire worksheet.
62
Ctrl+Home
Move to cell A1.
63
Ctrl+End
Move to last cell on worksheet.
64
Ctrl+Tab
Move between Two or more open Excel files.
65
Ctrl+Shift+Tab
Activates the previous workbook.
66
Ctrl+Shift+A
Inserts argument names into a formula.
67
Ctrl+Shift+F
Opens the drop-down menu for fonts.
68
Ctrl+Shift+O
Selects all of the cells that contain comments.
69
Ctrl+Shift+P
Opens the drop-down menu for point size.
70
Shift+Insert
Pastes what is stored on the clipboard.
71
Shift+Page Up
In a single column, highlights all cells above that are selected.
72
Shift+Page Down
In a single column, highlights all cells above that are selected.
73
Shift+Home
Highlights all text to the left of the cursor.
74
Shift+End
Highlights all text to the right of the cursor.
75
Shift+Up Arrow
Extends the highlighted area up one cell.
76
Shift+Down Arrow
Extends the highlighted area down one cell.
77
Shift+Left Arrow
Extends the highlighted area left one character.
78
Shift +Right Arrow
Extends the highlighted area right one character.
79
Alt+Tab
Cycles through applications.
80
Alt+Spacebar
Opens the system menu.
81
Alt+Backspace
Undo.
82
Alt+Enter
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
Alt+=
Creates a formula to sum all of the above cells.
84
Alt+'
Allows formatting on a dialog box.
85
F1
Opens the help menu.
86
F2
Edits the selected cell.
87
F3
After a name has been created, F3 will paste names.
88
F4
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
F5
Goes to a specific cell. For example, C6.
90
F6
Move to the next pane.
91
F7
Spell check selected text or document.
92
F8
Enters Extend Mode.
93
F9
Recalculates every workbook.
94
F10
Activates the menu bar.
95
F11
Creates a chart from selected data.
96
F12
Save As option.
97
Shift+F1
Opens the "What's This?" window.
98
Shift+F2
Allows the user to edit a cell comment.
99
Shift+F3
Opens the Excel formula window.
100
Shift+F5
Brings up a search box.
101
Shift+F6
Move to previous pane.
102
Shift+F8
Add to selection.
103
Shift+F9
Performs calculate function on active sheet.
104
Ctrl+F3
Open Excel Name Manager.
105
Ctrl+F4
Closes current Window.
106
Ctrl+F5
Restores window size.
107
Ctrl+F6
Next workbook.
108
Ctrl+Shift+F6
Previous workbook.
109
Ctrl+F7
Moves the window.
110
Ctrl+F8
Resizes the window.
111
Ctrl+F9
Minimize current window.
112
Ctrl+F10
Maximize currently selected window.
113
Ctrl+F11
Inserts a macro sheet.
114
Ctrl+F12
Opens a file.
115
Ctrl+Shift+F3
Creates names by using those of either row or column labels.
116
Ctrl+Shift+F6
Moves to the previous worksheet window.
117
Ctrl+Shift+F12
Prints the current worksheet.
118
Alt+F1
Inserts a chart.
119
Alt+F2
Save As option.
120
Alt+F4
Exits Excel.
121
Alt+F8
Opens the macro dialog box.
122
Alt+F11
Opens the Visual Basic editor.
123
Alt+Shift+F1
Creates a new worksheet.
124
Alt+Shift+F2
Saves the current worksheet.

EXCEL (1 decks)

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