OpenOffice/Calc 3/Getting to know the application/Handling worksheets

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.

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.

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.