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.
Search JabSto ::




Custom Search