WALL STREET PREP: EXCEL EXAM QUESTIONS WITH
COMPLETE SOLUTIONS RATED A++
Add/delete sheets
alt-i-w OR alt h-i-s
Moving around task ribbon
Tab and shift (to select)
Auto fit cell
alt-h-o-i
Custom fit columns
alt h-o-w
Custom fit rows
alt h-o-h
Select entire column/row
ctrl shift-arrow key
Format cells
ctrl 1
Paste special
alt e-s
Freeze panes
alt w-f-f
Split panes
alt w-s
Move between panes
F6
Get in cell AND navigate to others while inside
F2
Edit a cell from the outside
alt h-e
Add comments
COMPLETE SOLUTIONS RATED A++
Add/delete sheets
alt-i-w OR alt h-i-s
Moving around task ribbon
Tab and shift (to select)
Auto fit cell
alt-h-o-i
Custom fit columns
alt h-o-w
Custom fit rows
alt h-o-h
Select entire column/row
ctrl shift-arrow key
Format cells
ctrl 1
Paste special
alt e-s
Freeze panes
alt w-f-f
Split panes
alt w-s
Move between panes
F6
Get in cell AND navigate to others while inside
F2
Edit a cell from the outside
alt h-e
Add comments
