工作表
此功能表含有修改與管理工作表與其元素的指令。
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.
此指令插入手動斷列或斷欄,以確保資料被正確列印。您可以在使用中的儲存格上方插入水平分頁,或在左側插入垂直分頁。
完全刪除所選的儲存格、欄或列。刪除的儲存格其下方或右方的儲存格將以空格填入。 請注意所選的刪除選項會自動儲存,您下次呼叫刪除功能時將自動還原設定。
Deletes the selected rows.
Deletes the selected columns.
定義要用來插入新工作表的選項。您可已建立新的工作表,或是從檔案插入現有的工作表。
Adds a new sheet at end of the spreadsheet document.
Inserts a sheet from a different spreadsheet file.
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.
Deletes the current sheet or selected sheets.
Clear Cells
指定要從使用中儲存格或選取的儲存格範圍中刪除的內容。如果已選取數個試算表,所有選取的試算表都將受到影響。
Cycles between absolute and relative addressing of cell reference in the formula.
允許您命名試算表文件的不同區域。 透過命名不同區域,您可以輕鬆地瀏覽整個試算表文件,並尋找特定資訊。
允許您命名試算表文件的不同區域。 透過命名不同區域,您可以輕鬆地瀏覽整個試算表文件,並尋找特定資訊。
Opens a submenu with comments commands.
此指令會開啟對話方塊讓您對目前試算表指定不同的名稱。
Displays sheets that were previously hidden with the Hide Sheets command.
Opens a submenu to navigate between sheets.
Opens a color selector window where you can assign a color to the sheet tab.
LibreOffice Calc specific sheet events. You can assign a macro to each sheet event.