advertisement

open office

50 %
50 %
advertisement
Information about open office

Published on January 4, 2008

Author: shantanuo

Source: slideshare.net

Description

Open office intro
advertisement

Cell Reference Formulae Bar Columns and Rows Sheet scroll tab Status Bar Sheet Tab Scroll Bar Active Sheet

Rename Sheets You can Right Click on the sheet name to rename the selected Sheet. Alternatively, click the sheet tab while pressing the Alt key. Now you can change the name directly.

Copy Sheets You can move the sheet to a new location by just clicking and dragging the sheet. And if you hold down Control Button, you will get a new sheet having the same contents with the same name except the number 2 that will be added.

You can also delete the unwanted sheets from you file. Or Insert a new sheet. Before deleting a sheet think for a moment, Because even if you click on undo, you won’t get the same sheet back.

Use Ctrl + Enter to type on the next line in the same cell. Use Format – Cells… Alignment Tab – Wrap text automatically If you want Open office to decide where the line should have a break.

You can increase the column width by double clicking on the column boundary.

Inserting and deleting rows and columns To insert a row, click on the row number and use right click button to get the shortcut menu. You can use insert option to insert rows. If you want to insert more than one rows then select the number of rows you want to insert and select insert option.

Inserting columns To insert a column first select the column heading and choose insert option from the shortcut menu.

Selecting the non-adjacent cells Hold down Control key when you are selecting the cells which are not adjacent to the current selection.

Autofill You can use autofill to copy text as shown in the column A. If Calc finds series in the cells those you have selected, it will Continue the trend. If you click and drag the autofill it will become 3, 4, 5, 6 and so on.

If there is a formulae in the cell, calc will copy the same using relative reference. And if you are typing months or weekdays it will follow the trend.

You can calculate the total in 4 different ways. Select the cell B6 and then type either of the following formulas. =29+21+12+8 =b2+b3+b4+b5 =Sum(b2:b5) or use the autosum button on Formula Bar.

Function Wizard You can use Function Wizard Button on Formula bar to solve complex Formulas like Average Maximum, Minimum, Logical Statements like If, Or Financial Functions like Internal Rate Of Return and so on.

Headers & Footers and Center across columns The header which has been typed in the centre section is displayed at the top. You can delete it by going to Edit – Headers & Footers… This is the Print Preview button on Standard Toolbar. you get an idea about how the page will get printed. You use the Centre Across button on Format toolbar to centre the text across specific columns.

Format – Page - options like orientation, Paper size, Margins As well as header and footer

Page Breaks Select the row where you want the page to break and choose Insert – Manual Break – Row Break To remove the break, select any cell next to the break and choose Edit – Delete Manual Break – Row Break The same applies to the Column breaks You can hide / resize the columns if the text written in it is too wide You can hide certain cell contents from printing by using the Format – Cells – Cell Protection – Hide when printing

Select the row where you want the page to break and choose Insert – Manual Break – Row Break

To remove the break, select any cell next to the break and choose Edit – Delete Manual Break – Row Break

The same applies to the Column breaks

You can hide / resize the columns if the text written in it is too wide

You can hide certain cell contents from printing by using the Format – Cells – Cell Protection – Hide when printing

Printing Borders Select the cells and choose the desired borders from the borders toolbar. If you want to display all the borders… Format – Page – Sheet – Grid You can also select Column and row headers to print A, B, C and 1,2,3 row numbers.

Select the cells and choose the desired borders from the borders toolbar.

If you want to display all the borders… Format – Page – Sheet – Grid

You can also select Column and row headers to print A, B, C and 1,2,3 row numbers.

Print Ranges Format – Print Ranges - Add You can also select the particular cell range to be printed and choose the Add print area button on the Custom Toolbar. To cancel the print area click on the cancel button next to it. Format – Print Ranges - Remove

Format – Print Ranges - Add

You can also select the particular cell range to be printed and choose the Add print area button on the Custom Toolbar. To cancel the print area click on the cancel button next to it.

Format – Print Ranges - Remove

Create Custom Toolbar To create your own custom toolbar… View – Toolbars – Customize – New… - My Toolbar Click on “Add…” – Category – Format – Add Print Area and Remove Print Area. You can hide / unhide this custom toolbar by using View – Toolbars – My Toolbar checkbox.

To create your own custom toolbar…

View – Toolbars – Customize – New… - My Toolbar

Click on “Add…” – Category – Format – Add Print Area and Remove Print Area.

You can hide / unhide this custom toolbar by using View – Toolbars – My Toolbar checkbox.

Add a comment

Related pages

Apache OpenOffice - Die freie Büro-Software

Die offizielle Homapge des Apache OpenOffice Open Source Projekts, Heimat von OpenOffice Writer, Calc, Impress, Draw und Base.
Read more

OpenOffice - Download - CHIP

OpenOffice 4.1.2 Deutsch: OpenOffice, die bekannte kostenlose Office-Konkurrenz bietet auch weiterhin von Schreibprogramm, über Tabellenkalkulation bis ...
Read more

OpenOffice - Download kostenlos in deutsch

OpenOffice ist die kostenlose Büro-Software. Inkl. Schreibprogramm, Tabellenkalkulation, Präsentations-Software, Datenbankverwaltung, Zeichenprogramm und ...
Read more

OpenOffice 4.1.2 (Build 9782) - Download - COMPUTER BILD

„OpenOffice“ macht dem Marktführer Microsoft Office ernsthafte Konkurrenz. Wie das große Vorbild enthält das kostenlose Open-Source-Office-Paket ...
Read more

Apache OpenOffice – Wikipedia

Apache OpenOffice (vormals OpenOffice.org) ist ein freies Office-Paket, das aus einer Kombination verschiedener Programme zur Textverarbeitung, ...
Read more

OpenOffice | heise Download

Die kostenlose Büro-Software OpenOffice ist eine leistungsfähige Alternative zu Microsoft Office.
Read more

OpenOffice - Download - CHIP

OpenOffice Die kostenlose Office-Suite besteht aus Textverarbeitung, Tabellen-Kalkulation, Präsentations-Software, Zeichenprogramm, Datenbank ...
Read more

Apache OpenOffice - Official Site - The Free and Open ...

The official home page of the Apache OpenOffice open source project, home of OpenOffice Writer, Calc, Impress, Draw and Base.
Read more

OpenOffice - Download (deutsch) kostenlos

OpenOffice ist die bekannte kostenlose Office Komplettlösung. Mit Werkzeuge für Textverarbeitung, Tabellenkalkulation, Zeichnungen, Datenbanken, Formeln ...
Read more

Apache OpenOffice - Download

Apache OpenOffice, Download kostenlos. Apache OpenOffice 4.1.1: Apache OpenOffice: Kostenlose Alternative zu Microsoft Office. Apache OpenOffice bringt ...
Read more