Home | | Computer Technology 11th std | Renaming Worksheets - OpenOffice Calc

Chapter: 11th Computer Technology : Chapter 10 : Functions and Chart

Renaming Worksheets - OpenOffice Calc

The default name of a new sheet is Sheet-n, where n is a number. There are two methods to give a more meaningful name to a sheet.

Renaming Worksheets

 

The default name of a new sheet is Sheet-n, where n is a number. There are two methods to give a more meaningful name to a sheet.

 

Method 1:

• Double-click on a Sheet in which you want rename

• A small “Rename Sheet” box is appears as shown in Figure 10.6


• Type a new name and click “OK” button.

Method 2:

 

• Right-click on a sheet tab and choose Rename Sheet option from the pop-up menu now.

• Now Rename Sheet dialog box appears and type a new name and then click on ok button.


 

Inserting and Deleting Worksheets

 

When you create a new worksheet, three sheets are there by default. If needed, one or more new worksheets can be added or deleted.

 

Inserting Worksheets

 

There are different ways to insert a new sheet with existing worksheets.

 

Step 1:

• Right-click on a sheet tab and choose Insert Sheet option from the pop-up menu now. (or)

• Choose Insert Sheet option from the menu bar.

(or)

• Click the space bar between last sheet and horizontal scroll bar.


 

Step 2:

• “Insert Sheets” dialog box appears.


 

In this dialog box,

• Set position by clicking “Before current sheet” or “After current sheet”. If you select “Before” the new sheet(s) will inserted left side of the active sheet ie., selected sheet. If you select “After”, the new sheet(s) will inserted right side of the active sheet.

• Type or spin the number of sheets you need to insert. If you type or spin one sheet, Name box will be activated, and you can enter new name of the sheet to be inserted. If you set more sheets, Name box will be disabled.

• The minimum number of sheet must be one and maximum will be 253 (OpenOffice Calc 4.1.5).

• Finally, click OK button.

 

Deleting Worksheets

 

In a worksheet sheets can be deleted individually or in groups.

 

To delete single sheet:

1. Right-click on the tab of the sheet which is to deleted and choose. Delete Sheet from the pop-up menu, or

2. Choose Edit Sheet Delete from the Menu bar.


3. Either way, an alert will ask if you want to delete the sheet permanently. Click Yes.

 

To delete multiple sheets:

To delete multiple sheets, select them as mentioned earlier and either right-click over one of the tabs and choose Delete Sheet from the pop-up menu, or choose Edit Sheet Delete from the menu bar. Rest of the procedure are similar to delete a single sheet what you learnt earlier.

 

Study Material, Lecturing Notes, Assignment, Reference, Wiki description explanation, brief detail
11th Computer Technology : Chapter 10 : Functions and Chart : Renaming Worksheets - OpenOffice Calc |


Privacy Policy, Terms and Conditions, DMCA Policy and Compliant

Copyright © 2018-2023 BrainKart.com; All Rights Reserved. Developed by Therithal info, Chennai.