Chapter 3. Worksheets
Prev     Next

Chapter 3. Worksheets

Handling worksheets

Insert a new worksheet

A spreadsheet consists of one or more worksheets. The worksheets can be thought of as pages of the spreadsheets. By default, a spreadsheet consists of three worksheets. These are labelled Sheet1 to Sheet3.

New worksheets can be added to a spreadsheet.

  1. Click on the tab adjacent to the new worksheet.

  2. Insert->Sheet ...

    This displays the Insert worksheet dialogue.

  3. Choose the Position, before or after the selected sheet.

  4. Choose the No of sheets you wish to insert.

  5. If you choose to insert only one sheet, you may (optionally) enter the name of the sheet in the Name window.

  6. Click OK.

Rename a sheet

The default names of worksheets are Sheet1, Sheet2, and so on. You may change the name of a worksheet as follows:

  1. Right click on the tab of the worksheet that you wish to rename.

  2. Select Rename in the contextual menu that appears.

  3. Enter the new name in the dialogue.

  4. Click OK.

Delete a worksheet

  1. Right click on the tab of the worksheet you wish to delete.

  2. Select Delete in the contextual menu that appears.

    A dialogue will appear asking you to confirm that you wish to permanently delete the worksheet and its contents.

  3. Click Yes to confirm that you wish to delete the worksheet or Cancel if you do not wish to.

Duplicate a worksheet within a spreadsheet, between spreadsheets

There are two methods of duplicating a copy of a worksheet. One method is to copy the entire contents of a worksheet to the clipboard and then pasting this into another existing worksheet. In this section you will make a duplicate of the worksheet in a new worksheet.

Duplicate a worksheet within a spreadsheet

  1. Select the worksheet you wish to duplicate.

  2. Edit->Copy/Move worksheet .....

  3. Tick the Copy checkbox.

  4. Select the position for the duplicate in the Insert before window.

  5. Click OK.

  6. Rename the duplicate worksheet if you wish.

Duplicate a worksheet between spreadsheets

You may insert a copy of a worksheet in another open spreadsheet or into a new document.

  1. Select the worksheet you wish to duplicate.

  2. Edit->Copy/Move worksheet .....

  3. Click on the To Document drop down window.

  4. Select the name of the spreadsheet in which you wish to duplicate the worksheet and select the position in this spreadsheet.

OR

  1. Select New document in the To document window if you wish to create a new spreadsheet for the duplicate.

  2. Tick the Copy check box.

  3. Click OK.

Move a worksheet within a spreadsheet, between spreadsheets

The process of 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 dialogue.

Prev  Up  Next
Sort Data  Home  Chapter 4. Formulas and Functions