Use the
Data menu commands to edit the data in
the current sheet. You can sort and filter the data, calculate results,
outline data, and open the DataPilot.
Sorts the selected rows according to the conditions
that you specify.
Shows commands to
filter your data.
Calculates subtotals for the columns that you
select.
Defines what data is valid for a selected cell
or cell range.
Applies the
same formula to different cells, but with different parameter values.
Opens the
Text to Columns dialog, where you enter settings to expand the contents
of selected cells to multiple cells.
Combines data from one or more independent
cell ranges and calculates a new range using the function that you
specify.
You can
create an outline of your data and group rows and columns together
so that you can collapse and expand the groups with a single click.
A DataPilot table
provides a summary of large amounts of data. You can then rearrange
the DataPilot table to view different summaries of the data.
Inserts
data from Lotus® Symphony™ Spreadsheets or
Excel file into the current sheet as a link. The data must be located
within a named range.
You can directly import data into a spreadsheet
and customize your import options here.
Updates a data
range that was inserted from an external database. The data in the
sheet is updated to match the data in the external database.