The Data Format page of the Cell Format dialog box lets you control how the values of cells are displayed.

Set tests to confirm cell data is valid

It is often convenient to have one cell that spreads across two or more columns or down more than one row. This can be done by merging two or more cells into one. Select the cells to be merged than choose Data Merge Cells.

To reverse this process, select the merged cell then choose Dissociate Cells from the Data menu.

Create Style From Cell...

Create Style From Cell

Counts the cells containing numeric values in a column of a database specified by a set of conditions.

Source cell must contain a numeric value.

Counts the cells containing numeric or alphanumeric values in a column of a database specified by a set of conditions.

EDP module

The COLUMN function returns the column of given cell reference. If no parameter is specified the column of the current cell gets returned.

The ROW function returns the row of given cell reference. If no parameter is specified the row of the current cell gets returned.

Convert GPS data and exchange it with a GPS unit

Set the cell formatting to look like a percentage

Align cell contents along the top of the cell

Align cell contents centered in the cell

Align cell contents along the bottom of the cell

This function returns the count of all empty cells within the range.

Time format

Cell Format

Cell Format...

Neither the order nor the notations of the columns, rows or cells should be changed in the tables as this will complicate data compilation.

Create a new style based on the currently selected cell

Cells

Cell

Cells

Cells...

Select Single Cell

Set the cell formatting

Cell is

Cell Values

Annex I Parties should fill in all the cells calling for emissions or removals estimates, activity data, or emission factors.

Cell Border

Cell Background

Merging Cells

Draw cell

Dark yellow

Draw eye

Draw logo

Merge Cells

Merge cells

Size of Cell

Cell range

Row cell

Cell range of values