AND ANSWERS 2026 GRADED A+
⩥ 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