Other Content

Table Of Contents
Generating Columns of Data
You can create a column of values based on the contents of another column.
You can also create a column based on any of several types of sequential
data.
Entering a formula in a columns formula cell tells the Lists&Spreadsheet
application that you want to apply the formula to all cells in the column, not just
to a single cell.
À
Column formula based on a variable
Á
Column formula based on another column (column A)
Â
Column formula that generates a sequence
Notes:
If you generate data in a column that already contains one or more cell
values, Lists&Spreadsheet asks for confirmation before replacing the
existing values. Proceeding removes all of the existing values in the
column.
If you edit a cell manually in a column of generated data,
Lists&Spreadsheet asks for confirmation before replacing the generated
data. Proceeding removes the generated data for the entire column.
Creating Column Values Based on Another Column
1. Click the column formula cell (the second cell from the top) of the column
where you want to use a formula.
Lists&Spreadsheet Application 319