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

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

  




 

 

The KSpread Handbook

Pamela Roberts

Anne-Marie Mahfouf

Gary Cramblitt

Revision 1.5.2 (2006-06-12)

KSpread is a full featured spreadsheet program.


Table of Contents

1. Introduction
2. KSpread Basics
Spreadsheets for Beginners
Selecting Cells
Entering Data
Generic Cell Format
Copy, Cut and Paste
Copying and Pasting Cell Areas
Other Paste Modes
Insert and Delete
Simple Sums
Recalculation
Sorting Data
The Status bar Summary Calculator
Saving your Work
Templates
Printing a Spreadsheet
3. Spreadsheet Formatting
Cell Format
Data Formats and Representation
Fonts and Text Settings
Text Position and Rotation
Cell Border
Cell Background
Cell Protection
Conditional Cell Attributes
Changing Cell Sizes
Merging Cells
Hiding Rows and Columns
Sheet properties
4. Advanced KSpread
Series
Formulae
Built in Functions
Logical Comparisons
Absolute Cell References
Arithmetic using Special Paste
Goal Seeking
Using more than one Worksheet
Consolidating Data
Inserting a Chart
Inserting External Data
Link Cells
Validity Checking
Protection
Document Protection
Sheet protection
Cell or selected cells protection
Hide cell formula
Hide all in the cell
Other Features
Splitting the View
Named Cells and Areas
Cell Comments
5. Configuring KSpread Shortcuts and Toolbars
Shortcuts
User Defined Menus
Toolbars
6. The KSpread Configuration Dialog Box
Locale Settings
Interface
Misc
Color
Page Layout
Spelling
Configure Text-To-Speech options
7. For Users with Disabilities
Installing the kdeaccessibility Module
Visual Impairments
Theming
KMagnifier
Text-to-Speech
Motor Impairments and Mouseless Operation
KMouseTool
XAccess Features
Mouse Emulation
Mouse Navigation
Keyboard shortcuts
Resizing panels
Setting focus to widgets
8. Command Reference
The File Menu
The Edit Menu
The View Menu
The Insert Menu
The Format Menu
The Data Menu
The Tools Menu
The Settings Menu
The Help Menu
The Right Mouse Button Menu
Other Shortcuts
9. Questions and Answers
10. Credits and License
A. Installation



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