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

Table Bar

The Table Bar contains functions you need when working with tables. It appears when you move the cursor into a table.

Insert Rows

Inserts one or more rows in the table, below the cursor position or selection. You can insert more than one row by opening the corresponding dialogue box (choose Table - Insert - Rows), or by selecting more than one row before clicking the icon. The second method inserts rows of the same height as the originally selected rows.

Insert Row

Insert Column

Inserts one or more columns into the table, to the right of the cursor position or selection. You can insert several columns at the same time by opening the corresponding dialogue box (choose Table - Insert - Columns), or by selecting several columns before clicking the icon. If the latter method is used, the columns inserted will have the same relative width as the selected columns.

Insert Column

Delete Row

Deletes the selected row(s) from the table.

Delete Row

Delete Column

Deletes the selected column(s) from the table.

Delete Column

Merge Cells

Combines the contents of the selected cells into a single cell, retaining the formatting of the first cell in the selection.

Merge Cells

Unmerge CellsSplit Cells

Optimise Size

Opens a toolbar that contains functions for optimising the rows and columns in a table.

Optimise Size

Top

Aligns the contents of the cell to the top edge of the cell.

Centre (vertical)

Centres the contents of the cell between top and bottom of the cell.

Bottom

Aligns the contents of the cell to the bottom edge of the cell.

Background Colour

Click to open a toolbar where you can click a background colour for a paragraph. The colour is applied to the background of the current paragraph or the selected paragraphs.

Background Colour

AutoFormat

Automatically applies formats to the current table, including fonts, shading and borders.

Borders

Click the Borders icon to open the Borders toolbar, with which you can modify the border of a sheet area or an object.

Borders

Line Style

Click this icon to open the Line Style toolbar, with which you can modify the border line style.

Line Style

Border Colour

Click the Line Colour (of the border) icon to open the Border Colour toolbar, which enables you to change the border colour of an object.

Line Colour (of the border)

Sort

Sorts the selected paragraphs or table rows alphabetically or numerically. You can define up to three sort keys as well as combine alphanumeric and numeric sort keys.

Sum

Activates the sum function. Note that the cursor must be in the cell where you want the sum to appear.

Sum

Table Properties

Specifies the properties of the selected table, for example, name, alignment, spacing, column width, borders, and background.