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.

Follow Along
Menu displayed from right-click on Sheet 1 tab In OpenOffice.org Calc: Move the mouse cursor to Sheet 1. Right-click, a menu of options displays. Select Rename Sheet.... In the Rename Sheet dialog, enter the new name. Select OK. The new name is now displayed in the Sheet 1 tab.

Switch between worksheets

To switch between the different worksheets, click on the tab of the worksheet you wish displayed.

Insert a new worksheet

Follow Along
Inserting a new worksheet into the spreadsheet file Click on the tab next to the location where you wish to insert the new worksheet. Select Insert > Sheet.... The Insert Sheet dialog This displays the Insert Sheet dialog Select the Position -- before or after the current sheet. To insert a blank worksheet, select New sheet, indicating the number of sheets you wish to insert and if only one, the name of that sheet. To copy a file from another spreadsheet, select From file and locate the particular spreadsheet file and sheet using the Browse function. Click OK The new sheet displays in the spreadsheet.

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

Follow Along
Select the worksheet you wish to duplicate. Move/Copy Sheet... command in the right-click menu Right-click and then select Move/Copy Sheet... in the menu. Move/Copy Sheet dialog The Move/Copy Sheet dialog displays. Tick the Copy checkbox. Select the position for the duplicate in the Insert before window. Click OK Rename the duplicate worksheet, as needed.

Duplicate between spreadsheets

Follow Along
Select the worksheet you wish to duplicate. Right-click and then select Move/Copy Sheet... in the menu. Copying a worksheet to a new spreadsheet file In the To document window select either The name of the spreadsheet in which you wish to duplicate the worksheet and select the position in this spreadsheet. -new document-, if you wish to create a new spreadsheet for the duplicate worksheet. Tick the Copy check box Click OK

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.

|