Most of the work you do in Excel involves cells and ranges. Understanding how best to manipulate cells and ranges will save you time and effort. This chapter discusses a variety of techniques that you can use to help increase your efficiency.
A cell is a single element in a worksheet that can hold a value, some text, or a formula. 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 twelfth row.
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:
A range that consists of a single cell.
Two cells that occupy one row and two columns.
100 cells in column A.
16 cells (four rows by four columns).
An entire column of cells; this range also can be expressed as C:C.
An entire row of cells; this range also can be expressed as 6:6.
All cells in a worksheet.
To perform an operation on a range of cells in a worksheet, you must first select the range. For example, if you want to make the text bold for a range of cells, you must ...