Back to library
Microsoft Excel

Expand or collapse the formula bar

Toggle the formula bar between expanded and collapsed states to view or edit long formulas.

Ctrl + Shift + U

When to use it

When working with long formulas that are cut off in the default formula bar view.

Pro tip

Use this shortcut to quickly see the full formula without resizing the bar manually.

Esc F1 F2 F3 F4
F5 F6 F7 F8
F9 F10 F11 F12
PrtSc Scroll Pause
` ~ 1 ! 2 @ 3 # 4 $ 5 % 6 ^ 7 & 8 * 9 ( 0 ) - _ = +
Ins Home PgUp
Tab Q W E R T Y U I O P [ { ] } \ |
Del End PgDn
Caps A S D F G H J K L ; : ' " Enter
Shift Z X C V B N M , < . > / ? Shift
Ctrl Win Alt Space Fn Alt Ctrl

More from Microsoft Excel View all