Page 258 - open office
P. 258
3
The sheet with its sheet tab disappears, just as if the sheet was deleted but the sheet still exists in the
workbook. To unhide the same sheet:
Step 1: Select the ‘Sheet’ option from the ‘Format’ menu and click on the ‘Show’ option.
The ‘Show Sheet’ dialog box appears along with a list of hidden sheets.
Step 2: Select the sheet to unhide and click on the OK button. The hidden sheet(s) will re-appear in the
worksheet.
NAVIGATION
Navigation is a feature in Calc by which the cursor can be placed anywhere in a sheet directly. To move directly
to any cell:
Step 1: Click on avigation from the Standard Toolbar . Or, select the option avigator from the iew
menu.
Step 2: A navigation window opens. In the column and row field, specify the column and row number
respectively and then press the ‘Enter’ key. The cursor moves to the typed address of the
desired cell.
Lab Assignment ‘n Activity Subject Enrichment
Complete the following activities and tick on the circle.
Begin Calc and open the previously saved file Cricket .
Add a new sheet after Sheet1 and rename the sheet as Scores .
Move the newly added sheet to the end position.
Copy the entire content of the first sheet to the last sheet.
Hide the last sheet and then Unhide it.
Using avigator , move to the different parts of an opened workbook.
Add another sheet before Sheet1 and rename as Players .
Copy Player Name, Country into the newly added sheet.
Delete the unused sheet from the worksheet.
Hide the sheet Scores .
25 Touchpad Information Technology-IX

