Operation Manual

Using a dialog
Use the Move/Copy Sheet dialog (Figure 106) to specify exactly whether you want the sheet in
the same or a different spreadsheet, its position within the spreadsheet, and the sheet name when
you move or copy the sheet.
1) In the current document, right-click on the sheet tab you wish to move or copy and select
Move/Copy Sheet from the context menu or go to Sheet > Move or Copy Sheet... on the
Menu bar.
2) Select Move to move the sheet or Copy to copy the sheet in the Action area.
3) Select the spreadsheet where you want the sheet to be placed from the drop-down list in
To document. This can be the same spreadsheet, another spreadsheet already open, or a
new spreadsheet.
4) Select the position in Insert before where you want to place the sheet.
5) Type a name in the New name text box if you want to rename the sheet when it is moved
or copied. If you do not enter a name, Calc creates a default name (Sheet 2, Sheet 3, and
so on).
6) Click OK to confirm the move or copy and close the dialog.
Caution
When you move or copy to another spreadsheet or a new spreadsheet, a conflict may
occur with formulas linked to other sheets in the previous location.
Figure 106: Move/Copy Sheet dialog
Deleting sheets
To delete a single sheet, right-click on the sheet tab you want to delete and select Delete Sheet
from the context menu, or go to Sheet > Delete Sheet... on the Menu bar. Click Yes to confirm the
deletion.
Chapter 5 Getting Started with Calc | 133