Working in a Workbook part II

Let’s start our continuous lesson.

Copying and moving worksheets: -

Suppose that you using a worksheet in a workbook and the same worksheet and data also required for another workbook, and then you have two choices that you create a new worksheet as it is or you can copy the worksheet from your previous workbook. I think the second option is much easier than first once, what you think?

To copy/move a sheet, in the same workbook; do this:

1) By your mouse select the sheet which you want to copy or move.

2) Now if you want to copy within the same workbook, press and hold down Ctrl key and drag the sheet tab to its new location. A copy of the sheet is formed in the new location with a logical name of new sheet tab.

3) How ever if you want to move the sheet within the original workbook drag the sheet tab to the location where you want to move the worksheet. Your sheet tab changed its position from old to new position.

Copy/move between workbooks; do this:

1) Open the both workbooks which are to be used.

2) Click on the Windows menu from the menu bar then select Arrange. Select desired arrangement, Example: - Tiled, etc.

3) To copy press and hold down the Ctrl key then select the sheet tab which you want to copy and dragging it to the new workbook in which place you want to copy it.

4) To move sheet between workbooks, Select the sheet tab and drag it to the new workbook to its new location.

For copy/move through menu command; does this: -

1) Open the both workbooks.

2) Activate the workbook from which you want to copy/move the sheets click the edit menu from the menu bar and then select Move or copy sheet…. a dialog box is appear.

3) Choose you choice.

4) From the To book: in drop down list select the name of the workbook where you want to move/copy the worksheet. If you want to move the sheet in a new workbook select new workbook.

5) In the before sheet: select the name of the sheet before which you want to insert the sheet.

6) Press the ok button

Note: - alternatively you move/copy your sheet by right click of your mouse over the sheet tab which you want for the same then select move from the shortcut menu.

Bookmark this post: