Page 114 - Excel 2007 Bible

09_044039 ch05.qxp 11/21/06 10:56 AM Page 71
Working with Cells
and Ranges
ost of the work you do in Excel involves cells and ranges.
Understanding how best to manipulate cells and ranges will save you IN THIS CHAPTER
Mtime and effort. This chapter discusses a variety of techniques that you Understanding Excel’s cells and
can use to help increase your efficiency.
ranges
Selecting cells and ranges
Understanding Cells and Ranges
Copying or moving ranges
A cell is a single element in a worksheet that can hold a value, some text, or a for- Using names to work with
mula. A cell is identified by its address, which consists of its column letter and
row number. For example, cell D12 is the cell in the fourth column and the ranges
twelfth row.
Adding comments to cells
A group of cells is called a range. You designate a range address by specifying its
upper-left cell address and its lower-right cell address, separated by a colon.
Here are some examples of range addresses:
C24 A range that consists of a single cell.
A1:B1 Two cells that occupy one row and two
columns.
A1:A100 100 cells in column A.
A1:D4 16 cells (four rows by four columns).
C1:C1048576 An entire column of cells; this range
also can be expressed as C:C.
A6:XFD6 An entire row of cells; this range also
can be expressed as 6:6.
A1:XFD1048576 All cells in a worksheet.

71