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 Helpto 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:
File
lets you create New documents, Open and Close a file, Save, Export, Import, Mail, Create a Template From Document, Print, and Quit the application.
Edit
allows you to Cut, Copy, and Paste, Fill, Find, and Replace, Delete, Remove Links and change Cell Attributes.
View
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.
Insert
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.
Format
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.
Data
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.
Tools
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.
Settings
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.
Help
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.
