Welcome to the OpenOffice.org Training and Support Site

Welcome
<< Basics of a Spreadsheet Selecting Cells Copying & Moving Cells >>

In order to perform functions such as copying or moving cells and data, you will need to know how to select cells on the spreadsheet. This section will describe how to:

  • Select a single cell
  • Select multiple cells
  • Select a column of cells
  • Select a row of cells

Selecting Cells

To select a single cell, simply left-click on the cell with the mouse

Single selected cell

To select a multiple cells, left-click with the mouse on a cell and drag the mouse pointer across the group of cells that you wish to select. The diagram below shows a selected group of multiple cells

Multiple selected cells

Selecting a Column or Row

You may also select an entire column or row of cells on the spreadsheet. To select a column of cells, left-click with the mouse on the lettered button at the top of the column that you wish to select. The diagram below shows a selected column C on the spreadsheet.

Selected column C

To select a row of cells, left-click with the mouse on the numbered button at the left end of the row of cells that you wish to select. The diagram below shows a selected row 4 on the spreadsheet.

Selected Row 4
<< Basics of a Spreadsheet Selecting Cells Copying & Moving Cells >>

Home | About OpenOffice.org | Tutorials | FAQs | Sitemap | Help