Sheet

This menu contains commands to modify and manage a sheet and its elements.

To access this command...

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

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.

Insert Columns

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

This command inserts manual row or column breaks to ensure that your data prints properly. You can insert a horizontal page break above, or a vertical page break to the left of, the active cell.

Delete Cells

Completely deletes selected cells, columns or rows. The cells below or to the right of the deleted cells will fill the space. Note that the selected delete option is stored and reloaded when the dialog is next called.

Deletes the selected rows.

Deletes the selected columns.

Delete Page Break

Choose the type of page break that you want to delete.

Insert Sheet

Defines the options to be used to insert a new sheet. You can create a new sheet, or insert an existing sheet from a file.

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

Specifies the contents to be deleted from the active cell or from a selected cell range. If several sheets are selected, all selected sheets will be affected.

Cycle Cell Reference Types

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

Fill Cells

Automatically fills cells with content.

Named Ranges and Expressions

Allows you to name the different sections of your spreadsheet document. By naming the different sections, you can easily navigate through the spreadsheet documents and find specific information.

Named Ranges and Expressions

Allows you to name the different sections of your spreadsheet document. By naming the different sections, you can easily navigate through the spreadsheet documents and find specific information.

Sheet Comment Menu

Opens a submenu with comments commands.

Rename Sheet

This command opens a dialog where you can assign a different name to the current 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!