Define Range

借助工作表中选中的单元格来定义数据库范围。

note

只能选择矩形的数据库区域。


要访问此命令...

From the menu bar:

选择「数据 - 定义区域」。

From the tabbed interface:

Choose Data - Define Range.

On the Data menu of the Data tab, choose Define Range.

From toolbars:

Icon Define Range

Define Range


名称

输入要定义的数据库区域的名称,或者从列表中选择一个现有名称。

区域

显示选中的单元格区域。

Shrink / Expand

Click the Shrink icon to reduce the dialog to the size of the input field. It is then easier to mark the required reference in the sheet. The icons then automatically convert to the Expand icon. Click it to restore the dialog to its original size.

当您在工作表中点击鼠标按钮并拖动一个区域时,对话框自动缩小。一旦您放开鼠标按钮,对话框便重新用完整大小显示,而用鼠标定义的区域引用在文档中用一个蓝色的边框被突出强调出来。

Icon shrink

缩小

Icon Expand

Expand

添加/修改

将选中的单元格区域加入数据库范围列表,或者修改现有的数据库范围。

删除

确认后删除选中元素。

Options

Contains column labels

Selected cell ranges contains labels.

Contains totals row

The database range has a row for totals.

Insert or delete cells

Automatically inserts new rows and columns into the database range in your document when new records are added to the database. To manually update the database range, choose Data - Refresh Range.

Keep formatting

Applies the existing cell format of headers and first data row to the whole database range.

Don't save imported data

Only saves a reference to the database, and not the contents of the cells.

Source:

Displays information about the current database source and any existing operators.

Operations:

Denotes what operations (if any) have been applied to the database range. For example, “Sort”, “Filter”, or “Subtotals”.

请支持我们!