Please support us!

套用多個工作表

You can select multiple sheets to apply commands and calculate across them.

選取多個試算表

The sheet tab of the current sheet is always visible in white in front of the other sheet tabs. The other sheet tabs are gray when they are not selected. By clicking other sheet tabs while pressing you can select multiple sheets.

您可以利用鍵盤,使用 Shift++Page Up 或 Page Down 選取多個工作表。

評註圖示

An information bar warns you that some hidden sheets are selected in addition to the visible ones. You can deselect these hidden sheets with the button provided.


復原選取區塊

To undo the selection of a sheet, click its sheet tab again while pressing the key. The sheet that is currently visible cannot be removed from the selection.

Deselect all

跨多個試算表計算

您可藉由指定範圍的第一和最後的試算表以在公式中表示試算表的範圍,例如 =SUM(Sheet1.A1:Sheet3.A1) 總計試算表 1 至試算表 3 的所有儲存格。