The Formula Bar in Microsoft Excel can be enlarged to make more room for lengthy formulas. This can be done by dragging the top border of the Formula Bar up or down. To do this, first click on the small triangle in the top right corner of the Formula Bar. Then, while holding down the left mouse button, drag the border up or down.

If you want to make even more room for lengthy formulas, you can hide the row and column headers. To do this, go to the View tab on the Ribbon and click on the Header & Footer button. In the Header & Footer dialog box, uncheck the Row and Column Headers checkboxes.