Microsoft Office Tutorials and References

In Depth Information

**Entering Excel Data**

Anything you can type into
a

worksheet’s cell can be called data. Whenever you

type something into a cell, Excel tries to

determine what type of data it is. Excel recognizes

three specific types of data: labels (or text),

values (or numbers), and formulas (or equations).

Formulas are introduced in Chapter 2, “Working

with Formulas,” so for now you’ll spend time

learning the differences between labels and

values.

Entering Data into a Cell

Regardless of the type of data you want

to enter, all data is entered in Excel the

same way.

1.
Select the cell in which you want to

type.

2.
Type the information you want into

the cell.

3.
Press Enter or Tab to accept your data

entry and move to the next cell.

Perhaps you are creating a spreadsheet that

details the number of days in each month of the

year, as in Figure 1-12. The month names are

labels, the days are values, and the total number

of days is calculated by Excel using a formula.

Entering Labels

Labels can also be thought of as information

about the numerical data in Excel. Excel assumes

that any data containing letters is a label and will

format it accordingly. Labels are left-aligned in the

cell, and cannot be calculated using a formula.

All About Cell Width

By default, the standard width of a cell is

8.43. According to Microsoft, this means

that 8.43 characters will ﬁt into the cell. If

your label has more than 8.43 characters,

Excel automatically extends the data you

typed beyond the cell’s right border. You will

learn how to resize the cells in Chapter 5,

“Making the Worksheet Look Good.”

Figure 1-12

A spreadsheet that includes labels,

values, and a formula.