Working with columns and rows

OpenOffice.org 3 Calc Guide

Chapter 1: Introducing Calc

< Previous Section

Next Section >

• Parts of the main Calc window
• Starting and opening spreadsheets
• Saving spreadsheets
• Navigating within spreadsheets
• Selecting items
• Working with columns and rows
• Working with sheets
• Viewing Calc
• Using the Navigator

< Previous Page

Next Page >

Inserting columns and rows

Columns and rows can be inserted individually or in groups.

• New columns are inserted to the left of the first highlighted column.
• New rows are inserted above the first highlighted row.
• Cells in the new columns or rows are formated like the corresponding cells in the column or row before (or to the left of) which the new column or row is inserted.

Single column or row

A single column or row can be added using the Insert menu:

1. Select the column or row where you want the new column or row inserted.
2. Select either Insert > Columns or Insert > Rows.

A single column or row can also be added using the right-click (context) menu:

1. Select the column or rows where you want the new column or row inserted.
2. Right-click the header.
3. Select Insert Rows or Insert Columns.

Multiple columns or rows

Multiple columns or rows can be inserted at once rather than inserting them one at a time.

1. Highlight the required number of columns or rows by holding down the left mouse button on the first one and then dragging across the required number of identifiers.
2. Proceed as for inserting a single column or row above.

Deleting columns and rows

Columns and rows can be deleted individually or in groups.

Single column or row

A single column or row can only be deleted by using the mouse:

1. Select the column or row to be deleted.
2. Right-click on the column or row header.
3. Select Delete Columns or Delete Rows from the pop-up menu.

Multiple columns or rows

Multiple columns or rows can be deleted at once rather than deleting them one at a time.

1. Highlight the required number of columns or rows by holding down the left mouse button on the first one and then dragging across the required number of identifiers.
2. Proceed as for deleting a single column or row above.

Instead of deleting a row or column, you may wish to delete the contents of the cells but keep the emply row or column. See Entering, Editing, and Formating Data for instructions.