Page 203 - Trackpad 402_Class-X_Final
P. 203
• Position: This option is used to specify the position of the sheet to be inserted. It provides two options
Before current sheet. and after current sheet
• Sheet: New sheet with default 1 but if you want the number of sheet to be inserted then increase the
number in No of sheets
• Name: The default name is Sheet4 but if you want to give another name then type a new name in the Text
box.
• From File: This option is used if you want the sheet to be inserted from another file.
• Click Browse and select the file; a list of the available sheets appears in the box. Select the sheet to import
in the currently opened workbook.
• Link: If this option is selected then the sheet taken from some other file into the current sheet is linked
instead of copy which means any changes done in the original sheet will be reflected in the current sheet.
Deleting an Existing Sheet
If you want to delete a worksheet, then follow the given steps:
Step 1: Right-click on the sheet tab and Select Delete sheet option. The given dialog box opens to ask for confirmation
of deletion of sheet:
Step 2: Click on Yes button to delete the sheet.
uiz Bee 1. Is it possible to link worksheets.
2. Is it possible to switch between scenarios.
3. Mention the other way to delete a sheet.
Renaming a Sheet
The default name of the sheet can be changed by renaming a worksheet with a new name. The steps to rename a sheet
are as follows:
Step 1: Double-click on the Sheet tab.
Electronic Spreadsheet (Advanced) 203

