excel + NPV/IRR Flashcards
Alt
Opens up menu toolbar (top), shows letters
Ctrl + Home
Home saving - ensures every sheet saved
Saving
SAVE NEW every 15 mins - do NOT autosave
Reiterate/recalculate model
F9
Erase a cell
Hit DELETE , never hit SPACEBAR
Merging
DO NOT merge cells, use merge across selection instead (Ctrl + 1)
Navigate between tabs
Ctrl pgup, ctrl pgdown
Navigate between workbooks
Ctrl tab
Open/close workbook
Open: Ctrl N
Close: Alt F C
Highlight cells
SHIFT (hold) + arrows
Highlight entire row
Shift (hold) + SPACEBAR
Highlight entire column
CTRL (hold) + SPACEBAR
“Go to” a cell
CTRL (hold) + G
Check links
CTRL (hold) [
Ctrl C vs. Ctrl X
Ctrl C: copies existing cells and pastes a duplicate of these copied cells. LEAVES original cells.
Ctrl X: removes a group of cells and places them in another area of the worksheet.
Fill right/fill down
Ctrl R + Ctrl D
Paste formula
Alt, E S F
Paste formatting
Alt, E S T
Paste value
Alt, E S V
Paste link
Alt, E S L
Insert worksheet
Alt i W
Edit/delete worksheet
Alt E L
Window freeze panes
Alt W F F
Group/ungroup data
HIGHLIGHT DATA FIRST
Group: Alt D G G
Ungroup: Alt D G U
Format column width/autofit column width
Width: Alt OCW
Autofit: Alt OCA
Format row height/autofit row height
Height: Alt ORE
Autofit: Alt ORA
Insert row/insert column
Insert row: Alt i R
Insert column: Alt i C
Conditional formatting (create new rule)
Alt H L N
Enter edit mode/activate cell
F2
Lock cells
F4
