1/134
Vocabulary flashcards covering core Excel and Macabacus productivity shortcuts, auditing commands, formatting cycles, and navigation tools.
Pro Precedents
Ctrl Shift [
Pro Dependents
Ctrl Shift ]
Uniformulas
Ctrl Q
Blue-Black Toggle
Ctrl ;
AutoColor Selection
Ctrl Alt A
AutoColor Sheet
Ctrl Alt S
AutoColor Workbook
Ctrl Alt Q
Error Wrap
Ctrl Shift E
Simplify Formula
Ctrl Alt Shift V
Fast Fill Right
Ctrl Shift R
Fast Fill Down
Ctrl Shift D
Capture Paintbrush Style
Ctrl Alt Shift C
Export Match Width / Match Height
Ctrl Alt Left / Ctrl Alt Down
Leader Dots
Ctrl Shift L
Footnote Cycle
Ctrl Alt Shift 6
Go to special
F5 Alt S
Lock cell references
F4
Name manager
Ctrl F3
Check row differences
Ctrl \
Check column differences
Ctrl Shift \
Cut
Ctrl X
Copy
Ctrl C
Paste
Ctrl V
Paste special
Ctrl Alt V
Fill down
Ctrl D
Fill right
Ctrl R
Insert row
Alt I R
Insert column
Alt I C
Right click
Shift F10
Insert worksheet
Shift F11
Format cells menu
Ctrl 1
Bold
Ctrl B
Underline
Ctrl U
Italic
Ctrl I
Delete row/column
Ctrl -
Number format
Ctrl Shift 1
Date format
Ctrl Shift 3
Currency format
Ctrl Shift 4
Percent format
Ctrl Shift 5
Outside border
Ctrl Shift 7
Remove borders
Ctrl Shift -
Move to last used cell
Ctrl Arrow
Select to last used cell
Ctrl Shift Arrow
Move one screen up/dn
PgUp/PgDn
Move one tab left/right
Ctrl PgUp/PgDn
Select column
Ctrl Spacebar
Select row
Shift Spacebar
Go to precedent cell
Ctrl [
Return from precedent cell
F5 Enter
Show/hide ribbon
Ctrl F1
Show accelerator keys
Alt
Save
Ctrl S
Save as
F12
Ctrl P
Close file
Ctrl F4
Close all Excel files
Alt F4
Autosum
Alt =
Enter date
Ctrl ;
Enter time
Ctrl :
Confirm change in a cell
Enter
Cancel cell entry and exit
Esc
Accept autocomplete
Tab
Insert line break
Alt Enter
Select
Shift Left/Right
Select Sections
Ctrl Shift Left/Right
Toggle edit mode
F2
Paste name into cell
F3
Repeat last action
F4
Go to command
F5
Calculate workbook
F9
Go to cell A1
Ctrl Home
Go to end of used range
Ctrl End
Go to beginning of row
Home
Next workbook
Ctrl Tab
Find
Ctrl F
Replace
Ctrl H
Undo
Ctrl Z
Redo
Ctrl Y
Select all
Ctrl A
Paste Insert
Ctrl Alt I
Paste Duplicate
Ctrl Alt D
Paste Transpose
Ctrl Alt T
Show All Precedents
Ctrl Alt [
Show All Dependents
Ctrl Alt ]
Clear Arrows
Ctrl Alt \
Zoom in
Ctrl Alt =
Zoom out
Ctrl Alt -
Toggle Gridlines
Ctrl Alt G
Hide Page Breaks
Ctrl Alt B
Row Height Cycle
Alt Shift PgUp
Column Width Cycle
Alt Shift PgDn
Group Row
Alt Shift Right
Group Column
Alt Shift Down
Ungroup Row
Alt Shift Left
Ungroup Column
Alt Shift Up
Expand All Rows
Alt Shift =
Expand All Columns
Ctrl Alt Shift =
Collapse All Rows
Alt Shift -
Collapse All Columns
Ctrl Alt Shift -
Export Match None
Ctrl Alt Right