The structure of a spreadsheet

<< Click to Display Table of Contents >>

The structure of a spreadsheet

In order to use PlanMaker immediately while working through this chapter, you should launch it now.

program_interface_ribbon_b

Spreadsheets are divided into lines and columns. Each spreadsheet can contain up to 1 million rows and 16384 columns. These are labelled as follows:

The rows are numbered.

The columns are labeled with alphabetic characters: A to Z, then AA to AZ, then BA to BZ, etc.

The matrix of rows and columns results in a cell grid. These boxes are called the cells of the sheet.

Each of the cells has its individual coordinates: B5, for example, describes the cell in the fifth line of column B (the second column). A3 would be the cell in the third row of column A (the first column), etc. These coordinates are referred to as the cell address.

The cell address is very important because calculations often refer to other cells: If, for example, you want to put twice the value of cell A1 in cell A2, you would enter in cell A2: =A1*2.

Twice the value of A1 is now displayed in A2. If you change the value in A1, the resulting calculation of cell A2 is automatically updated.