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
   189   190   191   192   193   194   195   196   197   198   199