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
Help

Toolbars

Toolbars
Formatting Bar
Drawing Object Properties Bar
Text Formatting Bar
Formula Bar
Status Bar
Page Preview Bar
Picture Bar
Tools Bar
Standard Bar
Table Data Bar
Form Navigation Bar
Query Design Bar
Form Design Toolbar

Functions Types and Operators

Function Wizard
Functions by Category
Array Functions
Bit Operation Functions
Database Functions
Date & Time Functions
Financial Functions Part One
Financial Functions Part Two
Financial Functions Part Three
Information Functions
Logical Functions
Mathematical 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
User-Defined Functions

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
Formatting 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 Comments
Selecting Themes for Sheets
Entering Fractions

Filtering and Sorting

Applying Filters
Filter: Applying Advanced 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 Cell Ranges
Sorting Data

Pivot Table

Pivot Table
Creating Pivot Tables
Deleting Pivot Tables
Editing Pivot Tables
Filtering Pivot Tables
Selecting Pivot Table Output Ranges
Updating Pivot 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
Recognising Names as Addressing

Viewing, Selecting, Copying

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

Formulae and Calculations

Calculating With Formulae
Copying Formulae
Entering Formulae
Displaying Formulae or Values
Calculating in Spreadsheets
Calculating With Dates and Times
Automatically Calculating Series
Calculating Time Differences
Entering Matrix Formulae

Protection

Protecting Cells from Changes
Unprotecting Cells

Miscellaneous

Deactivating Automatic Changes
Consolidating Data
Applying Goal Seek
Applying Multiple Operations
Applying Multiple Sheets
Validity of Cell Content