Page 257 - open office
P. 257

Renaming Sheets

                 The existing worksheet can also be renamed. To rename a sheet:
                 Step 1:  Double-click on the specified sheet from the Sheet tab or right-click on it and select the  Rename
                         Sheet’ option. The ‘Rename Sheet’ sub-window appears.

                 Step 2:  Type a new name for the sheet.
                 Step 3:  Click on the  OK  button. The selected sheet will be renamed with the new name.

                                                    Sheet Tabs Before      Sheet Tabs A er
                                                    Renaming Sheet         Renaming Sheet

                                                     1










                                                                 2               3


                 Moving Sheet

                 By the ‘Moving sheet’ option, a worksheet can be moved to a different order of sequence as required. To
                 move a sheet:

                 Step 1:  Right-click on the sheet to be moved.
                 Step 2:  Click on the option ‘Move/Copy Sheet’. Select the sheet before/after which the selected sheet is to
                         be placed.

                 Step 3:  Select the desired position and click on  OK .
                 Step 4:  Click on the ‘Copy’ checkbox to create a duplicate copy of the sheet.
















                                                                                                 4



                 Hide / Unhide Sheet

                 User can hide worksheet(s) of a workbook that can be displayed later. To hide a worksheet:
                 Step 1:  Select the sheet(s) to be hidden.

                 Step 2:  Select the option  Sheet  from the  Format  menu. Click on the  Hide  option.

                 Step 3:  Click on the  OK  button.


                                                                                     Working with Spreadsheet       25
   252   253   254   255   256   257   258   259   260   261   262