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
Scripting Languages
Development Tools
Web Development
GUI Toolkits/Desktop
Mail Systems
Eclipse Documentation

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




10.2.2. KSpread

KSpread is the KOffice spreadsheet program.
Open KSpread by selecting the Kickoff Application Launcher > Office > Spreadsheet entry for KSpread .
The first window contains options for opening Recent or Existing documents, and the type of Template , as well as a menu bar.
On the menu bar,
  • choose File to create a New file, Open , Close or Import a file, or Quit the application.
  • choose the Settings drop-down menu select Show Toolbar , Configure Shortcuts or Configure Toolbars .
  • click Help to open the KSpread Handbook or Report a Bug . You can also access the KSpread Handbook by pressing the F1 key.
After selecting a template click the Use This Template button and check the box Always use this template if you want to make it the program default.
The next window has four menu panels on the top, the spreadsheet, and spreadsheet tabs running along the bottom.
The first menu row consists of:
lets you create New documents, Open and Close a file, Save , Export , Import , Mail , Create a Template From Document , Print , and Quit the application.
allows you to Cut , Copy , and Paste , Fill , Find , and Replace , Delete , Remove Links and change Cell Attributes .
opens a new spreadsheet with New View , or allows access to Close All Views , Split or Remove View , Goto a Cell , Show Page Borders , and Zoom in and out.
lets you insert Cell Comments , Functions , Series , Links , Special Characters , Objects , Charts , Pictures , or External Data such as information from a Database , Text File or the Clipboard .
lets you format the Cells , Rows , Columns , can be formatted, the Sheet can be Removed , Hidden and the Sheet Properties changed. Format can also be used to set up or create Styles , change the Page Layout and Print Ranges .
lets you manipulate the data such as Sort bring Text to Columns , Insert columns , Rows , Delete Columns or Rows , Insert , Remove , Merge , or Disassociate Cells , Show an Area , insert Subtotals , Goal Seek , or Consolidate formulas.
can check Spelling , create Custom Lists , Protect Sheet and Document , Recalculate Sheet or Document , Insert Calendar . Tools can also access the Script Manager and Editor , and Export to HTML File .
provides Hide the Status Bar , Tab Bar , and Formula Bar . Also use Settings to choose which Toolbars you want open, Configure Shortcuts , Toolbars , and KSpread .
opens the KSpread Handbook (which you can also access by pressing the F1 key), lets you Report a Bug and offers general information about KSpread and KDE.
The row of icons under the top menu bar contains the most frequently used functions plus a few icons for data manipulation.
The third menu panel allows configuration of the appearance of your data, such as font selection, alignment, font, bullets, indentations, bolding, and italics.
The fourth panel shows the address of the current cell and the data window shows what the cell contains.
The panel at the bottom shows in bold which spreadsheet is currently selected and how many worksheets are in the file. Worksheets can be added with a right mouse click on a worksheet tab. This pop-up window allows Rename the Sheet , Insert , Remove , Hide or Show the Sheet and provides access to Sheet Properties .
A KSpread tutorial is available at You can download pre-formatted templates and scripts from

  Published under the terms of the Open Publication License Design by Interspire