Excel and Macabacus Productivity Shortcuts

0.0(0)
Studied by 0 people
call kaiCall Kai
learnLearn
examPractice Test
spaced repetitionSpaced Repetition
heart puzzleMatch
flashcardsFlashcards
GameKnowt Play
Card Sorting

1/134

flashcard set

Earn XP

Description and Tags

Vocabulary flashcards covering core Excel and Macabacus productivity shortcuts, auditing commands, formatting cycles, and navigation tools.

135 Terms

1
New cards

Pro Precedents

Ctrl Shift [

2
New cards

Pro Dependents

Ctrl Shift ]

3
New cards

Uniformulas

Ctrl Q

4
New cards

Blue-Black Toggle

Ctrl ;

5
New cards

AutoColor Selection

Ctrl Alt A

6
New cards

AutoColor Sheet

Ctrl Alt S

7
New cards

AutoColor Workbook

Ctrl Alt Q

8
New cards

Error Wrap

Ctrl Shift E

9
New cards

Simplify Formula

Ctrl Alt Shift V

10
New cards

Fast Fill Right

Ctrl Shift R

11
New cards

Fast Fill Down

Ctrl Shift D

12
New cards

Capture Paintbrush Style

Ctrl Alt Shift C

13
New cards

Export Match Width / Match Height

Ctrl Alt Left / Ctrl Alt Down

14
New cards

Leader Dots

Ctrl Shift L

15
New cards

Footnote Cycle

Ctrl Alt Shift 6

16
New cards

Go to special

F5 Alt S

17
New cards

Lock cell references

F4

18
New cards

Name manager

Ctrl F3

19
New cards

Check row differences

Ctrl \

20
New cards

Check column differences

Ctrl Shift \

21
New cards

Cut

Ctrl X

22
New cards

Copy

Ctrl C

23
New cards

Paste

Ctrl V

24
New cards

Paste special

Ctrl Alt V

25
New cards

Fill down

Ctrl D

26
New cards

Fill right

Ctrl R

27
New cards

Insert row

Alt I R

28
New cards

Insert column

Alt I C

29
New cards

Right click

Shift F10

30
New cards

Insert worksheet

Shift F11

31
New cards

Format cells menu

Ctrl 1

32
New cards

Bold

Ctrl B

33
New cards

Underline

Ctrl U

34
New cards

Italic

Ctrl I

35
New cards

Delete row/column

Ctrl -

36
New cards

Number format

Ctrl Shift 1

37
New cards

Date format

Ctrl Shift 3

38
New cards

Currency format

Ctrl Shift 4

39
New cards

Percent format

Ctrl Shift 5

40
New cards

Outside border

Ctrl Shift 7

41
New cards

Remove borders

Ctrl Shift -

42
New cards

Move to last used cell

Ctrl Arrow

43
New cards

Select to last used cell

Ctrl Shift Arrow

44
New cards

Move one screen up/dn

PgUp/PgDn

45
New cards

Move one tab left/right

Ctrl PgUp/PgDn

46
New cards

Select column

Ctrl Spacebar

47
New cards

Select row

Shift Spacebar

48
New cards

Go to precedent cell

Ctrl [

49
New cards

Return from precedent cell

F5 Enter

50
New cards

Show/hide ribbon

Ctrl F1

51
New cards

Show accelerator keys

Alt

52
New cards

Save

Ctrl S

53
New cards

Save as

F12

54
New cards

Print

Ctrl P

55
New cards

Close file

Ctrl F4

56
New cards

Close all Excel files

Alt F4

57
New cards

Autosum

Alt =

58
New cards

Enter date

Ctrl ;

59
New cards

Enter time

Ctrl :

60
New cards

Confirm change in a cell

Enter

61
New cards

Cancel cell entry and exit

Esc

62
New cards

Accept autocomplete

Tab

63
New cards

Insert line break

Alt Enter

64
New cards

Select

Shift Left/Right

65
New cards

Select Sections

Ctrl Shift Left/Right

66
New cards

Toggle edit mode

F2

67
New cards

Paste name into cell

F3

68
New cards

Repeat last action

F4

69
New cards

Go to command

F5

70
New cards

Calculate workbook

F9

71
New cards

Go to cell A1

Ctrl Home

72
New cards

Go to end of used range

Ctrl End

73
New cards

Go to beginning of row

Home

74
New cards

Next workbook

Ctrl Tab

75
New cards

Find

Ctrl F

76
New cards

Replace

Ctrl H

77
New cards

Undo

Ctrl Z

78
New cards

Redo

Ctrl Y

79
New cards

Select all

Ctrl A

80
New cards

Paste Insert

Ctrl Alt I

81
New cards

Paste Duplicate

Ctrl Alt D

82
New cards

Paste Transpose

Ctrl Alt T

83
New cards

Show All Precedents

Ctrl Alt [

84
New cards

Show All Dependents

Ctrl Alt ]

85
New cards

Clear Arrows

Ctrl Alt \

86
New cards

Zoom in

Ctrl Alt =

87
New cards

Zoom out

Ctrl Alt -

88
New cards

Toggle Gridlines

Ctrl Alt G

89
New cards

Hide Page Breaks

Ctrl Alt B

90
New cards

Row Height Cycle

Alt Shift PgUp

91
New cards

Column Width Cycle

Alt Shift PgDn

92
New cards

Group Row

Alt Shift Right

93
New cards

Group Column

Alt Shift Down

94
New cards

Ungroup Row

Alt Shift Left

95
New cards

Ungroup Column

Alt Shift Up

96
New cards

Expand All Rows

Alt Shift =

97
New cards

Expand All Columns

Ctrl Alt Shift =

98
New cards

Collapse All Rows

Alt Shift -

99
New cards

Collapse All Columns

Ctrl Alt Shift -

100
New cards

Export Match None

Ctrl Alt Right