![]() Use one of these other methods to insert more than one sheet, to rename the sheet at the same time, or to insert the sheet somewhere else in the sequence. This inserts one new sheet without opening any dialog, with a default name ( Sheet2, for example) and with the new sheet’s tab positioned at the right hand end of the sheet tabs. The fastest method is to click on the Add Sheet (+) icon located to the left of the sheet tabs, at the bottom of the spreadsheet. There are several ways to insert a new sheet. ![]() Sheets in Calc are managed using tabs located at the bottom of the spreadsheet. You can specify a different number of sheets to be created in a new document, or a different prefix name for new sheets, by going to Tools > Options > LibreOffice Calc > Defaults on the Menu bar ( Figure 1).įigure 1: Options LibreOffice Calc Defaults dialog 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.
0 Comments
Leave a Reply. |