How to Use Cell Ranges in Excel Formulas

When creating formulas in Microsoft Excel 2000, you can indicate a range instead of specifying each individual cell to use.

Instructions

Difficulty: Moderate

Things You’ll Need:

• Excel Book
• Microsoft Excel

1. Begin your formula by clicking in the cell you want the formula to go in.
2. Type an equal sign (=).
3. Use the following syntax to refer to a range of cells in a single column: B13:B25. (This indicates cell B13 through cell B25.)
4. Type a similar construction to indicate a range of cells in a single row: A12:F12.
5. Use the following shortcut to refer to all the cells in a column: D:D. For a series of columns, you'd use something like D:H. Similarly, to indicate rows 3 through 18, you'd use 3:18.
6. Add a formula for summing a column of cells, for example: =SUM(B3:B10).
7. Press Enter to finalize the formula.

Tips & Warnings

• You can name cells or ranges to make formulas easier to understand. (See Related eHows.)

Who Can Help:

• Find Computer, Electrical and Telephone Services Here. Compare Up to 4 Quotes, Free Service & No Obligation.
• Find Electrical Services Here. Compare Up to 4 Quotes, Free Service & No Obligation.