Editing worksheets > Working with multiple worksheets

PlanMaker documents are not limited to single worksheets. As needed, you can stack several worksheets on top of each other – just like a stack of papers. PlanMaker documents are therefore also called workbooks. Each workbook can contain up to 2048 worksheets.

The main advantage of this is that calculations in one worksheet can also refer to cells in other worksheets of a workbook, in essence, letting you create "three-dimensional" calculations (see the section Calculating in three dimensions).

In this section, you will learn everything you need to know about working with multiple worksheets in a document. The following topics are covered:

▪Creating new worksheets

To create a new worksheet, use the ribbon command Insert | Sheet | Insert.

▪Working with the worksheet register

The worksheet register displayed at the bottom of the document window allows you to switch between your worksheets with a single mouse click. You can also use it to create, move and manage worksheets.

▪Managing worksheets

The context menu of the worksheet register and the ribbon command Insert | Sheet are both containing commands to manage worksheets (renaming, copying, moving sheets, etc.).

▪Calculating in three dimensions

In the last section, you will learn how to create calculations that refer to cells in other worksheets.

The following pages provide detailed information on these topics.