The Data Menu

DataSort...

Sort data in selected cells. See the section Sorting Data for more details.

DataText to Columns...

This option attempts to interpret text in the selected cell(s) as CSV data, placing each item into a different cell in the row.

DataInsert Columns

Insert new column(s) at left of selected column(s).

DataInsert Rows

Insert new row(s) above selected row(s).

DataDelete Columns

Delete selected column(s).

DataDelete Rows

Delete selected row(s).

DataInsert Cells...

Insert new cell(s).

DataRemove Cells...

Remove selected cell(s).

DataMerge Cells

Merge selected cells.

DataDissociate Cells

Dissociate (split apart) previously merged cells.

DataShow Area...

Change KSpread's focus to show a previously named area. See the section Named Cells and Areas for further details.

DataSubtotals...

Create different kinds of subtotals to a database.

DataGoal Seek...

Open the Goal Seek dialog box. See Goal Seeking for details.

DataConsolidate...

Consolidate data. See the section Consolidating Data for more details.