Editing / Formulas Flashcards
Inserts a new Worksheet
Shift + F11
Inserts new cell(s) / row(s) / column(s)
Ctrl + Shift + Plus
Deletes cell(s) / row(s) / column(s)
Ctrl + Minus
Fill cells ‘Down’ in a Column
Ctrl + D
Fill cells ‘Right’ in a Row
Ctrl + R
‘Format Cell’ dialogue box (Use Tab, Space to navigate inside the box)
Ctrl + 1
Activates Cell Edit mode, allows to walk inside the cell
F2
Inserts a Row Above
Alt»_space; I»_space; R
Inserts a Column to the Left
Alt»_space; I»_space; C
‘Paste Special’ dialogue box
Alt»_space; E»_space; S
‘Find / Replace’ dialogue box
Alt»_space; E»_space; F
‘Conditional Formatting’ dialogue box
Alt»_space; O»_space; D
Calculate all worksheets
F9
Toggle between Absolute / Mixed / Relative Cell Referencing (Four times Sequential Key Presses)
F4
Auto Sum
Alt + =