Follow Techotopia on Twitter

On-line Guides
All Guides
eBook Store
iOS / Android
Linux for Beginners
Office Productivity
Linux Installation
Linux Security
Linux Utilities
Linux Virtualization
Linux Kernel
System/Network Admin
Programming
Scripting Languages
Development Tools
Web Development
GUI Toolkits/Desktop
Databases
Mail Systems
openSolaris
Eclipse Documentation
Techotopia.com
Virtuatopia.com
Answertopia.com

How To Guides
Virtualization
General System Admin
Linux Security
Linux Filesystems
Web Servers
Graphics & Desktop
PC Hardware
Windows
Problem Solutions
Privacy Policy

  




 

 

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.




 
 
  Published under the terms of the GNU General Public License Design by Interspire