Text Documents (Writer)
HTML Documents (Writer Web)
Spreadsheets (Calc)
Presentations (Impress)
Drawings (Draw)
Database Functionality (Base)
Formulae (Math)
Charts and Diagrams
Macros and Scripting
Office Installation
Common Help Topics
OneOffice Logo

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.

To access this command...

Choose Sheet - Insert Sheet.

Position

Specifies where the new sheet is to be inserted into your document.

Before current sheet

Inserts a new sheet directly before the current sheet.

After current sheet

Inserts a new sheet directly after the current sheet.

Sheet

Specifies whether a new sheet or an existing sheet is inserted into the document.

New sheet

Creates a new sheet. Enter a sheet name in the Name field. Allowed characters are letters, numbers, spaces and the underline character.

No. of sheets

Specifies the number of sheets to be created.

Name

Specifies the name of the new sheet.

Renaming Sheets

From File

Inserts a sheet from an existing file into the current document.

Browse

Opens a file selection dialogue box.

Available Sheets

If you selected a file by using the Browse button, the sheets contained in it are displayed in the list box. The file path is displayed below this box. Select the sheet to be inserted from the list box.

Select to insert the sheet as a link instead as a copy. The links can be updated to show the current contents.