Microsoft Office Tutorials and References
In Depth Information
Entering Excel Data
Chapter 8
Creating a Basic Worksheet
Entering Excel Data
There’s an old adage that says “You
have to crawl before you can walk.” That
saying applies to Excel worksheets as well. You
need to learn the basics before you learn the more
complex Excel features. This section shows you
how to get the basic data into your worksheet.
Click the cell in which you want to place the label
and type the text. Press the Enter key and Excel
accepts the label and aligns the data along the left
edge of the cell. After pressing Enter, the cell
below the one in which you just entered data
becomes the current cell. If you make a mistake
and have not yet pressed the Enter key, press the
Backspace key to delete characters and type a
correction, or press the Escape key to cancel typing in
the selected cell.
Worksheet data is made up of three components:
labels, values, and formulas. This section discusses
entering labels and values, and you’ll learn about
creating and entering formulas in Chapter 9,
“Working with Formulas and Functions.” When you
are ready to enter data into a worksheet cell, you
must first click on the cell in which you want the
Movement Key Option
Optionally, instead of pressing the Enter key,
press the Tab key, which makes Excel move
to the right instead of down. Or, you can
press an arrow key instead of the Enter key,
which moves the next selection in the
direction of the arrow key.
Entering Labels
Labels are traditionally descriptive pieces of
information, such as names, months, or other
identifying information. Excel automatically recognizes
information as a label if it contains alphabetic
characters. Don’t worry if the entire label does not
appear to fit into a cell width. If needed, Excel
automatically extends the data past the cell width,
and you’ll soon discover how you can manually
widen a cell.
Figure 8-5 illustrates a worksheet with several
labels. Also notice that Excel displays the contents
of the current cell in the Formula bar.
Excel aligns the data to the left side of the cell. If
the descriptive information is too wide to fit in a
cell, Excel extends that data past the cell width as
long as the next cell is blank. If the next cell is not
blank, Excel displays only enough text to fit in the
current cell. Widening the column displays the
additional text.
Search JabSto ::

Custom Search