StarOffice Calc 8 ClueSheet Contents

Creating a Spreadsheet

Create a new spreadsheet
Import a Microsoft Excel Spreadsheet

Adding Content to a Spreadsheet

Type in a cell
Use AutoFill
Insert a graphic
Insert data from an external source

Formatting a Spreadsheet
Change column width
Insert rows
Insert columns
Move cells
Add borders to page
Add background/shading to cells
Change font, typeface, size, or color
Wrap text in cells
Format numbers
Use AutoFormat
Center a heading over multiple columns
Increase space around text within cells
Change row height or column width

Organizing Sheets
Insert new sheet
Rename sheet
Move or copy a sheet

Creating Formulas

Considerations for creating formulas
Apply formula toa cell

Applying Functions
Considerations for working with functions
Apply function to a cell
AutoSum

Creating Charts
Create a chart
Change a chart type
Change text formatting for titles and legends

Referencing Data
Reference data between cells, sheets, and files

Printing Spreadsheets

Add heaters or footers
Print a portion of a sheet
Print only selected sheets
Suppress output of empty pages
Print with gridlines
Fit to page
Change paper orientation

Plus our top Tips and Tricks...!