OpenOffice.org video based manual
Plan-B for OpenOffice.org, learning office productivity software with videos


Tech Support for OpenOffice.org
Applications
Go to Open Office Writer Index
Go to Open Office Impress Index
Go to Open Office Math Index
Go to Open Office Draw Index
Go to Open Office Calc Index
Go to Open Office Base Index
Go to Open Office Online Help Index

Help Sections:
General
Writer
Impress
Math
Draw
Calc
Base
Basic

Formula Bar

Use this bar to enter formulas.

Name Box

Displays the reference for the current cell, the range of the selected cells, or the name of the area. You can also select a range of cells, and then type a name for that range into the Name Box.

Combo box sheet area

Name Box


Function Wizard

Opens the Function Wizard, which helps you to interactively create formulas.

Icon

Function Wizard


Sum

Automatically adds the numbers in the cell range that you specify. Click in a cell, click this icon, and then enter the cell range. You can also drag to define a cell range in the spreadsheet.

Icon

Sum


Function

Adds a formula to the current cell. Click this icon, and then enter the formula in the Input line.

Icon

Function


Cancel

Clears the contents of the Input line, or cancels the changes that you made to an existing formula.

Icon

Cancel


Accept

Accepts the contents of the Input line, and then inserts the contents into the current cell.

Icon

Accept


Input line

Enter the formula that you want to add to the current cell. You can also click the Function Wizard icon to insert a predefined function into the formula.

Index

formula bar, sheet area names

sheet area names

showing, cell references

cell references, showing

inserting functions, Function Wizard

functions,Function Wizard

wizards, functions

functions,sum function icon

formula bar,sum function

sum function in formula bar

adding, sum icon

formula bar, functions

functions, formula bar icon

formula bar, canceling inputs

functions, canceling input icon

formula bar, accepting inputs

functions, accepting input icon

This help text is published from the OpenOffice-Help files under the Public Documentation License 1.0.

Get OpenOffice.org - Free!