Fill Sheets

指定将某些工作表或某个工作表中的单元格区域转移到其他已选中的工作表时所采用的选项。

To select multiple sheets, click each sheet tab while pressing or Shift.

与将某个区域复制到剪贴板相比，该命令可以筛除特定的信息，并可以进行数值计算。

填充一个工作表

• 点击工作表左上角空白的灰色框可以选中整个工作表。也可以选择工作表的某个区域进行复制。

• Press and click the tab of the sheet where you want to insert the contents.

• Select the command Sheet - Fill Cells - Sheets. In the dialog which appears, the check box Numbers must be selected (or Paste All) if you want to combine operations with the values. You can also choose the desired operation here.

• 点击「确定」。

This dialog is similar to the Paste Special dialog, where you can find additional tips.