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

Tools bar icon:

Insert Cells

You can select the following icons:

Insert Cells Down

Moves the contents of the selected range downwards when cells are inserted.

Insert Cells Down

Insert Cells Right

Moves the contents of the selected range to the right when cells are inserted.

Insert Cells Right

Rows

Inserts an entire row. The position of the row is determined by the selection on the sheet.

Insert Rows

Columns

Inserts an entire column. The number of columns to be inserted is determined by the selected number of columns.

Insert Columns