Microsoft Office Tutorials and References
In Depth Information
Excel has done a couple of things that you need to understand before entering more
data. First, the name of the customer in cell A2 has been cut off, or truncated. When you
enter more text than can be displayed within a cell, Excel will display the additional text
in the cell or cells to the right as long as they are empty. If the cells to the right are not
empty, Excel will truncate the display of the text when it encounters the first non-empty
cell. The text itself is not affected. The complete name of the first customer is still entered in
cell A2; it’s just not displayed.
Second, the customer address in cell B2 does not extend into cell C2, even though that
cell is empty. Instead, the height of row 2 has been increased to accommodate this text. If
a cell contains multiple lines of text, Excel increases the height of the row to display all of
the text entry. Note that the text in cell B2 “appears” to be on four lines, even though you
entered the address on two lines. Excel wrapped the text in this way so that it would fit
within the existing column width. Later in this session, you will learn how to adjust col-
umn widths and row heights to improve the worksheet’s appearance.
In Excel, dates are treated as numeric values, not text. This allows you to perform calcula-
tions with dates, such as determining the number of days between two dates. You’ll learn
how to work with date values in the next tutorial. For now, you need to know how to
enter a date. You can enter a date using any of the following date formats, which are rec-
ognized by Excel:
• April 16, 2006
The appearance of a date, regardless of how you enter it in a cell, depends on the date
format that has been set as the default in your version of Excel. For example, if you enter
the date as the text string “April 26, 2006,” Excel will automatically convert the entry to
“26-Apr-2006” if the DD-MMM-YYYY format has been set as the default. You will learn
about cell formats and date formats in Tutorial 3.
Sandra wants the date “4/16/2006” to appear in cell C2, so you will enter that next.
To insert the date in cell C2:
1. Verify that cell C2 is the active cell.
2. Type 4/16/2006 and then press the Tab key.
Trouble? If your computer is set up to display dates using a different date format, do not
worry about their appearance at this time.
3. Type Red Grapefruit in cell D2, and then press the Tab key. Note that the text in cell D2 is
completely displayed because, at this point, the cells to the right of D2 are still empty.