Insert

The Insert menu contains commands for inserting new elements, such as cells, rows, sheets and cell names into the current sheet.

Manual 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.

Cells

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

Rows

Inserts a new row above the active cell. The number of rows inserted correspond to the number of rows selected. The existing rows are moved downward.

Columns

Inserts a new column to the left of the active cell.The number of columns inserted correspond to the number of columns selected. The existing columns are moved to the right.

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.

Sheet from file

Inserts a sheet from a different spreadsheet file.

Link to External Data

Inserts data from an HTML, Calc, or Excel file into the current sheet as a link. The data must be located within a named range.

Special Character

Inserts special characters from the installed fonts.

Formatting Mark

Opens a submenu to insert special formatting marks.

Hyperlink

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

Function

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

Function List

This command opens the Function List window, which displays all functions that can be inserted into your document.

Names

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.

Note

Inserts a note at the current cursor position. To view or edit the contents of a note, select the note and choose this command.

Picture

Select the source for a picture that you want to insert.

Movie and Sound

Inserts a video or sound file into your document.

Object

Inserts an object into your document. For movies and sounds, use Insert - Movie and Sound instead.

Chart

Creates a chart in the current document. To use a range of cells as the data source for your chart, select the cells, and then choose this command.

Floating Frame

Inserts a floating frame into the current document. Floating frames are used in HTML documents to display the contents of another file. Floating frames are not supported by Netscape Navigator 4.x.

Index

spreadsheets, inserting breaks in

inserting, breaks

page breaks, inserting in spreadsheets

spreadsheets, inserting rows

rows, inserting

inserting, rows

spreadsheets, inserting columns

inserting, columns

columns, inserting

inserting,movies/sounds

sounds,inserting and playing

playing movies and sound files

videos

audio, inserting

This help text is published from the OpenOffice-Help files under the Public Documentation License 1.0.