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

Entire columns and rows can be selected very quickly in OOo.

Single column or row

To select a single column, click on the column identifier letter (see Figure 1).

To select a single row, click on the row identifier number (see Figure 1).

Multiple columns or rows

To select multiple columns or rows that are contiguous:

1. Click on the first column or row in the group.
2. Hold down the Shift key.
3. Click the last column or row in the group.

To select multiple columns or rows that are not contiguous:

1. Click on the first column or row in the group.
2. Hold down the Control key.
3. Click on all of the subsequent columns or rows while holding down the Control key.

Entire sheet

To select the entire sheet, click on the small box between the A column header and the 1 row header (Figure 7). You can also use the keyboard to select the entire sheet by pressing Control+A.

File:CalcSelectAll.png

Figure 7: Select All box.