100 Hot keys Flashcards

1
Q

Show hotkeys

A

[Alt]

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

Auto sum - sum all the cells above

A

[Alt][=]

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

Open a combo box or filter list

A

[Alt][down]

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

New Line - when inside a cell this will start a new line in that cell

A

[Alt][Enter]

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

Cycle backward through open applications

A

[Alt][Shift][Tab]

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

Cycle forward through open applications

A

[Alt][Tab]

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

Move to next cell

A

[Arrow Key]

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

Enter the current date

A

[Ctrl][;]

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

Open format dialog

A

[Ctrl][1]

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

Select all

A

[Ctrl][A]

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

Move to next section of text.

A

[Ctrl][Arrow key]

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

Bold highlighted selection

A

[Ctrl][B]

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

Copy

A

[Ctrl][C]

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

Move to the end of line of text (or region)

A

[Ctrl][End]

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

Enter the same data or formula into all cells selected

A

[Ctrl][Enter]

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

Move to beginning of line of text (or last nonblank row/column)

A

[Ctrl][Home]

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

Bring up the print dialog box to begin printing

A

[Ctrl][P]

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

Switches between worksheet tabs, from left-to-right

A

[Ctrl][Page Down]

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

Switches between worksheet tabs, from right-to-left

A

[Ctrl][Page Up]

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

Save

A

[Ctrl][S]

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

Selecting a region

A

[Ctrl][Shift][ Arrows]

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

Enter the current time

A

[Ctrl][Shift][;]

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

Select to end of line of text (or region)

A

[Ctrl][Shift][End]

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

Select to beginning of line of text (or cell a1)

A

[Ctrl][Shift][Home]

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

Select entire column

A

[Ctrl][Space]

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

Move between open excel files

A

[Ctrl][Tab]

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

Underline highlighted selection

A

[Ctrl][U]

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

Paste

A

[Ctrl][V]

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

Cut

A

[Ctrl][X]

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

Redo last action (can be used multiple times)

A

[Ctrl][Y]

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

Undo last action (can be used multiple times)

A

[Ctrl][Z]

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

Help

A

[F1]

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

Cycle through absolute and relative (in formula)

A

[F4]

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

Selecting cells

A

[Shift][Arrows]

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

Open context menu

A

[Shift][F10]

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

Select entire row

A

[Shift][Space]

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

Group using hot keys or Shortcut keys for Mac

A

[Alt],[A],[G],[G]

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

Sort in ascending order using hot keys

A

[Alt],[A],[S],[A]

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

Sort in descending order using hot keys

A

[Alt],[A],[S],[D]

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

Open sort dialog box using hot keys

A

[Alt],[A],[S],[S]

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

Filter a table or range using hot keys

A

[Alt],[A],[T]

42
Q

Ungroup using hot keys

A

[Alt],[A],[U],[U]

43
Q

Format using hot keys

A

[Alt],[H],[O]

44
Q

Increase decimal using hot keys

A

[Alt],[H],[0]

45
Q

Decrease indent using hot keys

A

[Alt],[H],[5]

46
Q

Indent using hot keys

A

[Alt],[H],[6]

47
Q

Decrease decimal using hot keys

A

[Alt],[H],[9]

48
Q

Apply all borders using hot keys

A

[Alt],[H],[B],[A]

49
Q

Remove the outline border from the selected cells using hot keys

A

[Alt],[H],[B],[N]

50
Q

Apply a bottom border using hot keys

A

[Alt],[H],[B],[O]

51
Q

Apply a top border using hot keys

A

[Alt],[H],[B],[P]

52
Q

Apply outline border to the selected cells using hot keys

A

[Alt],[H],[B],[S]

53
Q

Top and double bottom border using hot keys

A

[Alt],[H],[B],[U]

54
Q

Delete cells

A

[Alt],[H],[D]

55
Q

Clear all using hot keys

A

[Alt],[H],[E],[A]

56
Q

Insert cells using hot keys

A

[Alt],[H],[I]

57
Q

Format accounting using hot keys

A

[Alt],[H],[K]

58
Q

Conditional formatting using hot keys

A

[Alt],[H],[L]

59
Q

Format percentage using hot keys

A

[Alt],[H],[P]

60
Q

Paste values using hot keys

A

[Alt],[H],[V],[V]

61
Q

Name a cell

A

[Alt],[M],[M],[D]

62
Q

Open name dialog box using hot keys

A

[Alt],[M],[N]

63
Q

Insert pivot table using hot keys

A

[Alt],[N],[V]

64
Q

Freeze and unfreeze panes using hot keys

A

[Alt],[W],[F],[F]

65
Q

Select visible cells

A

[Alt][;]

66
Q

Insert new worksheet

A

[Alt][Shift][F1]

67
Q

Copy the value from the cell above the active cell into the cell or the formula bar

A

[Ctrl][’]

68
Q

Alternate between displaying cell values and displaying formulas in the worksheet

A

[Ctrl][~]

69
Q

Hide columns

A

[Ctrl][0]

70
Q

Hide rows

A

[Ctrl][9]

71
Q

Fill down command to copy the contents and format of the topmost cell of a selected range into the cells below.

A

[Ctrl][D]

72
Q

Find

A

[Ctrl][F]

73
Q

Minimize / maximize currently selected window

A

[Ctrl][F10]

74
Q

Print preview

A

[Ctrl][F2]

75
Q

Minimize current window

A

[Ctrl][F9]

76
Q

Find & replace

A

[Ctrl][H]

77
Q

Italic highlighted selection

A

[Ctrl][I]

78
Q

New workbook

A

[Ctrl][N]

79
Q

Displays the quick analysis options for your data when you have cells that contain that data selected

A

[Ctrl][Q]

80
Q

Applies the general number format

A

[Ctrl][Shift][ ~]

81
Q

Apply comma format

A

[Alt],[H],[K]

82
Q

Applies the currency format with two decimal places (negative numbers in parentheses).

A

[Ctrl][Shift][$]

83
Q

Applies the percentage format with no decimal places

A

[Alt],[H],[P]

84
Q

Unhide rows

A

[Ctrl][Shift][(]

85
Q

Unhide columns

A

[Ctrl][Shift][)]

86
Q

Create a table

A

[Ctrl][T]

87
Q

Delete cell content

A

[Del]

88
Q

Create chart

A

[F11]

89
Q

Save as

A

[F12]

90
Q

Edit the selected cell

A

[F2]

91
Q

Show names

A

[F3]

92
Q

Display the go to dialog box

A

[F5]

93
Q

Switch between the ribbon and task pane

A

[F6]

94
Q

Spell check selected text and/or document

A

[F7]

95
Q

Toggle extend selection

A

[F8]

96
Q

Calculate the workbook

A

[F9]

97
Q

Insert a new worksheet

A

[Shift][F11]

98
Q

Adds or edit a cell comment

A

[Shift][F2]

99
Q

Open the excel formula window

A

[Shift][F3]

100
Q

Calculate the worksheet

A

[Shift][F9]