Page 178 - IT_V1.0_Class10
P. 178

Step 2:  Select the desired position of the sheet (before or after the Sheet 1).

              Step 3:  Select New sheet radio button option from Sheet section.
              Step 4:  Type the number of sheets required.
              Step 5:  Click on OK button. New sheet/s will be inserted.








                                                                        2
                                                                    1
                                                                        3

                                                                        4








                                                                        5


              To insert sheet or sheets from another spreadsheet, perform the following steps:

                      Step 1 and 2 remains same.
              Step 3:  Choose From file radio button option from Sheet section.
              Step 4:  Click on Browse and select the spreadsheet or sheet that needs to be inserted. Ensure Link check
                      box option to be checked  to update the data values. If data values are changed in original sheets,
                      these will also be updated in new destination.












                                         3
                                                                                           4






                                                                                           5


              Step 5:  Click on OK button. New sheet/s will be inserted.
              Renaming Sheets

              At the bottom of each spreadsheet window, there are small tabs that indicate the names of the sheets in the
              spreadsheet. By default, their names are Sheet1, Sheet2, Sheet3 and so on. These names are not very descriptive.
              Renaming a sheet as per its content gives a brief idea about the stored content. For instance, if sales of different
              months by a salesman are stored in different sheets, names of the sheets can be renamed by month names.



                176     Information Technology Play (Ver 1.0)-X
   173   174   175   176   177   178   179   180   181   182   183