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.
|| 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.