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 following commands are available in the menu:
▪The command Insert creates a new worksheet.
▪The command Copy creates a copy of a worksheet. A submenu opens where you can choose the position of the copy (within the other worksheets).
| If you want to place the copy in a different (currently opened) 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 a submenu opens where you can choose the position.
▪The Delete command removes a worksheet along with its contents.
| Alternatively you can find the command under Home | group Cells | Delete | Delete worksheet. |
▪The Rename command lets you change the name of a worksheet.
| Tip: You can also simply double-click on the worksheet in the register at the bottom. |
▪The Hide command hides a worksheet.
| 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 still uses them as a source for calculations. |
▪The Show command makes hidden worksheets (see Hide command) 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 the sheet 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.
▪The command Page Setup (in the context menu of the worksheet register) allows you to change page layout options like paper format, page margins, etc. for a worksheet. The dialog box corresponds to the ribbon tab Layout | command group Page Setup
. 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. It opens a submenu with the following entries:
| 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. |
▪With the Properties command you can make general settings for a worksheet. For more information, see Worksheet properties.
Tip: As described in the section Working with the worksheet register, you can select multiple worksheets in the worksheet register. Some of the commands mentioned (for example, Hide) can then be applied to all selected sheets at the same time.
Note: If you enable workbook protection for a document, from now on no more changes to the worksheet register can be made in the document. Also the ribbon commands under Insert | Sheet are no longer available. For more information, see Workbook protection.