Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 33 - 2629_Devagiri_C-6
P. 33

    COPYING AND MOVING WORKSHEETS

                     In Excel, you can easily copy or move worksheets to reorganise your data.

                     COPYING A WORKSHEET
                     You  can  create  a  duplicate  of an existing  worksheet  within  the  same  workbook  or another
                     workbook. To copy a worksheet, follow the given steps:

                                                                                 4    Select whether to move the
                                                                            worksheet to a new or existing workbook.

                                                                                            5    Select the position where
                                 2    Select the Move or                                    you want to place the worksheet.
                                         Copy option.

                                                                             6     Click the OK button to copy the
                                                                              worksheet to the selected location.

                      1    Right-click on the worksheet
                               tab you want to copy.

                                                                   3    Click on the Create a copy checkbox.

                     Alternatively, you can drag the worksheet tab while holding the Ctrl key to create a copy of the
                     worksheet in the same workbook.

                     MOVING A WORKSHEET

                     You can relocate a worksheet to a different position within the same workbook or transfer it to
                     another workbook. To move a worksheet, follow the given steps:

                                                                                    3    Select whether to move the
                                                                               worksheet to a new or existing workbook.

                        2    Select the Move
                           or Copy option.
                                                                                              4     Select the location
                                                                                             to place the worksheet.

                         1    Right-click on the worksheet
                                 tab you want to move.

                                                                                       5    Click the OK button to move the
                                                                                       worksheet to the selected location.

                                                                                                                      31
                                                                                                         Explore Excel

| 28 29 30 31 32 33 34 35 36 37 38 |