Working with the worksheet register

<< Click to Display Table of Contents >>

Working with the worksheet register

The worksheet register at the bottom of the document window displays tabs for each worksheet in the current document.

worksheet_tabs

The active worksheet is highlighted.

You can use the worksheet register to perform the following actions:

Switching between worksheets

To switch to a different worksheet, simply click on its tab in the worksheet register.
Note: If there are more worksheet tabs than can be displayed at the same time, you can scroll through the list using the arrows displayed to the left of the register.

Tip: You can also switch between the worksheets via the keyboard: Use Ctrl+Tab to move to the next worksheet and Ctrl+Shift+Tab to move to the previous worksheet.

Changing the order of worksheets

The worksheet register can also be used to move worksheets, thus allowing you to change their order.
To do so, left-click for about one second on the tab of the sheet that you want to move and, while still holding down the mouse button, drag the tab to the desired position in the worksheet register.

Editing multiple worksheets at the same time

You can select multiple worksheets in the worksheet tab and edit them simultaneously. To select multiple worksheets, press and hold the Ctrl key while you click on their tabs in the register. (Mac users: Cmd key)
If multiple worksheets are selected, changes made to one of the worksheets will affect all of the other selected worksheets in exactly the same way.
Examples:
If you change the formatting of cells, your changes will also be applied to the same cells in the other selected worksheets.
When you edit or delete the content of a cell, the same cell in the other selected worksheets will be changed in the same manner.
Changes to the cell size (ribbon tab Layout | group Cells) also affect all selected worksheets.
Tip: To select multiple worksheets at the same time, use the Shift key instead of Ctrl. To deselect, click again with the mouse and Ctrl or Shift on the tab(s).

Managing worksheets

When you right-click on one of the tabs in the worksheet register, the program will display a context menu that contains all commands for creating and managing worksheets. For more information, see the next section Managing worksheets.

Creating a new worksheet

The tab to the right of the worksheet register with the worksheet_add_icon icon serves as a "shortcut" for creating new worksheets: When you click on it, PlanMaker immediately creates a new worksheet.