Microsoft Office Tutorials and References
In Depth Information
Learning the Layout of a Worksheet
Learning the Layout
of a Worksheet
In Excel, a spreadsheet file is called a workbook , and
each workbook consists of one or more worksheets .
These worksheets are where you enter your data and
formulas, so you need to know the layout of a typical
In particular, you need to know that worksheets are
laid out in rows and columns, that a cell is the
intersection of a row and column that has its own
unique address, and that a range is a collection of
cells. You also need to be familiar with worksheet
tabs and the Excel mouse pointer.
A cell is a box in which you enter
your spreadsheet data.
A column is a vertical line of cells.
Each column has a unique letter that
identifies it. For example, the
leftmost column is A, and the next
column is B.
A row is a horizontal line of
cells. Each row has a unique
number that identifies it. For
example, the topmost row is 1,
and the next row is 2.
D Cell Address
Each cell has its own
address, which is
determined by the letter
and number of the
intersecting column and
row. For example, the cell
at the intersection of
column C and row 10 has
the address C10.
A range is a rectangular grouping of two or more
cells. The range is indicated by the address of the
top-left cell and the address of the bottom-right
cell. H12:K16 is an example of a range of cells, and
it refers to all the cells selected between column H,
row 12 and column K, row 16.
F Worksheet Tab
The worksheet tab displays the
worksheet name. Most workbooks
contain multiple worksheets, and
you use the tabs to navigate
between the worksheets.
Use the Excel
mouse pointer (
to select cells.