Page 182 - CA 165 ver 1.0 Class 9
P. 182
The sheet with its sheet tab disappears, just as if the sheet was deleted but the sheet still remains in
the workbook.
To unhide the same sheet:
Step 1: Select ‘Sheet’ option from ‘Format’ menu and click on
the ‘Show’ option.
Step 2: The ‘Show Sheet’ dialog box appears along with a list
of hidden sheets.
Step 3: Select the sheet to unhide and click on the ‘OK’ button.
The hidden sheet(s) will re-appear in the worksheet.
NAVIGATION
We can move in OpenOffice from a cell to another cell or from one sheet to the other using the
navigation feature.
Navigating from cell to cell
We can navigate from one cell to another cell in the following ways:
l Using the mouse: Click on the cell in which you wish to work.
l Using a cell reference: Type the cell address of the destination cell in the Name box and press
Enter or just click into the Name box, delete and rewrite the destination cell address.
l Using the Navigator: Click on the Navigator button in the Standard toolbar. Type the column
and row address in the fields labeled Column and Row, and press Enter.
Navigating from sheet to sheet
We can navigate from one sheet to another in the following ways:
l Using the mouse: Click on the desired sheet on which you wish to work.
l Using the Navigation Bar/Sheet tab arrows: A navigation bar/sheet tab arrows is/are present
at the bottom of the Calc window, adjacent to the sheet tabs. It can be used to move to the next,
previous, first or the last sheet. This bar gets activated only when there are sheets which cannot
be seen in the sheet tabs and cannot be accessed directly by a mouse click.
Navigation bar/Sheet tab arrows
180 Touchpad Computer Applications-IX

