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.