Inserting columns and rows

Getting Started with OpenOffice.org 2.x

Chapter 7: Getting Started with Calc

< Previous Section

Next Section >

• Parts of the main Calc window
• File management
• Navigating within spreadsheets

• Going to a particular cell
• Moving from cell to cell
• Moving from sheet to sheet

• Selecting cells
• Selecting columns and rows
• Inserting columns and rows
• Deleting columns and rows
• Working with sheets

• Inserting new sheets
• Deleting sheets
• Renaming sheets

• Viewing Calc

• Freezing rows and columns
• Splitting the window

• Entering data into a sheet
• Printing

• Print options
• Selecting sheets to print
• Printing rows or columns on every page
• Defining a print range

< Previous Page

Next Page >

Columns and rows can be inserted in several different way and quantities.

Single column or row

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

1. Select the column or rows where you want the new column or row inserted.
2. Select either Insert > Column or Insert > Row.

When you insert a single new column, it is inserted to the left of the highlighted column. When you insert a single new row, it is inserted above the highlighted row.

A single column or row can also be added using the mouse:

1. Select the column or row where you want the new column or row inserted.
2. Right-click the header.
3. Select Insert Row or Insert Column.

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.