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

Tools Bar

Use the Tools bar to access commonly used commands.

Insert

Click the arrow next to the icon to open the Insert toolbar, with which you can add graphics and special characters to the current sheet.

Insert

Insert Cells

Click the arrow next to the icon to open the Insert Cells toolbar, with which you can insert cells, rows and columns into the current sheet.

Insert Cells

Controls

The Form Controls toolbar or sub-menu contains tools that you need to create an interactive form.

Form Controls

AutoFormat

Use this command to apply an AutoFormat to a selected sheet area or to define your own AutoFormats.

AutoFormat

Choose Themes

Applies a formatting style to the selected cells.

Choose Themes

AutoFilter

Automatically filters the selected cell range, and creates one-row list boxes with which you can choose the items that you want to display.

AutoFilter

Standard Filter

Allows you to set the filtering options.

Standard Filter

Advanced Filter

Defines an advanced filter.

Start

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

Euro Converter

Converts the currency amounts found in Office Calc documents and in fields and tables of Office Writer documents into euros.

Define

Opens a dialogue box where you can specify a name for a selected area or a name for a formula expression.

Goal Seek

Opens a dialogue box in which you can solve an equation with a variable.

Group

Defines the selected cell range as a group of rows or columns.

Group

Ungroup

Ungroups the selection. In a nested group, the last rows or columns that were added are removed from the group.

Ungroup