Worksheet

Notice that in the lower left corner of your spreadsheet, next to a bunch of arrow buttons, are tabs called Sheet1, Sheet2 and Sheet3. These tabs represent the worksheets where you will enter your data.

The rows and columns grid that you see on the screen is the worksheet represented by Sheet1.

1. Click on the Sheet2 tab.

A blank spreadsheet opens.

2. Click on Sheet 3.

Another blank spreadsheet opens.

You can compare these worksheets to the pages in a notebook. In the same way that a notebook has many pages, a workbook can contain many worksheets. A worksheet is also called a spreadsheet.

This feature enables you to create separate spreadsheets for all related topics in one common Excel file. For example, the Class9_results.xls file can hold separateworksheets for the First Terminal Examination Results, Second Terminal Examination Results, etc.

Let’s rename the first worksheet as First Terminal Examination Results.

To rename a worksheet

1. Double click on the tab.

2. The name Sheet1 is selected.

3. Enter the new name First Terminal Exam Results to overwrite the previous name, that is Sheet1.

Here are some more ways you can manipulate a worksheet.

To Copy a Worksheet

1. Click Edit > Move or Copy Sheet

2. A dialog box opens.

3. In the Before Sheet section, click on the sheet before which you want to put the new sheet.

4. At the bottom of the dialog box, put a check mark in the box Create Copy.

5. Click OK

To Insert a Worksheet

1. Click Insert > Worksheet.

2. The worksheet will be inserted before the worksheet the cursor is in.

To Move a Worksheet

1. Click on the sheet tab and drag it to the desired location.

To Delete a Worksheet

1. Put the cursor in the worksheet to be deleted.

2. Click Edit > Delete Sheet.

3. Click on OK.

TIP: To quickly copy a sheet, hold down the Ctrl key while dragging the sheet tab to the right. When the triangle moves to the right of the sheet tab, let go of the mouse button.