Hello Excellers welcome to another **#formulafriday.** Let’s look at how to see more (or less) of your Excel formulas by resizing the Excel Formula Bar.

In versions of Excel earlier than 2007, editing a cell that has a lengthy formula or a cell containing lots of text can often block part of your worksheet. In Excel 2007 onwards this has at last been addressed with a resizable formula bar!!.

If you are writing a very long formula which is longer than the standard default formula bar size then you can resize it in two ways

- Place the cursor at the bottom of the formula bar and you will see the twin sided white arrow. You can drag the formula bar to make it larger or smaller using this arrow.

- Click the arrow at the right side of the formula bar.

### Want To Use The Keyboard Shortcut?.

Of course there is an Excel shortcut to do this. Its is **CTRL+SHIFT+U. **To restore the Formula Bar again just hit the shortcut again.

#### If you want more Excel and VBA tips then sign up to my monthly Newsletter where I share 3 Excel Tips on the first Wednesday of the month and receive my free Ebook, 30 Excel Tips.

#### If you want to see all of the blog posts in the Formula Friday series you can do so by clicking on the link below.

### How To Excel At Excel – Formula Friday Blog Posts.

tina kurfurst says

Is there a way to increase the size of the text in the formula bar? I’m spending a lot of time cutting/pasting text from one cell to another. Some of the text in the first cell is quite long, so the “make the box bigger” trick is nice, but text is still small. I’m viewing the worksheet at 125%, but I haven’t figured out how to show the formula bar contents at 125%. Is it possibe?

Barbara says

Hi Tina

Good question.

In Excel 2007

Home Tab

Excel Options

Popular Tab

Change the default font and size at Standard Font

Close and restart Excel for the changes to become effective.

Hope that helps

Barbara

Peter Casey says

I created a video about changing the font size of the formula bar and still having normal size row and column headings and normal cell font size.

http://www.youtube.com/watch?v=SlepQ-eS5gY

I might improve the technique with the hint of both a book template and a sheet template.