dialog box appears (Refer Figure . ). Click "OK" Set position Where the new sheet will be inserted New Sheet Existing sheet from another file Figure . Insert Sheet dialog box 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 (OpenOffice Calc . . ) .
• Finally, click OK button. . . – Deleting Worksheets In a worksheet sheets can be deleted individually or in groups.
To delete single sheet: . Right-click on the tab of the sheet which is to deleted and choose. Delete Sheet from the pop-up menu, or . Choose Edit → Sheet → Delete from the Menu bar (Refer Figure .
). Selected Sheet Right click or Edit → sheet → Delete Figure . Delete Sheet . 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 deleting a single sheet what you learnt earlier. .
– Copy, Move and change the order of sheets Click and drag the sheet tab is the simple way to move the sheets. Menu also can be used to move sheets. . Right-click the sheet you want to move and select Move/Copy Sheet from the pop-up menu, or select Edit → Sheet → Move/Copy from the main menu