Moving or Copying Sheet

To move a sheet:

  1. Hover the mouse cursor on the corresponding sheet tab, the cursor will look as .

  2. Click the tab, hold down it and drag the sheet to the required position.

To copy a sheet:

  1. Click the Actions button on the corresponding sheet tab.

  2. In the drop-down list select the Create Copy item.

A new sheet with a default name will be added next to the copied sheet as its duplicate. By default, the sheet is named SheetN(M), where N - number of the copied sheet, M - number of copy.

Features of Creating Report Sheet Copies

When copying a report sheet, one can create copies of all objects located on the report sheet.

When a cell with a formula is copied, the formula is adjusted: if a "Sheet1"!A0 formula refers to the same sheet, the formula changes to "Sheet1(1)"!A0. The formula is not adjusted if it has reference to another sheet.

See also:

Adding a New Sheet and Working with It