The Data Menu

Data → Sort...

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

Data → Text 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.

Data → Insert Columns

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

Data → Insert Rows

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

Data → Delete Columns

Delete selected column(s).

Data → Delete Rows

Delete selected row(s).

Data → Insert Cells...

Insert new cell(s).

Data → Remove Cells...

Remove selected cell(s).

Data → Merge Cells

Merge selected cells.

Data → Dissociate Cells

Dissociate (split apart) previously merged cells.

Data → Show Area...

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

Data → Subtotals...

Create different kinds of subtotals to a database.

Data → Goal Seek...

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

Data → Consolidate...

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