EXCEL CRASH COURSE
(ELABORATED) WITH
COMPLETE VERIFIED
SOLUTIONS GRADED A+ (2026
UPDATE)
Auto-width columns to fit the size - answer-Alt + H + O + I
Define width of columns - answer-Alt + H + O + W
Rename a worksheet - answer-ALT + H + O + R
Add worksheet - answer-Alt + H + I + S
Freeze and unfreeze panes - answer-Alt + W + F + F
Split pane - answer-Alt + W + S
Jump from split pane to split pane - answer-F6
To navigate outside the cell when in formula - answer-F2
Add comment - answer-Alt + N + C2
Delete Row/Column - answer-Ctrl -
Add row - answer-Ctrl + Shift + +
, Paste special - answer-Alt + E + S or Ctrl + Alt + V
Transpose - answer-Alt + E + S + E
How to get to date format "April-24" - answer-Go to Ctrl + 1, then Custom, then select
mm-yy
Remove all borders - answer-Ctrl + Shift + _
Trace precedents - answer-Alt + M + P
Trace dependents - answer-Alt + M + D
Remove arrows - answer-Alt + M + A
How to format inputs/hardcodes blue - answer-Go to special (Ctrl + G), then Custom,
select Constants and format text blue
Go to special - answer-Ctrl + G
Conditional formatting - answer-Alt + O + D or Alt + H + L
Custom formatting formula syntax - answer-[positive number format; negative number
format, 0 format]
How to out text after a number in custom formatting - answer-Use quote marks
(ELABORATED) WITH
COMPLETE VERIFIED
SOLUTIONS GRADED A+ (2026
UPDATE)
Auto-width columns to fit the size - answer-Alt + H + O + I
Define width of columns - answer-Alt + H + O + W
Rename a worksheet - answer-ALT + H + O + R
Add worksheet - answer-Alt + H + I + S
Freeze and unfreeze panes - answer-Alt + W + F + F
Split pane - answer-Alt + W + S
Jump from split pane to split pane - answer-F6
To navigate outside the cell when in formula - answer-F2
Add comment - answer-Alt + N + C2
Delete Row/Column - answer-Ctrl -
Add row - answer-Ctrl + Shift + +
, Paste special - answer-Alt + E + S or Ctrl + Alt + V
Transpose - answer-Alt + E + S + E
How to get to date format "April-24" - answer-Go to Ctrl + 1, then Custom, then select
mm-yy
Remove all borders - answer-Ctrl + Shift + _
Trace precedents - answer-Alt + M + P
Trace dependents - answer-Alt + M + D
Remove arrows - answer-Alt + M + A
How to format inputs/hardcodes blue - answer-Go to special (Ctrl + G), then Custom,
select Constants and format text blue
Go to special - answer-Ctrl + G
Conditional formatting - answer-Alt + O + D or Alt + H + L
Custom formatting formula syntax - answer-[positive number format; negative number
format, 0 format]
How to out text after a number in custom formatting - answer-Use quote marks
