Insert

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

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.

Sheet from file

Inserts a sheet from a different spreadsheet file.

Link to External Data

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.

Allows a user to insert characters from the range of symbols found in the installed fonts.

Formatting Mark

Opens a submenu to insert special formatting marks like non-breaking space, soft hyphen, and optional break.

Opens a dialog that enables you to create and edit hyperlinks.

Opens the Function Wizard, which helps you to interactively create formulas.

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.

Inserts a comment around the selected text or at the current cursor position.

Media

The submenu presents various sources that an image, audio or video can be insert from.

Audio or Video

Inserts a video or audio file into your document.

Object

Inserts an embedded object into your document, including formulas, 3D models, charts and OLE objects.

Inserts a floating frame into the current document. Floating frames are used in HTML documents to display the contents of another file.

Headers & Footers

Allows you to define and format headers and footers.