āĻļ⧁āϰ⧁

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

āĻāχ āύāĻŋāĻ°ā§āĻĻ⧇āĻļāĻžāĻŦāϞ⧀āϤ⧇ āϏāĻ¨ā§āύāĻŋāĻŦ⧇āĻļ āĻ•āϰāϤ⧇...

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

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.

āύāĻŋāĻ°ā§āĻŦāĻžāϚāĻŋāϤ āϏāĻžāϰāĻŋāϏāĻŽā§‚āĻš āĻŽā§āϛ⧇ āĻĢ⧇āϞāĻž āĻšā§ŸāĨ¤

āύāĻŋāĻ°ā§āĻŦāĻžāϚāĻŋāϤ āĻ•āϞāĻžāĻŽāϏāĻŽā§‚āĻš āĻŽā§āϛ⧇ āĻĢ⧇āϞāĻž āĻšā§ŸāĨ¤

Delete Page Break

āφāĻĒāύāĻŋ āϝ⧇ āϧāϰāύ⧇āϰ āĻ¸ā§āĻŦāύāĻŋāĻ°ā§āϧāĻžāϰāĻŋāϤ āĻŦāĻŋāĻ­āĻžāϜāĻ• āĻŽā§āϛ⧇ āĻĢ⧇āϞāϤ⧇ āϚāĻžāύ āϤāĻž āύāĻŋāĻ°ā§āĻŦāĻžāϚāύ āĻ•āϰ⧁āύāĨ¤

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

āϏāĻ•ā§āϰāĻŋāϝāĻŧ āϘāϰ āĻŦāĻž āύāĻŋāĻ°ā§āĻŦāĻžāϚāĻŋāϤ āϘāϰ⧇āϰ āĻĒāϰāĻŋāϏ⧀āĻŽāĻž āĻĨ⧇āϕ⧇ āĻŽā§āϛ⧇ āĻĢ⧇āϞāĻžāϰ āϜāĻ¨ā§āϝ āĻŦāĻŋāώāϝāĻŧāĻŦāĻ¸ā§āϤ⧁ āωāĻ˛ā§āϞ⧇āĻ– āĻ•āϰ⧇āĨ¤ āϝāĻĻāĻŋ āĻāĻ•āĻžāϧāĻŋāĻ• āĻļā§€āϟ āύāĻŋāĻ°ā§āĻŦāĻžāϚāύ āĻ•āϰāĻž āĻšāϝāĻŧ, āϏāĻ•āϞ āύāĻŋāĻ°ā§āĻŦāĻžāϚāĻŋāϤ āĻļā§€āϟ āĻĒā§āϰāĻ­āĻžāĻŦāĻŋāϤ āĻšāĻŦ⧇āĨ¤

Cycle Cell Reference Types

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

Fill Cells

āϘāϰāϏāĻŽā§‚āĻš āĻ¸ā§āĻŦāϝāĻŧāĻ‚āĻ•ā§āϰāĻŋāϝāĻŧāĻ­āĻžāĻŦ⧇ āĻŦāĻŋāώāϝāĻŧāĻŦāĻ¸ā§āϤ⧁ āĻĻā§āĻŦāĻžāϰāĻž āĻĒā§‚āϰāĻŖ āĻ•āϰ⧇āĨ¤

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

āĻāχ āĻ•āĻŽāĻžāĻ¨ā§āĻĄ āĻāĻŽāύ āĻāĻ•āϟāĻŋ āĻĄāĻžāϝāĻŧāĻžāϞāĻ— āĻ–ā§‹āϞ⧇, āϝ⧇āĻ–āĻžāύ⧇ āφāĻĒāύāĻŋ āĻŦāĻ°ā§āϤāĻŽāĻžāύ āĻļā§€āĻŸā§‡āϰ āĻāĻ•āϟāĻŋ āĻ­āĻŋāĻ¨ā§āύ āύāĻžāĻŽ āύāĻŋāĻ°ā§āϧāĻžāϰāĻŖ āĻ•āϰāϤ⧇ āĻĒāĻžāϰāĻŦ⧇āύāĨ¤

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!