Datasheet

•

Enter Text

1 Click a cell.

Note: See Chapter 4 for more

on selecting cells.

2 Type text.

•

As you type, the

information appears both

in the cell and in the

Formula Bar.

3 Click .

Note: If you press Enter, Excel

stores the information but moves

the active cell down one cell.

•

The active cell continues

to be the cell you selected

in step 1, and the text you

typed appears left-aligned.

4 Repeat steps 1 to 3 to

enter other text labels.

Enter Information

ou can quickly and easily type text and

numbers into your worksheet. Most people

use Excel primarily to accomplish math-related

tasks, and supplying text labels for the numbers you

enter provides meaning to those tasks. Although you

can type information into a worksheet in any order,

some people find it easier to type labels first because

they help users identify the correct place for

corresponding numbers.

You enter text by using your keyboard, and you can

enter numbers by using either the number keys above

the letters on your keyboard or the number pad to the

right of the letters on your keyboard. To use the

numbers on the number pad, you must press the

Num Lock key.

By default, when you enter text into a cell, Excel

left-aligns it in the cell and assigns it a General

format. When you enter a number into a cell, Excel

right-aligns it in the cell and assigns it a General

format. Excel also recognizes some dates that you

type; as a result, it right-aligns them in cells and

formats them as dates. Information in a selected cell

appears both in the cell and in the Formula Bar. For