The Data Menu
Prev
Next

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.

Prev
Next
Home


Would you like to make a comment or contribute an update to this page?
Send feedback to the KDE Docs Team