Quick, clean, and to the point

Expand or collapse the formula bar

Windows shortcut 
Mac shortcut 

This shortcut will toggle the formula bar between a collapsed and uncollapsed state. It's useful when you have a very long formula, or have added line breaks to a formula for readability.

Related videos

The videos below demonstrate this shortcut.
In this lesson, we cover shortcuts you can use when building, editing, or entering formulas.

Download 200+ Excel Shortcuts

Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.