Going three-dimensional

<< Click to Display Table of Contents >>

Going three-dimensional

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.

An example: You record the balance sheets of several branches of your company on three worksheets. Now you could create a fourth worksheet that, for example, sums the results of the other three sheets.

To add a new worksheet, use the ribbon command Insert | group Tables | Sheet worksheet_icon. The program opens a dropdown menu, where you can choose the Insert command.

Tip: You can create a new worksheet faster with the worksheet_add_icon icon in the worksheet register.

worksheet_tabs

The worksheet register at the bottom of the document

To switch between the individual sheets, simply click on the desired worksheet tab in the worksheet register with the mouse.

For more information on this topic, see Working with multiple worksheets.