Page 194 - CA_165_V2.0_C9_Flipbook
P. 194
2
The sheet with its sheet tab disappears, just as if the sheet was deleted but the sheet still remains in
the spreadsheet.
To unhide the same sheet: 2
3
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 spreadsheet.
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 labelled 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
192 Touchpad Computer Applications (Ver. 2.0)-IX

