Easily Expand or Collapse the Formula Bar in Excel
by Avantix Learning Team | Updated August 1, 2020
Applies to: Microsoft® Excel® 2007, 2010, 2013, 2016, 2019 and 365 (Windows)
In Microsoft Excel, the Formula Bar normally appears below the Ribbon. When you enter data or a formula, it appears in the Formula Bar. If you are writing longer formulas, it can be helpful to expand the Formula Bar using the following techniques.
Recommended article: 10 Great Excel Navigation Shortcuts
Display the Formula Bar
If the Formula Bar is not displayed:
- Click the View tab in the Ribbon.
- Select the Formula Bar check box.
Alternatively, you can display the Formula Bar using Excel Options:
- Click the File tab in the Ribbon or the Office button (2007).
- Select Options or Excel Options (2007).
- In the left pane, click Advanced.
- In the right pane, select (or check) Show formula bar in the Display area.
- Click OK.
Expand or collapse the Formula Bar using a mouse
To expand the Formula Bar using a mouse:
- Position the mouse pointer near the bottom of the Formula Bar until an up and down arrow appears.
- Hold down the left mouse button and drag down until the bar is the size you want. Drag up to return it to the original size.
Below is an expanded Formula Bar:
Expand or collapse the Formula Bar using a keyboard shortcut
To expand or collapse the Formula Bar using a keyboard shortcut:
- Press Ctrl + Shift + U.
This is a great way to work with longer formulas in Excel.
This article was first published on August 6, 2015 and has been updated for clarity and content.
Did you find this article helpful? If you would like to receive new articles, join our email list.
Recommended Microsoft Excel training
Our instructor-led classroom training courses are delivered at our downtown Toronto location at 1 Yonge Street, Suite 1801 (Toronto Star Building), Toronto, Ontario, Canada. Contact us if you’d prefer to arrange custom training at your location.
To request this page in an alternate format, contact us.
Copyright 2020 Avantix® Learning
You may also like
You can hide comments and notes in Excel workbooks. In addition to adding comments in Excel, there is a little known function called the N function that you can use to enter notes directly within a formula. The N function has been around for a long time so you can use it in older versions of Excel.
You can delete blank rows in Microsoft Excel worksheets manually or you can use several tricks to delete multiple blank rows quickly. First, it’s essential that Excel users know how to select rows quickly using shortcuts or by using Excel commands such as Go to Special, Filter and Sort.
Moving a pivot table is not as simple as moving other objects in an Excel worksheet or workbook. You will typically need to use the Move PivotTable command in the Ribbon to move a pivot table to a different area on a worksheet or to a different sheet in the same workbook.
Avantix Learning | 1 Yonge Street, Suite 1801 (Toronto Star Building), Toronto, Ontario, Canada M5E 1W7 | email@example.com