Microsoft Office Tutorials and References
In Depth Information
Speed Techniques for Entering Formulas
To identify a cell range, Excel lists the outermost cells in the range and
places a colon (:) between cell addresses:
✦ A cell range comprising cells A1, A2, A3, and A4 is listed this way: A1:A4.
✦ A cell range comprising a block of cells from A1 to D4 is listed this way:
You can enter cell ranges on your own without selecting cells. To do so, type
the first cell in the range, enter a colon (:), and type the last cell.
Naming cell ranges so that you
can use them in formulas
Whether you type cell addresses yourself or drag across cells to enter a cell
range, entering cell address references is a chore. Entering =C1+C2+C3+C4 ,
for example, can cause a finger cramp; entering =SUM(C1:C4) is no piece of
To take the tedium out of entering cell ranges in formulas, you can name cell
ranges. Then, to enter a cell range in a formula, all you have to do is select
a name in the Paste Name dialog box or click the Use in Formula button on
the Formulas tab, as shown in Figure 3-7. Naming cell ranges has an added
benefit: You can choose a name from the Name Box drop-down list and go
directly to the cell range whose name you choose, as shown in Figure 3-7.