Brainscape's Knowledge GenomeTM

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


See full index

Guides > Excel Shortcuts (with modded excel) > Flashcards

Excel Shortcuts (with modded excel) Flashcards

1
Q

COPY

A

CRTL + C

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

PASTE

A

CRTL + V

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

UNDO

A

CRTL + Z

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

REDO

A

CRTL + Y

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

OPEN FILE

A

CRTL + O

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

NEW FILE

A

CRTL + N

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

PRINT

A

CRTL + P

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

SAVE

A

CRTL + S

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

SAVE AS

A

F12

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

GO TO NEW WORKBOOK (DIF TAB)

A

CRTL + TAB

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

CLOSE FILE

A

CRTL + F4

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

OPEN FORMAT CELLS DIALOG

A

CRTL + 1

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

BOLD

A

CRTL + B

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

ITALIC

A

CRTL + I

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

UNDERLINE

A

CRTL + U

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

NUMBER FORMAT

A

CRTL + SHIFT + 1

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

PERCENT FORMAT

A

CRTL + SHIFT + 5

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

DATE FORMAT

A

CRTL + SHIFT + 3

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

INCREASE FONT SIZE

A

ALT H FG

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

DECREASE FONT SIZE

A

ALT H FK

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

INSERT/EDIT COMMENT

A

SHIFT + F2

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

INCREASE DECIMAL

A

ALT H 0

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

DECREASE DECIMAL

A

ALT H 9

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

INCREASE INDENT

A

ALT H 6

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

DECREASE INDENT

A

ALT H 5

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

CLEAR CELL DATA

A

DELETE

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

CLEAR CELL FORMATS

A

ALT H E F

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

CLEAR ALL

A

ALT H E A

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

OUTLINE BORDER

A

CRTL + SHIFT + 7

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

REMOVE BORDER

A

CRTL +SHIFT + -

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

LEFT BORDER

A

ALT H B L

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

RIGHT BORDER

A

ALT H B R

33
Q

TOP BORDER

A

ALT H B P

34
Q

BOTTOM BORDER

A

ALT H B O

35
Q

PASTE SPECIAL FORMATS

A

CRTL + ALT + V T

36
Q

PASTE SPECIAL VALUES

A

CRTL + ALT + V V

37
Q

PASTE SPECIAL FORMULAS

A

CRTL + ALT + V F

38
Q

PASTE SPECIAL COMMENTS

A

CRTL + ALT + V C

39
Q

SHOW RIBBON ACCELERATOR KEYS

A

ALT

40
Q

SHOW/HIDE RIBBON

A

CRTL+F1

41
Q

MOVE ONE SCREEN LEFT

A

ALT + PGUP

42
Q

MOVE ONE SCREEN RIGHT

A

ALT+ PGDOWN

43
Q

GOT TO CELL A1

A

CRTL + HOME

44
Q

GO TO BEGINNING OF ROW

A

HOME

45
Q

OPEN THE GO TO DIALOG BOX

A

F5

46
Q

FIND AND REPLACE

A

CRTL + F

47
Q

HIGHLIGHT CELLS WITH COMMENTS

A

F5 ALT S C

48
Q

EDIT THE ACTIVE CELL

A

F2

49
Q

WHILE EDITING CELL, ALLOW USE OF ARROW KEYS TO CREATE REFERENCE

A

F2

50
Q

CONFIRM CHANGE AND LEAVE CELL

A

ENTER

51
Q

CANCEL CELL ENTRY AND LEAVE CELL

A

ESC

52
Q

INSERT LINE BREAK WITHIN CELL

A

ALT + ENTER

53
Q

JUMP TO BEGINNING OF CELL

A

HOME

54
Q

JUMP TO END OF CELL

A

END

55
Q

REFERENCE A CELL FROM ANOTHER WORK SHEET

A

CRTL + PG(UP/DN) ARROWS

56
Q

RECALCULATE ALL WORKSHEETS

A

F9

57
Q

ANCHOR CELLS

A

F4

58
Q

OPEN INSERT FORMULA DIALOG

A

SHIFT + F3

59
Q

ENTER ARRAY FORMULA (IN EDIT MODE)

A

SHIFT+CRTL+ENTER

60
Q

INSPECT CELL VALUES

A

F9

61
Q

SWITCH TO FORMULA VIEW

A

CRTL + ~

62
Q

GO TO LAST CELL

A

F5 + ENTER

63
Q

SELECT COLUMN

A

CRTL + SPACE

64
Q

SELECT ROW

A

SHIFT + SPACE

65
Q

DELETE ROW(S)/COLUMN(S)

A

CRTL + -

66
Q

ADD ROW(S)/COLUMN(S)

A

CRTL + SHIFT + +

67
Q

SET COLUMN WIDTH

A

ALT H O W

68
Q

AUTOFIT COLUMN WIDTH

A

ALT H O I

69
Q

FIT TO SPECIFIC ROW HEIGHT

A

ALT H O H

70
Q

GROUP ROWS/COLUMNS

A

ALT+SHIFT+ ->

71
Q

UNGROUP ROWS/COLUMNS

A

ALT+SHIFT+

72
Q

JUMP TO NEXT WORKSHEET

A

CRTL+PGDN

73
Q

JUMP TO PREVIOUS WORKSHEET

A

CRTL+PGUP

74
Q

CHANGE WORKSHEET NAME

A

ALT H O R

75
Q

REARRANGE TAB ORDER

A

ALT H O M

76
Q

FREEZE PANE

A

ALT W F F

77
Q

SPLIT SCREEN

A

ALT W S

78
Q

CLOSE HELP (AND OTHER PANES)

A

CRTL + SPACE

79
Q

Add new worksheet

A

SHIFT + F11

Guides (5 decks)

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