Operation Manual

• Select the sheet where you want to insert a new sheet, then go to Insert > Sheet on the
main menu bar.
• Right-click on the sheet tab where you want to insert a new sheet and select Insert Sheet
from the context menu.
• Click in the empty space at the end of the sheet tabs.
• Right-click in the empty space at the end of the sheet tabs and select Insert Sheet from
the context menu.
Moving and copying sheets
You can move or copy sheets within the same spreadsheet by dragging and dropping or using the
Move/Copy Sheet dialog. To move or copy a sheet into a different spreadsheet; you have to use
the Move/Copy Sheet dialog.
Dragging and dropping
To move a sheet to a different position within the same spreadsheet, click on the sheet tab and
drag it to its new position before releasing the mouse button.
To copy a sheet within the same spreadsheet, hold down the Ctrl key (Option key on Mac) then
click on the sheet tab and drag it to its new position before releasing the mouse button. The mouse
pointer may change to include a plus sign depending on the setup of your operating system.
Using a dialog
The Move/Copy Sheet dialog (Figure 103) allows you to specify exactly whether you want the
sheet in the same or a different spreadsheet, its position within the spreadsheet, the sheet name
when you move or copy the sheet.
Figure 103: Move/Copy Sheet dialog
Chapter 5 Getting Started with Calc | 127