Excel like a finance pro.
← The libraryPractice · 2 questions →
Formulas shortcut
Expand or collapse the formula bar
Ctrl + Shift + U on Windows, Ctrl + Shift + U on Mac.
OccasionalDifficulty 1000 · Capable
When to use it
Expands or collapses the formula bar so long formulas show on several lines.
The shape of it
- Windows
Ctrl + Shift + U
- Mac
Ctrl + Shift + U
Worked examples
Expand
Select a long formula, Ctrl + Shift + U → The formula bar grows to show it all
Read long formulas.
Collapse
Ctrl + Shift + U again → Back to one line
Collapse.
Multi-line formulas
Alt + Enter inside the formula, then Ctrl + Shift + U → Line breaks visible
Formatted formulas.
Worth knowing
- Drag the bottom edge of the formula bar for a custom height.
- Break long formulas with Alt + Enter and spaces for readability.
- LET makes long formulas shorter.
Where it goes wrong
- Easy to confuse with Ctrl + U (underline).
- The expanded bar hides the first rows of the sheet.
Related
Learn the moves here — or let Wauvel run them on your numbers.
Meet your AI CFO →One CFO-grade Excel tip a week
A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.