Going three-dimensional

<< Click to Display Table of Contents >>

Going three-dimensional

PlanMaker spreadsheets do not necessarily have to consist of a single worksheet. You can also stack several worksheets on top of each other – just like a stack of papers. Thus, PlanMaker documents are 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, thus enabling you to perform "three-dimensional" calculations as such.

For example: You record the balance sheets of several branches of your company on three worksheets. You could now create a fourth worksheet and use it to calculate, for example, the sum of the results of the other three sheets.

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

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

worksheet_tabs

The worksheet tab at the bottom of the document

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

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