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

Menus

The following menu commands are available for spreadsheets.

The window containing the document you want to work on must be selected in order to use the menu commands. Similarly, you must select an object in the document to use the menu commands associated with the object.

The menus are context sensitive. This means that those menu items are available that are relevant to the work currently being carried out. If the cursor is located in a text, then all of those menu items are available that are needed to edit the text. If you have selected graphics in a document, then you will see all of the menu items that can be used to edit graphics.

By default, you see inactive menu items as gray items.To hide the inactive menu items, go to Tools - Options - OpenOffice.org - View and disable the Inactive menu items box.

File

Contains commands for working with spreadsheets, such as open, close, save, and print. To quit OpenOffice.org, click Exit.

Edit

Use the commands in this menu to edit Calc sheets, for example, copying, pasting, and deleting cell contents.

View

The View menu contains commands for controlling the display of the spreadsheet window and toolbars.

Insert

The Insert menu contains commands for inserting new elements, such as cells, rows, sheets and cell names into the current sheet.

Format

The Format menu contains commands for formatting selected cells, objects, and cell contents in your document.

Tools

The Tools menu contains commands to check spelling, to trace sheet references, to find mistakes and to define scenarios.

Data

Use the Data menu commands to edit the data in the current sheet. You can define ranges, sort and filter the data, calculate results, outline data, and open the DataPilot.

Window

Use the Window menu to open, split, and arrange windows.

Help

The Help menu allows you to start and control the OpenOffice.org Help system.

Index

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

Get OpenOffice.org - Free!