The following operations are available on working with sheets:
Add a sheet.
Delete sheet.
Rename sheet.
Copy sheet.
Hide/show sheet.
Move sheet.
To add a sheet, click the Add Sheet button next to sheet tabs or press SHIFT+F11. The sheet named Sheet N, where N is a sequence number of added sheet, will be added.
To delete sheet, select the Delete item in the drop-down menu of the Actions button to the right on the sheet tab. The sheet will be deleted. At least one sheet must be present in data entry form. The single sheet cannot be deleted.
To rename sheet, select the Rename item in the drop-down menu of the Actions button to the right on the sheet tab. Enter new sheet name on the tab. To save the name, press the ENTER key or click outside the sheet tab.
Sheet name can be saved in different languages depending on the current language selected in the login dialog box. For details see the Setting Up Multilingual Options section.
To copy sheet, select the Create Copy item in the drop-down menu of the Actions button to the right on the sheet tab. A new sheet with a default name will be added next to the copied sheet as its duplicate. A sheet is named as Sheet N(M) by default, where N - number of copied sheet, M - copy number.
To hide sheet, select the Hide item in the drop-down menu of the Actions button to the right on the sheet tab. The sheet will be hidden. In the drop-down menu of the All Sheets button hidden sheets are marked with the icon. To unhide the sheet, select it in the drop-down menu of the All Sheets button.
To reorder sheets, hover the cursor to the sheet tab. The cursor will change for . Drag the sheet to the required position.
See also: