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
   177   178   179   180   181   182   183   184   185   186   187