9. Worksheet and workbook

A worksheet is an area where you do all the tasks. You can enter and edit data in a worksheet. A combination of one or more worksheets forms a workbook. 

 

LibreOffice Calc contains one worksheet by default. Sheet\(1\) is the active worksheet when you open the LibreOffice Calc (Untitled\(1\)) window for the first time.

 

 

Column:

A column is a vertical line of boxes. The columns are labelled from the letters \(A\) to \(Z\) and thereafter as \(AA\), \(AB\)..........up to \(AMJ\). There are \(1024\) columns in a worksheet.

 

Row:

 

A row is a horizontal line of boxes. These are labelled with numbers like \(1,2,3\)....and so on. There are \(10,48,575\) rows in a worksheet.

 

Cell:

The intersection of a row and a column is known as a cell. Its address identifies each cell. The cell address is a combination of column letters and row numbers. The first active cell’s address will be \(A1\). The name box shows the address of the active cell.

 

Active Cell:

The highlighted cell on the worksheet is the active cell. You can enter your data only in an active cell. You can easily make any cell active by using a mouse or a keyboard. If you want to make the cell \(C2\) active, just click on the cell \(C2\). You can also use arrow keys to select a cell.

 

Range of Cells:

A group of cells is known as the range of cells. It forms a rectangle or a square. For selecting a range of cells, press and hold the shift key and use the arrow key.

The image given below shows the range of cells that starts from \(C2\) and ends at \(C5\).

 

The range of cells is represented as \(C2:C5\). Here colon (:) is a range indicator. You can easily deselect cells by clicking anywhere on the worksheet.