When you open a new spreadsheet it has, by default, one sheet named Sheet1. Setting up multiple sheetsĬhapter 1, Introduction, gives a detailed explanation of how to set up multiple sheets in a spreadsheet. Both Excel and Calc use the terms sheet and worksheet. 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.įor users with experience of using Microsoft Excel: what Excel calls a workbook, Calc calls a spreadsheet (the whole document). To resolve this, John decides to track his finances in LibreOffice Calc. He can’t get a good grasp on his finances until he can see everything at once. He has several bank accounts and the information is scattered and disorganized. John is having trouble keeping track of his personal finances.

Multiple sheets help keep information organized once you link those sheets together, you unleash the full power of Calc. Using multiple sheets Why use multiple sheets?Ĭhapter 1, Introduction, introduced the concept of multiple sheets in a spreadsheet. For a more detailed list, see the application Help and Appendix A (Keyboard Shortcuts) to this guide.Ĭontrol+click and/or right-click depending on computer setup The table below gives some common substitutions for the instructions in this book. Some keystrokes and menu items are different on macOS from those used in Windows and Linux. Other versions of LibreOffice may differ in appearance and functionality. Please direct any comments or suggestions about this document to the Documentation Team’s mailing list: you send to a mailing list, including your email address and any other personal information that is written in the message, is publicly archived and cannot be deleted. You may distribute it and/or modify it under the terms of either the GNU General Public License ( ), version 3 or later, or the Creative Commons Attribution License ( ), version 4.0 or later.Īll trademarks within this guide belong to their legitimate owners. This document is Copyright © 2021 by the LibreOffice Documentation Team.

Libreoffice calc