編輯列印範圍

Opens a dialog where you can specify the print range. You can also set the rows or columns which are to be repeated in every page.

若要使用此指令...

From the menu bar:

Choose Format - Print Ranges - Edit.

From the tabbed interface:

Choose Layout - Edit tab.

On the Layout menu of the Layout tab, choose Print Ranges - Edit.

From toolbars:

Icon Edit Print Ranges

Edit Print Ranges


每頁列印出列或欄

定義工作表的列印範圍

列印範圍。

允許您修改已定義的列印範圍。

Select -none- to remove a print range definition for the current spreadsheet. Select -entire sheet- to set the current sheet as a print range. Select -selection- to define the selected area of a spreadsheet as the print range. By selecting -user-defined-, you can define a print range that you have already defined using the Format - Print Ranges - Define command. If you have given a name to a range using the Sheet - Named Ranges and Expressions - Define command, this name will be displayed and can be selected from the list box.

在右側的文字方塊中,您可以透過參照或名稱來輸入列印範圍。如果游標處於[列印範圍]文字方塊中,您還可以在試算表中使用滑鼠來選取列印範圍。

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

重複的列

選擇要列印於每一頁上的一列或多列。在右側的文字方塊中輸入列參照,例如「1」或「$1」或「$2:$3」。清單方塊會顯示 [-使用者定義的-]。您也可以選取 [-無-] 以移除定義的重複列。

如果游標處於對話方塊中的[重複的列]文字欄位中,您還可以透過在試算表中拖曳滑鼠來定義重複的列。

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

重複的欄

選擇要在每一頁上列印的一欄或多欄。在右側的文字方塊中輸入欄參照,例如 "A" 或 "AB" 或 "$C:$E"。然後清單方塊會顯示 [-使用者定義的-]。您也可以選取 [-無-] 來移除定義的重複欄。

如果游標處於對話方塊中的[重複的欄]文字欄位中,您還可以透過在試算表中拖曳滑鼠來定義重複的欄。

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

Please support us!