New in Excel 2007, you can now make the formula bar higher.

Between the column letters and the formula bar there is a line. If you point to the line Excel displays a double-headed arrow. You can click, hold and drag the line down to expand the Formula Bar.

This is extremely useful to display long formula without the formula covering the spreadsheet entries.

Neale Blackwood is a senior business analyst with Access Analytic Solutions, which provides financial modelling, management reporting services, as well as advanced Excel training. You can email Neale at nblackwood@accessanalytic.com.au