Excel 简明教程

Using Ranges in Excel 2010

Ranges in MS Excel

单元格是工作表中的一个单一元素，可以包含值、一些文本或公式。单元格由其地址标识，该地址包含其列字母和行号。例如，单元格 B1 是位于第二列和第一行的单元格。

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 B1 is the cell in the second column and the first 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.

区域的示例 −

Example of Ranges −

  1. C24 − A range that consists of a single cell.

  2. A1:B1 − Two cells that occupy one row and two columns.

  3. A1:A100 − 100 cells in column A.

  4. A1:D4 − 16 cells (four rows by four columns).

Selecting Ranges

您可以通过多种方式选择一个区域 −

You can select a range in several ways −

  1. Press the left mouse button and drag, highlighting the range. Then release the mouse button. If you drag to the end of the screen, the worksheet will scroll.

  2. Press the Shift key while you use the navigation keys to select a range.

  3. Press F8 and then move the cell pointer with the navigation keys to highlight the range. Press F8 again to return the navigation keys to normal movement.

  4. Type the cell or range address into the Name box and press Enter. Excel selects the cell or range that you specified.

range intro

Selecting Complete Rows and Columns

当你需要选择整行或整列时。你可以选择整行和整列，这种方式与选择区域的方式基本相同 −

When you need to select an entire row or column. You can select entire rows and columns in much the same manner as you select ranges −

  1. Click the row or column border to select a single row or column.

  2. To select multiple adjacent rows or columns, click a row or column border and drag to highlight additional rows or columns.

  3. To select multiple (nonadjacent) rows or columns, press Ctrl while you click the row or column borders that you want.

selected complete