工作表

此功能表含有修改與管理工作表與其元素的指令。

若要使用此指令...

From the menu bar:

Choose Sheet.


Insert Cells

Opens the Insert Cells dialog, in which you can insert new cells according to the options that you specify.

插入...

Insert rows above or below the active cell. The number of rows inserted corresponds to the number of rows selected. If no row is selected, one row is inserted. The existing rows are moved downward.

Inserts columns to the left or to the right of the active cell. The number of columns inserted corresponds to the number of columns selected. If no column is selected, one column is inserted. The existing columns are moved to the right.

Insert Page Break

此指令插入手動斷列或斷欄,以確保資料被正確列印。您可以在使用中的儲存格上方插入水平分頁,或在左側插入垂直分頁。

Delete Cells

完全刪除所選的儲存格、欄或列。刪除的儲存格其下方或右方的儲存格將以空格填入。 請注意所選的刪除選項會自動儲存,您下次呼叫刪除功能時將自動還原設定。

Deletes the selected rows.

Deletes the selected columns.

刪除分頁符

選擇要刪除的分頁類型。

Insert Sheet

定義要用來插入新工作表的選項。您可已建立新的工作表,或是從檔案插入現有的工作表。

Insert Sheet at End

Adds a new sheet at end of the spreadsheet document.

Insert Sheet from file

Inserts a sheet from a different spreadsheet file.

External Links

Inserts data from an HTML, Calc, CSV or Excel file into the current sheet as a link. The data must be located within a named range.

Delete Sheet

Deletes the current sheet or selected sheets.

Clear Cells

指定要從使用中儲存格或選取的儲存格範圍中刪除的內容。如果已選取數個試算表,所有選取的試算表都將受到影響。

Cycle Cell Reference Types

Cycles between absolute and relative addressing of cell reference in the formula.

Fill Cells

自動用內容填入儲存格。

Named Ranges and Expressions

允許您命名試算表文件的不同區域。 透過命名不同區域,您可以輕鬆地瀏覽整個試算表文件,並尋找特定資訊。

Named Ranges and Expressions

允許您命名試算表文件的不同區域。 透過命名不同區域,您可以輕鬆地瀏覽整個試算表文件,並尋找特定資訊。

Sheet Comment Menu

Opens a submenu with comments commands.

Rename Sheet

此指令會開啟對話方塊讓您對目前試算表指定不同的名稱。

Hide Sheet

Hides the sheet.

Show Sheet

Displays sheets that were previously hidden with the Hide Sheets command.

Navigate Menu

Opens a submenu to navigate between sheets.

Sheet Tab Color

Opens a color selector window where you can assign a color to the sheet tab.

Sheet Events

LibreOffice Calc specific sheet events. You can assign a macro to each sheet event.

Please support us!