John Viestenz wrote:
----- Original Message -----
From: "Pete Holsberg" <[EMAIL PROTECTED]>
To: "OO" <[email protected]>
Sent: Saturday, December 10, 2005 2:50 PM
Subject: [users] Very Basic Calc Question
What is the purpose of having "sheets"?
I'm trying to convince a neighbor to switch from Microsoft Works to OOo
and I'm confused by what he says: "Sheets in Excel however do not work
that way, they are used to interact with each other, not as simple page
breaks."
He likes Works because he can insert page breaks, he says.
When you have a spreadsheet with multiple sheets in Calc, can't you
print each sheet separately?
Thanks.
--
Pete Holsberg
Columbus, NJ
Hi Pete;
As I recall, "Works" is flat. That is, it is limited to just one sheet per
workbook. (Maybe I'm, wrong; have not looked at Works in quite awhile).
Anyway, the advantage of having multiple sheets all in one workbook is that
you can do things in an additional dimension, if needed. For example,
similar worksheets for each month. Or worksheets for all the various income
tax schedules (one sheet for 1040, one for Schedule A, one for Schedule B,
etc). With all the sheets in the same workbook, it is very easy to keep
your data together, and link formulas from one sheet to another. Or, you
can easily format some sheets for whatever details you are collecting (save
Revenue), format a separate sheet for other details (say, Expenses), and
create various reports and summaries on still other sheets.
I couldn't survive without this capability!
Multiple sheets can, but do not have to, interact. Each sheet could just be
a separate, unrelated, worksheet.
I was under the impression that a good application for sheets was when
you had several related spreadsheets, each with a different set of
columns.
As for printing page breaks, it does not matter whether you have just one
sheet or many sheets, you can define your print ranges and breaks. So, yes,
you can print each sheet separately.
How do you insert a page break in Calc? Is it obvious? :-)
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
