The KSpread Handbook

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