On-line Guides
All Guides
eBook Store
iOS / Android
Linux for Beginners
Office Productivity
Linux Installation
Linux Security
Linux Utilities
Linux Virtualization
Linux Kernel
System/Network Admin
Programming
Scripting Languages
Development Tools
Web Development
GUI Toolkits/Desktop
Databases
Mail Systems
openSolaris
Eclipse Documentation
Techotopia.com
Virtuatopia.com
Answertopia.com
How To Guides
Virtualization
General System Admin
Linux Security
Linux Filesystems
Web Servers
Graphics & Desktop
PC Hardware
Windows
Problem Solutions
Privacy Policy
OpenOffice Calc User Guide
Home
Next Page
Table of Contents
Copyright
ii
Authors
ii
Feedback
ii
Publication date and software version
Introducing Calc: Using Spreadsheets in OpenOffice.org
What is Calc?
Spreadsheets, sheets and cells
Parts of the main Calc window
Title bar and Menu bar
Toolbars
Formula bar
Individual cells
Sheet tabs
File management
Starting new spreadsheets
From the File menu
From the toolbar
From the keyboard
Opening existing spreadsheets
From the File menu
From the toolbar
From the keyboard
Opening from a template
Saving spreadsheets
From the File menu
From the toolbar
From the keyboard
Navigating within spreadsheets
Going to a particular cell
Using the mouse
Using a cell reference
Using the Navigator
Moving from cell to cell
Using the Tab and Enter keys
Using the cursor keys
Using Home, End, Page Up and Page Down
Moving from sheet to sheet
Using the keyboard
Using the mouse
Selecting items in a sheet or spreadsheet
Selecting cells
Single cell
Range of contiguous cells
Range of non-contiguous cells
Selecting columns and rows
Single column
Single row
Multiple columns or rows
Entire sheet
Selecting sheets
Single sheet
Multiple contiguous sheets
Multiple non contiguous sheets
All sheets
Working with columns and rows
Inserting columns and rows
Single column or row
Multiple columns or rows
Deleting columns and rows
Single column or row
Multiple columns or rows
Working with sheets
Inserting new sheets
Deleting sheets
Single sheet
Multiple sheets
Renaming sheets
Viewing Calc
Using the zoom function
Freezing rows and columns
Freezing single rows or columns
Freezing a row and a column
Unfreezing
Splitting the window
Splitting the screen horizontally
Splitting the screen vertically
Removing split views
Entering data into a sheet
Entering numbers
Entering text
Entering numbers as text
Entering dates and times
Entering, Editing and Formatting Data
Entering data into Calc
Inputing data
Moving between cells
Using the mouse
Using the arrow keys
Using the Enter key
Multiple lines of text
Wrapping text
Line breaks
Shrinking to fit cell
Editing data in Calc
Removing data from a cell
Removing data only
Removing data and formatting
Replacing all the data in a cell
Changing part of the data in a cell
Keyboard shortcut
Mouse
Formatting data in Calc
Numbers
Font
Font effects
Underlining
Strikethrough
Relief
Alignment and orientation
Borders
Background
Cell Protection
Creating Charts and Graphs
Introduction
Creating a chart
Using the AutoFormat Chart dialog
Data range and labels
Chart and axis titles, and legend
Selecting data ranges
Examples of different chart types
Columns (2D & faux 3D)
Bars (2D & 3D)
Lines (2 & 3 D)
Pies (2D & 3D)
Net
XY graphs
Modifying the appearance of the chart
A simple scatter plot
Moving and resizing a chart
Changing axes scales
Modifying the data area of the chart
Grid lines and background
Defining the data area
Fitting a regression line to the data
Multiple data series
Editing and moving elements of the graph or chart
XY – Line graph
Secondary y-axes
Minor formatting
Changing line colors
Modifying axes scales
Adding subtitles, and axis labels
Removing the legend
Data labels
Axis labels
Error bars
Printing with Calc
Print options
Selecting sheets to print
Details, order, and scale
Details
Page Order
Scale
Adjusting the print range
Printing rows or columns on every page
Defining a print range
Adding to the print range
Removing a print range
Editing a print range
Defining a custom print range
Page breaks
Inserting a page break
Row break
Column break
Deleting a page break
Headers and footers
Setting a header or a footer
Margin
Spacing
Height
Header or footer appearance
Setting the contents of the header or footer
Areas
Header
Custom header
Using Graphics in Calc
Inserting pictures
From a file
From the Gallery
From another application – copying and pasting
Drawing in Calc
Working with graphics in Calc
Picture toolbar
From File
Filter
Graphics Mode
Color
Line
Area
Shadow
Crop
Change Anchor
Bring to Front/Send to Back
To Foreground/To Background
Alignment
Picture context menu
Text
Position and Size
Flip
Name Object
Group
Positioning graphics
Arrangement
Foreground and background
Anchoring
Anchor to page
Anchor to cell
Using Styles in Calc
Introduction
Types of styles in Calc
Accessing styles
Applying styles
Using the Styles and Formatting window
Using Fill Format mode
Using the Apply Style list
Assigning styles to shortcut keys
Style organizer
Name
Linked with
Category
Cell styles
Cell style options
6
Numbers
Font
Font effects
Alignment
Borders
Background
Cell Protection
Page styles
Page style options
Page
Borders
Background
Header
Footer
Sheet
Modifying styles
Creating new styles
Creating a linked style
Creating an unlinked style
Creating a style from an already formatted object
Dragging and dropping a selection to create a style
Copying and moving styles
Deleting styles
Editing, Changing, and Reviewing
Making changes
Recording changes
Adding comments and notes
Adding comments
Adding a note
Reviewing changes
Viewing changes
Accepting or rejecting changes
Merging documents
Comparing documents
Versions
A note about file names and titles
Keyboard Shortcuts
Shortcut keys
Assigning shortcut keys
Saving changes to a file
Loading a saved keyboard configuration
Resetting the shortcut keys
Formatting and editing shortcuts
The Enter key
Filling a range
Selecting multiple cells and sheets
Deleting
Running macros
Navigation and selection shortcuts
Function key shortcuts
Cell formatting shortcuts
DataPilot shortcut keys
Description of Functions
Mathematical functions
Financial analysis functions
A note about dates
A note about interest rates
Statistical analysis functions
Date and time functions
Logical functions
Informational functions
Database functions
Array functions
Spreadsheet functions
Text functions
Add-in functions
Calc Error Codes
Calc error codes
Error codes displayed within cells
General error codes
OpenOffice Calc User Guide
Home
Next Page
Published under the terms of the Open Publication License
Design by Interspire
x
