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:
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:
Search JabSto ::

Custom Search