|Working with Spreadsheets in OpenOffice.org Calc|
|The application||Making a spreadsheet | The Calc screen | Saving | Handling worksheets | Practice | Summary|
Recall that a worksheet is a single page, or sheet, in a spreadsheet and that by default, a spreadsheet consists of three worksheets. In this section, we will perform some basic tasks with worksheets.
Rename a worksheet
The default names of worksheets are Sheet1, Sheet2, Sheet3, displayed on the 3 tabs in the lower-right corner. Some projects will be better organized by locating different aspects of the work onto different sheets. In these instances you will want to rename the sheets to accurately reflect the contents. Here's how.
Switch between worksheets
To switch between the different worksheets, click on the tab of the worksheet you wish displayed.
Insert a new worksheet
Duplicate (or copy) a worksheet
You may duplicate a worksheet either within the same spreadsheet or between spreadsheets. The other spreadsheet may be one that is already open or a new one to be created. In all cases, you will use the Copy command to carry out this task.
Duplicate within a spreadsheet
Duplicate between spreadsheets
Move a worksheet within a spreadsheet or between spreadsheets
The process for moving a worksheet within a spreadsheet or between spreadsheets is virtually the same as duplicating a worksheet, except that you do NOT tick the Copy checkbox in the Move/Copy Sheet dialog. When the Copy checkbox is left blank, the worksheet is moved.
Delete a worksheet
- Right-click on the tab of the worksheet you wish to delete.
- Select Delete Sheet... in the menu that appears. A dialog will appear asking you to confirm that you wish to permanently delete the current sheet.
- Click Yes to confirm that you wish to delete the worksheet or No if you do not wish to.