OpenOffice.org OpenOffice - 3.3 Základní průvodce stáhnout pdf (Strana 260)

100

101

Why use multiple sheets?

Chapter 1 introduced the concept of multiple sheets in a spreadsheet. Multiple sheets

help keep information organized; once you link those sheets together, you unleash

the full power of Calc. Consider this case.

John is having trouble keeping track of his personal finances. He has

several bank accounts and the information is scattered and disorganized.

He can’t get a good grasp on his finances until he can see everything at

once.

To resolve this, John decided to track his finances in OOo Calc. John knows

Calc can do simple mathematical computations to help him keep a running

tab of his accounts, and he wants to set up a summary sheet so that he can

see all of his account balances at once.

This can be accomplished easily.

Note

For users with experience using Microsoft Excel, a Calc sheet is called

either a sheet or worksheet in Excel. What Excel calls a workbook, Calc

calls a spreadsheet (the whole document).

Setting up multiple sheets

Chapter 1 gives a detailed explanation of how to set up multiple sheets in a

spreadsheet. Here is a quick review.

Identifying sheets

When you open a new spreadsheet it has, by default, three sheets named Sheet1,

Sheet2, and Sheet3. Sheets in Calc are managed using tabs at the bottom of the

spreadsheet, as shown below.

Figure 256: Default sheet tabs

Renaming sheets

Sheets can be renamed at any time. To give a sheet a more meaningful name:

• Enter the name in the name box when you create the sheet, or

• Double click on the sheet tab, or

• Right-click on a sheet tab, select Rename Sheet from the pop-up menu and

replace the existing name.

260 OpenOffice.org 3.3 Calc Guide

1 2 ... 255 256 257 258 259 260 261 262 263 264 265 ... 433 434

Komentáře k této Příručce

Žádné komentáře

OpenOffice.org OpenOffice - 3.3 Základní průvodce Strana 260

Komentáře k této Příručce

Související produkty a manuály pro Software OpenOffice.org OpenOffice - 3.3