Spreadsheets

General Information and User Interface Usage

Welcome to the %PRODUCTNAME Calc Help
%PRODUCTNAME Calc Features
Shortcut Keys (%PRODUCTNAME Calc Accessibility)
Shortcut Keys for Spreadsheets
Error Codes in %PRODUCTNAME Calc
Add-in for Programming in %PRODUCTNAME Calc
Instructions for Using %PRODUCTNAME Calc

Command and Menu Reference

Menus

Menus
File
Edit
View
Insert
Format
Tools
Window
Data

Toolbars

Toolbars
Spreadsheet Object Bar
Object Bar for a Selected Object
Object Bar for Text in a Text Object
Formula Bar
Status Bar
Page View Object Bar
Graphic Object Bar
Main Toolbar
Function Bar
Hyperlink Bar
Database Bar
Form Toolbar
SQL Object Bar
Object Toolbar when Creating Forms

Functions Types and Operators

AutoPilot: Functions
Categories and Functions
Database Functions
Date + Time Functions
Financial Functions Part One
Financial Functions Part Two
Financial Functions Part Three
Information Functions
Logical Functions
Mathematical Functions
Array Functions
Statistics Functions
Statistical Functions Part One
Statistical Functions Part Two
Statistical Functions Part Three
Statistical Functions Part Four
Statistical Functions Part Five
Spreadsheet Functions
Text Functions
Add-in Functions
Add-in Functions, List of Analysis Functions Part One
Add-in Functions, List of Analysis Functions Part Two
Operators in %PRODUCTNAME Calc
Defining Functions Yourself

Loading, Saving, Importing, and Exporting

Inserting External Data in Table (WebQuery)
Saving and Opening Sheets in HTML
Importing and Exporting Text Files

Formatting

Rotating Text
Writing Multi-line Text
Formatting Numbers as Text
Text Superscript / Subscript
Changing Row Height or Column Width
Applying Conditional Formatting
Highlighting Negative Numbers
Assigning Formats by Formula
Entering a Number with Leading Zeros
Designing Spreadsheets
Formatting Numbers With Decimals
Naming Cells
Rotating Tables (Transposing)
Renaming Sheets
19xx/20xx Years
Using Rounded Off Numbers
Cells in Currency Format
Using AutoFormat for Tables
Inserting and Editing Notes
Selecting Themes for Sheets
Entering Fractions

Filtering and Sorting

Applying Filters
Filter: Applying Advanced Filters
Filter: Applying Standard Filters
Applying AutoFilter
Applying Sort Lists

Printing

Printing Rows or Columns on Every Page
Printing Sheets in Landscape Format
Printing Sheet Details
Defining Number of Pages for Printing

Data Ranges

Defining Database Ranges
Filtering Database Ranges
Grouping Database Ranges and Calculating Subtotals
Sorting Database Ranges

Data Pilot

DataPilot
Creating DataPilot Tables
Deleting DataPilot Tables
Editing DataPilot Tables
Filtering DataPilot Tables
Selecting DataPilot Output Ranges
Updating DataPilot Tables

Scenarios

Using Scenarios

References

Addresses and References, Absolute and Relative
Referencing a Cell in Another Document
References to Other Sheets and Referencing URLs
Referencing Cells by Drag-and-Drop
Recognizing Names as Addressing
Addressing by Name

Viewing, Selecting, Copying

Changing Table Views
Displaying Formulas or Values
Freezing Rows or Columns as Headers
Navigating Through Sheets Tabs
Copying to Multiple Sheets
Only Copy Visible Cells
Selecting Multiple Cells

Formulas and Calculations

Calculating With Formulas
Copying Formulas
Entering Formulas in the Formula Bar
Displaying Formulas or Values
Calculating in Spreadsheets
Calculating With Dates and Times
Automatically Calculating Series
Calculating Time Differences
Entering Matrix Formulas

Protection

Protecting Cells from Changes
Unprotecting Cells

Miscellaneous

Auto Filling Cells
Deactivating Automatic Changes
Consolidating Data
Applying Goal Seek
Applying Multiple Operations
Applying Multiple Sheets
Validity of Cell Contents