Microsoft Office Tutorials and References

In Depth Information

**Resize the Formula Bar**

Timesaver

To wrap text in a cell, press Alt+Enter, which manually inserts a line

break.

For Your Information: Understanding Order of Precedence

Formulas containing more than one operator follow the order of preced-

ence: exponentiation, multiplication and division, and then addition and

subtraction. So, in the formula 5 + 2 * 3, Excel performs multiplica-

tion first and addition next for a result of 11. Excel calculates operations

within parentheses first. The result of the formula (5 + 2) * 3 is 21.

Resize the Formula Bar

• To switch between expanding the formula box to three or more lines or collapsing

it to one line, click the down/up arrow at the end of the formula bar. You can also

press Ctrl+Shift+U.

• To precisely adjust the height of the formula box, point to the bottom of the for-

mula box until the pointer changes to a vertical double arrow, and then drag up or

down, and then click the vertical double arrow or press Enter.

• To automatically fit the formula box to the number of lines of text in the active

cell, point to the formula box until the pointer changes to a vertical double arrow,

and then double-click the vertical arrow.