# How to Reduce the Size of Formula Bar in Excel (3 Ways)

Get FREE Advanced Excel Exercises with Solutions!

Reducing the size of the formula bar in Excel saves space for a clear view. The formula bar is located below the toolbar, which displays the contents of the active cell. While writing formulas in Excel, you might need to increase or reduce the size of the formula bar.

In this Excel tutorial, you will learn how to reduce the size of the formula bar in Excel using arrows, and a keyboard shortcut.

The following image illustrates reducing the size of the formula bar in Excel.

## 3 Ways to Reduce the Size of Formula Bar in Excel

Reducing the formula bar size will help you save extra space and provide a cleaner appearance. You can use the two-sided arrow, upward arrow, and keyboard shortcut to reduce the size of the formula bar.

Here we will apply 3 methods to reduce the size of the formula bar in Excel:

### Using the Two-Sided Arrow

To reduce the size of the formula bar with the two-sided arrow:

1. Place the cursor on the edge of the formula bar to get a two-sided arrow.
2. Drag that two-sided arrow upward.
As a result, the size of the formula bar will decrease.

### Using Upward Arrow

You can also use the upward arrow to reduce the size of the formula bar. To do so, click the upward arrow from the right corner of the formula bar.

If we click it once, the formula bar will expand upward. And if you click it again, the size of the bar will be normal again.

### Using Keyboard Shortcut

To reduce the size of the formula bar using the keyboard shortcut, press CTRL + SHIFT + U. You can use the shortcut to increase or decrease the size of the formula bar.

If we use this keyboard shortcut once, the formula bar will expand downward. And if you use it again, the size of the bar will be normal again.

## How to Increase or Decrease the Font Size of the Formula Bar

Changing the font size of the formula bar improves readability for complex formulas. To do so, follow the steps below:

1. Click on the FileÂ tab.
2. Next, click on Options.A new window will appear named Excel Options.
3. Go to General > When creating new workbooks > Font sizeÂ > 18Â > OK.A warning message will appear asking us toÂ Please close and restart Microsoft Excel so that the font changes can take effect.
4. Click OK.

Now, if we open the workbook again, we will see that the font size of the formula bar has increased to 18.

Note
If you change the font size of a particular worksheet, remember that the size will be effective for the rest of the workbooks and any workbook you will create after the change. You will have to change it to the default size if you do not want the font change to take effect in the other workbooks.

## Frequently Asked Questions

### Is it possible to wrap text in the formula bar?

The formula bar does not support text wrapping. If your formula or text is too long to fit, consider breaking it into multiple lines using Alt + Enter within the cell.

### Can I change the color of the text in the formula bar?

No, Excel does not provide native options to change the color of text in the formula bar. The text color in the formula bar is typically consistent with your overall Excel theme.

### Is there a way to lock the formula bar size to prevent accidental changes?

Unfortunately, Excel does not include a feature to lock the formula bar size. You can freely adjust its height based on your preferences.

## Related Articles

<< Go Back toÂ Excel Formula BarÂ |Â Excel PartsÂ |Â Learn Excel

## What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
ASM Arman

Abu Saleh Arman is a Marine engineer and Excel & VBA expert. He loves programming with VBA. He finds VBA programming a time-saving tool to manipulate data, handle files, and interact with the internet. He is very interested in Python, MATLAB, PHP, Deep Neural Networks, and Machine Learning, showcasing his diverse skill set. Arman holds a B.Sc in Naval Architecture & Marine Engineering from BUET, Bangladesh. However, he switched to a content developer, where he writes technical content... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF