This Excel tips video will show you how to Resize 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 is not easy. It can often block part of your worksheet. In Excel 2007 onwards, it addressed in more recent versions with a resizable formula bar!!.
If you are writing a long formula that is longer than the standard default size, you can resize the Excel formula bar in two ways.
Method 1.
Place the cursor at the bottom of the formula bar and see the twin-sided white arrow. You can drag the formula bar to make it larger or smaller using this arrow.
Method 2.
Click the arrow at the right side of the formula bar.
Of course there is an Excel shortcut to do this. Its is CTRL+SHIFT+U. To restore the bar again just hit the shortcut again. Why not give this a go and practice resizing the bar.
