If you choose the ribbon command Insert | group Tables | Sheet 
, a dropdown menu opens with commands for managing worksheets.
Tip: These commands (and a few more) also appear in the context menu by right-clicking on the desired tab in the worksheet register at the bottom.
The menu contains the following commands:
▪The command Insert creates a new worksheet.
▪The command Copy creates a copy of the current worksheet. To do so, the program displays a submenu in which you can choose where the copy should be placed (within the other worksheets).
| If you want to place the copy in a different (currently open) document or in a new document, choose the option To another document. |
▪The command Move moves the worksheet to a different location. As with the command Copy, the program opens a submenu in which you can choose the location.
▪The command Delete removes a worksheet along with its contents.
| Alternatively, you will find the command under Home | group Cells | Delete | Delete worksheet. |
▪The command Rename lets you change the name of a worksheet.
| Tip: You can also simply double-click on the worksheet in the worksheet register at the bottom. |
▪The command Hide ensures that the worksheet is hidden.
| Alternatively, you can use the command Home | group Cells | Visibility | Hide sheet. |
| Hidden worksheets are invisible. They cannot be displayed or edited, and they do not even appear in the worksheet register. However, PlanMaker continues to use them for calculations. |
▪The command Show makes hidden worksheets (see command Hide) visible again.
| Alternatively, you can use the command Home | group Cells | Visibility | Show sheet. |
| This opens a dialog box that shows all hidden worksheets. In the list, click on the sheet that you want to show again. Use the Select all button to select all hidden sheets from the list. Press OK to make the selected worksheets visible again. |
▪The commands Select all sheets and Deselect sheets (in the context menu of the worksheet register) select or deselect all worksheet tabs in the worksheet register.
▪You can choose the command Page Setup (in the context menu of the worksheet register) to make settings such as page size, page margins, etc., for a worksheet. The dialog box corresponds to the ribbon tab Layout | command group Page Setup
. For more information, see Page setup.
▪The command Copy page setup (in the context menu of the worksheet register) allows you to copy the page setup of a worksheet – i.e., all settings made with Page setup – to another worksheet. The program opens a submenu with the following commands:
| To all sheets: Copies the page setup from the current worksheet to all other sheets. |
| From...: Copies the page setup from any other worksheet to the current worksheet. |
▪You can choose the command Properties to make general settings for a worksheet. For more information, see Changing worksheet properties.
Tip: As previously described in Working with the worksheet register, you can select multiple worksheets in the worksheet register. Some of the aforementioned commands (for example, Hide) can then be applied to all selected sheets at the same time.
Note: If you enable workbook protection for a document, you can no longer make any changes to the worksheet register in it. The ribbon commands under Insert | Sheet are no longer available. For more information, see Workbook protection.