Operation Manual

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 Edit > Sheet > Move/Copy on the main
menu bar.
2) Select Move to move the sheet or Copy to copy the sheet.
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
you can create 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 1, Sheet 2, 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 formulae linked to other sheets in the previous location.
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 Edit > Sheet > Delete from on the main menu bar. Click Yes to
confirm the deletion.
To delete multiple sheets, select the sheets (see “Selecting sheets” on page 124), then right-click
one of the sheet tabs and select Delete Sheet from the context menu, or go to Edit > Sheet >
Delete from on the main menu bar. Click Yes to confirm the deletion.
Renaming sheets
By default, the name for each new sheet added is SheetX, where X is the number of the next sheet
to be added. While this works for a small spreadsheet with only a few sheets, it can become
difficult to identify sheets when a spreadsheet contains many sheets..
You can rename a sheet using one of the following methods:
• Enter the name in the Name text box when you create the sheet using the Insert Sheet
dialog (Figure 102 on page 126).
• Right-click on a sheet tab and select Rename Sheet from the context menu to replace the
existing name with a different one.
• Double-click on a sheet tab to open the Rename Sheet dialog.
Note
Sheet names must start with either a letter or a number; other characters including
spaces are not allowed. Apart from the first character of the sheet name, permitted
characters are letters, numbers, spaces, and the underscore character. Attempting
to rename a sheet with an invalid name will produce an error message.
128 | Getting Started with LibreOffice 4.0