Page 181 - CA 165 ver 1.0 Class 9
P. 181

Step 2:   Finally the entire point Should appear as shown below.

                 Step 3:     ‘Rename Sheet’ sub-window appears. Give a new name to the sheet and click on the ‘OK’
                          button. The selected sheet will be renamed with the new name.








                                             Sheet Tabs Before       Sheet Tabs After
                                             Renaming Sheet          Renaming Sheet










                 Moving Sheet

                 By ‘Move Sheet’ option, a worksheet can be reordered in a new sequence, as desired. To move a sheet,
                 follow these steps:
                 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 ‘Copy’ checkbox to create a duplicate copy of the sheet.
















                                                                   4


                 Hide/Unhide Sheet

                 User can hide worksheet(s) of a workbook which can be displayed later. To hide a worksheet, follow
                 these steps:

                 Step 1:   Select the sheet(s) to be hidden.
                 Step 2:   Select the option ‘Sheet’ from the ‘Format’ menu. Click on the ‘Hide’ option.










                                                                                    Working with Spreadsheet     179
   176   177   178   179   180   181   182   183   184   185   186