Microsoft Office Tutorials and References
In Depth Information
formula to other cells (copying this formula to the cell below), Excel automatically adjusts
the cell references in the formula and returns the correct results.
In order to work with a cell—to enter data in it, edit or move it, or perform an action—you
select the cell so it becomes the active cell. When you want to work with more than one
cell at a time—to move or copy them, use them in a formula , or perform any group ac-
tion—you must first select the cells as a range . A range can be contiguous (where selec-
ted cells are adjacent to each other) or non-contiguous (where the cells may be in differ-
ent parts of the worksheet and are not adjacent to each other). As you select a range, you
can see the range reference in the Name box. A range reference contains the cell address
of the top-left cell in the range, a colon (:), and the cell address of the bottom-right cell in
Select a Contiguous Range
Click the first cell that you want to include in the range.