Selecting Columns and Rows

Getting Started with OpenOffice 4

Chapter 4: Getting Started with Calc

< Previous Section

Next Section >

• What is Calc
• Parts of the main Calc window
• Open and Save CSV files
• Navigating within spreadsheets
  • Going to a particular cell
  • Moving from cell to cell
  • Moving from sheet to sheet
• Selecting items in a sheet or a spreadsheet
  • Selecting Cells
  • Selecting Columns and Rows
  • Selecting Sheets
• Working with Columns and Rows
• Working with Sheets
• Viewing Calc
• Entering data using the keyboard
• Speeding up data entry
• Validating cell contents
• Editing data
• Formatting data
• Auto-formatting cells and sheets
• Formatting spreadsheets using themes
• Using conditional formatting
• Hiding and showing data
• Sorting records
• Using formulas and functions
• Analyzing data
• Printing from Calc
  • Using Print Ranges
  • Selecting the Page Order, Details, and Scale
  • Page Breaks
  • Headers and Footers

< Previous Page

Next Page >

Selecting Columns and Rows

Entire columns and rows can be selected very quickly in Apache OpenOffice.

Single column or row

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

To select a single row, click on the row identifier number.

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  Ctrl  key.
3. Click on all the subsequent columns or rows while holding down the  Ctrl  key.

Entire sheet

To select the entire sheet, click on the small box between the A column header and the 1 row header. You can also press  Ctrl  +  A  to select the entire sheet.

Figure 73: Select All box