Lesson for Day Twelve
In this lesson, we
will review and learn to:
Enter
multiple lines of text within one cell
Enter a formula
Tips on entering text
- In Microsoft Excel, text is
any combination of numbers, spaces, and nonnumeric characters — for
example, Microsoft Excel treats the following entries as text:
10AA109, 127AXY, 12-976, 208 4675.
- All text is left-aligned in
a cell. To change the alignment, click Cells on the Format
menu, click the Alignment tab, and then select the options you
want.
- To display all the text on
multiple lines in the cell, select the Wrap text check box on the Alignment
tab.
- To enter a "hard"
carriage return in a cell, press ALT+ENTER.
Entering Formulas .
- Click the cell in which you
want to enter the formula.
- Type = (an equal
sign).
If you click Edit Formula or Paste
Function Microsoft Excel inserts an
equal sign for you.
- Enter the formula.
- Press ENTER.
Tips
- You can enter the same
formula into a range of cells by selecting the range first, typing the
formula, and then pressing CTRL+ENTER.
- You can also enter a formula
into a range of cells by copying a formula from another cell.
Formula
terms