Hello Excellers welcome to another #formulafriday. 3ds emulator download mac free. 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.

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.

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 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.