Working with Sheets

The following operations are available on working with sheets:

Adding a 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.

Deleting Sheet

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.

Renaming Sheet

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.

Copying Sheet

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.

Hiding or Showing Sheet

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.

Moving Sheet

To reorder sheets, hover the cursor to the sheet tab. The cursor will change for . Drag the sheet to the required position.

See also:

Adding a New Sheet and Working with It