1. In Excel 12 , we've redesigned the formula bar to be both flexible and less intrusive.

2. As users resize the formula bar, it pushes down the grid instead of overlapping it, so that spreadsheet content is never obscured.

3. Meet the Excel 12 formula bar, or " don't hijack my grid! "

4. When this is checked, the cell is still visible. However, its contents do not appear in the Formula bar.

5. If you have named a range of cells on a worksheet, you can go to that range if you click the arrow to the left of the formula bar and select the name.

6. Another piece of feedback we heard from users about the formula bar was that the name box was not big enough to display long range names.

7. To display more cell content, users just need to adjust the height of the formula bar.

8. To review the names in a workbook, use the Name box on the Formula Bar, or click a cell in a blank area, point to Name on the Insert menu, click Paste, and then click Paste List.

9. If the cell contains a formula, this property returns the formula as a string, in the same format in which it would be displayed in the formula bar (including the equal sign).

10. However,[/formula bar.html] you can still see the formula in the formula bar field.

11. In order to display text in the active cell, the formula bar would spill into the sheet, often resulting in obscured column headers and sheet content.

12. If you need help choosing a function and entering its arguments, click the Edit Formula button on the Formula bar.