Instructions for Using OpenOffice.org Calc
On the help page for OpenOffice.org general you can find instructions that are applicable to all modules, such as working with windows and menus, customizing OpenOffice.org, data sources, Gallery, and drag and drop.
If you want help with another module, switch to the help for that module with the combo box in the navigation area.
Formatting Tables and Cells
Freezing Rows or Columns as Headers
Highlighting Negative Numbers
Cells in Currency Format
Deactivating Automatic Changes
Formatting Spreadsheets
Applying Automatic Formatting to a Selected Cell Range
Selecting Themes for Sheets
Assigning Formats by Formula
Applying Conditional Formatting
Undoing Direct Formatting for a Document
Copying to Multiple Sheets
Selecting Multiple Cells
Merging and Splitting Cells
Formatting Numbers With Decimals
User-defined Number Formats
Formatting Numbers as Text
Inserting and Editing Notes
Renaming Sheets
Changing Row Height or Column Width
Changing Table Views
Using Rounded Off Numbers
Only Copy Visible Cells
Copying Formatting With the Format Paintbrush
Inserting Line Breaks in Cells
Rotating Text
Writing Multi-line Text
Text Superscript / Subscript
Inserting Special Characters
Changing the Color of Text
Switching Between Insert Mode and Overwrite Mode
Inserting Protected Spaces, Hyphens and Conditional Separators
Recording Changes
Entering Values and Formulas
Calculating With Formulas
Displaying Formulas or Values
Entering Formulas in the Formula Bar
Copying Formulas
Calculating in Spreadsheets
Calculating With Dates and Times
Calculating Time Differences
Entering Fractions
Entering a Number with Leading Zeros
Applying Multiple Sheets
Navigating Through Sheets Tabs
Automatically Filling in Data Based on Adjacent Cells
Applying Sort Lists
Applying Filters
Applying AutoFilter
Filter: Applying Advanced Filters
Only Copy Visible Cells
Entering Matrix Formulas
Rotating Tables (Transposing)
User-Defined Functions
Entering References
Naming Cells
Recognizing Names as Addressing
Referencing Cells by Drag-and-Drop
Addresses and References, Absolute and Relative
Referencing URLs
Referencing Other Sheets
Entering Matrix Formulas
Inserting External Data in Table (WebQuery)
Database Ranges in Tables
Defining a Database Range
Filtering Cell Ranges
Sorting Database Ranges
Advanced Calculations
DataPilot
Creating DataPilot Tables
Editing DataPilot Tables
Filtering DataPilot Tables
Updating DataPilot Tables
Deleting DataPilot Tables
Selecting DataPilot Output Ranges
Consolidating Data
Applying Goal Seek
Applying Multiple Operations
Validity of Cell Contents
Using Scenarios
Printing and Page Preview
Defining Print Ranges on a Sheet
Printing Sheet Details
Defining Number of Pages for Printing
Printing Sheets in Landscape Format
Printing Rows or Columns on Every Page
Defining Background Colors or Background Graphics
Importing and Exporting Documents
Opening and Saving Text CSV Files
Importing and Exporting Text Files
Importing and Exporting dBase Files
Saving and Opening Sheets in HTML
Sending Documents as E-mail
Opening documents saved in other formats
Saving Documents in Other Formats
Miscellaneous
Shortcut Keys (OpenOffice.org Calc Accessibility)
Pasting Contents in Special Formats
Changing Your Work Directory
Protecting Cells from Changes
Unprotecting Cells
Freezing Rows or Columns as Headers
Inserting and Editing Notes
Rotating Tables (Transposing)
User-Defined Functions
Inserting External Data in Table (WebQuery)
19xx/20xx Years
Inserting, Editing, Saving Bitmaps
Applying Line Styles Using the Toolbar
Defining Line Ends
Defining Line Styles
Recording a Macro
Index
$[officename] Calc, instructions
instructions, $[officename] Calc
This help text is published from the
OpenOffice-Help files under the
Public Documentation License 1.0.
