Insert

The Insert menu contains commands for inserting new elements, such as images, text boxes, object, media, cell names and much more into the current sheet.

Image

Opens a file selection dialogue box to insert an image into the current document.

Chart

Inserts a chart.

Sparklines

Sparklines are small data charts displayed inside a cell.

Pivot Table - Select Source

Opens a dialogue box where you can select the source for your pivot table, and then create your table.

Media

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

OLE Object

Inserts an embedded or linked object into your document, including formulas, QR codes, and OLE objects.

Shape

This sub-menu contains common shapes like a line, circle, triangle and square, or a symbol shape like a smiley face, heart and flower that can be inserted into the document.

Function

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.

Text Box

Draws a text box with horizontal text direction where you drag in the current document. Drag a text box to the size you want anywhere in the document, and then type or paste your text. Rotate the text box to get rotated text.

Comment

Inserts a comment around the selected text, presentation slide, drawing page or at the current spreadsheet cursor position.

Floating Frame

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

Fontwork

Opens the Fontwork dialogue box from which you can insert styled text not possible through standard font formatting into your document.

Hyperlink

Opens a dialogue box that enables you to create and edit hyperlinks.

Special Character

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

Formatting Mark

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

Date

Inserts the current date in the cell.

Time

Inserts the current time in the cell.

Field

Opens a sub-menu for selecting the date, sheet name or document title in the cell.

Headers & Footers

Allows you to define and format headers and footers.

Form Control

This sub-menu contains form controls like a text box, check box, option button, and list box that can be inserted into the document.

Signature Line

Insert a graphic box representing a signature line of the document.