Microsoft Office Tutorials and References

In Depth Information

**Entering Data in a Worksheet**

Rows, columns, and cell addresses

Not that anyone needs them all, but an Excel worksheet has numerous columns

and more than 1 million rows. The rows are numbered, and columns are

labeled A to Z, then AA to AZ, then BA to BZ, and so on. The important thing

to remember is that each cell has an address whose name comes from a

column letter and a row number. The first cell in row 1 is A1, the second

is B1, and so on. You need to enter cell addresses in formulas to tell Excel

which numbers to compute.

To find a cell’s address, either make note of which column and row it lies in

or click the cell and glance at the Formula bar
(refer to Figure 1-2)
. The left

side of the Formula bar lists the address of the
active cell,
the cell that is

selected in the worksheet. In Figure 1-2, cell F7 is the active cell.

Workbooks and worksheets

By default, each workbook includes one worksheet, called Sheet1, but you

can add more worksheets. Think of a workbook as a stack of worksheets.

Besides calculating the numbers in cells across the rows or down the columns

of a worksheet, you can make calculations throughout a workbook by using

numbers from different worksheets in a calculation. Chapter 2 of this

minibook explains how to add worksheets, rename worksheets, and do all else

that pertains to them.

Book III

Chapter 1

Entering Data in a Worksheet

Entering data in a worksheet is an irksome activity. Fortunately, Excel offers

a few shortcuts to take the sting out of it. These pages explain how to enter

data in a worksheet, what the different types of data are, and how to enter

text labels, numbers, dates, and times.

The basics of entering data

What you can enter in a worksheet cell falls into four categories:

✦
Text

✦
A value (numeric, date, or time)

✦
A logical value (True or False)

✦
A formula that returns a value, logical value, or text

Still, no matter what type of data you’re entering, the basic steps are the same: