5.5.2 Working on a single workbook

In this section you will learn to do simple operations like copying, renaming, moving and deleting within a workbook.

5.5.2.1 Copying sheets

In the previous lesson, you learn the mechanism of copying data in one portion of the worksheet to another portion of the same worksheet. In this section we’ll see how to copy a sheet within your current workbook as a matter of fact the copying is possible  to another workbook as well.

Here we’ll try our hand on how to copy sheets within a workbook.

1.       Open the SALES worksheet or any other worksheet of your choice.

2.       Select the entire worksheet.

3.       Now click on edit menu. You’ll find an option called Move or Copy Sheet

4.       Move or Copy dialog box appears. This dialog box contains three boxes which need a response from your side. The boxes are : To Book, Before Sheet, Create a Copy.

5.       In the To Book: box by default you will see the name of the currently open worksheet, which in our case is SALES.xls. In case you need to do that you can do so now.

6.       In Before sheet: portion click on Sheet 2 or any other sheet  in which you wish to copy.

7.       Next in the bottom most part of the dialog box, click on the box for Create a copy.

8.       Finally click on OK. The new worksheet will be placed before Sheet2 of the workbook. It will have the copy of Sheet1.  See the worksheet tabs below. The tab 2  says sheet1 (2) which means that you are on the second sheet carrying the data of the first sheet.

9.       In case you wish to go to Sheet1. Click on its tab.

10.   Finally, if you desire to keep SALES worksheet on two sheets, save the current version by click on Save button.

5.5.2.2 Renaming sheets

The tabs, which appear carry a default label of Sheet1, Sheet2 and Sheet3. You can always rename them in order to provide another name for it, which may be more representative of the characteristics of the worksheet. Lets see how to do this: -

1.       With sales.xls sheet open, click on Sheet1 (2) tab so as to make it open.

2.       Double click on this tab and you’ll see that the label Sheet1 (2) tab gets selected.

3.       Type anything here and press enter say Copy of Sheet1.

Just give a look at the bottom and you’ll find that the name has been changed.

5.5.2.3 Moving sheets

A sheet can be moved within a workbook. We’ll try to move newly renamed sheet to between sheet 2 and 3.

1.       Point to the copy of Sheet1 tab and hold down the left mouse button. The pointer is now an arrow with a sheet attached to it.

2.       Drag the sheet pointer until it sits between Sheet2 and Sheet3 of the Sales workbook. Excel indicates with an arrowhead where it will place the copy of Sheet 1.

3.       Release the mouse button. The Copy of Sheet1 appears between Sheet2 and Sheet3.

5.5.2.4 Adding Sheets

You can add a new sheet to the workbook by using the worksheet command on the Insert menu. Excel inserts a new sheet in front of the current sheet.

1.       Move to the last sheet of the current workbook or to any other desired sheet before which, you wish to insert the new sheet.

2.       Click on the Insert menu and select worksheet command. Excel inserts a new sheet before sheet3.

5.5.2.5 Deleting Sheets

Before you delete a sheet from the workbook, always display it. Excel permanently deletes the sheet , therefore it is ore important to have a visual confirmation first.

Here we will try to delete Sheet4 that you have just added to the Sales workbook.

1.       Make Sheet4 active.

2.       Click on the Edit Menu and choose the Delete Sheet command. Excel warn you that the sheet will be permanently deleted.

3.       Click OK to go ahead on your decision.

5.5.3 Working With Multiple Workbooks

Now you had worked with multiple worksheets within one workbook. Excel permits user to work with multiple workbooks at a time.  You can perform certain basic functions like Copying, moving etc. within workbooks as well.  In this section you would do these between the two worksheets of two different workbooks. Let us get going;

1.       Open SALES.xls worksheet in case it is not open.

2.       Click on a New Workbook button. Excel displays a new workbook called Book2.

3.       To see both the workbooks at the same time, choose Arrange… from the Window menu.

4.       Arrange Windows dialog box appears. Click OK to accept the default Tiled option.

5.5.3.1 Copying Entries Between Workbooks

The procedure for copying information between workbooks is the same as for copying between sheets in one workbook. Take up the steps listed below:-

1.       Active Sales.xls by clicking its title bar. Title bar is the one where name of the worksheet is shown.

2.       Select A1 to b5.

3.       Click on Copy Button.

4.       Next Click cell A1 in Book2.

5.       Finally, click on the pate button.

6.       Increase the width of column B in Book2 worksheet so as to accommodate its contents properly within the column.

5.5.3.2 Moving Sheets Between Workbooks.

A sheet can be easily moved from one workbook to another. In the following example you will move Copy of Sheet1 tab worksheet from SALES.xls to Book2. But before going on with this first remove the any existing contents of Book2 worksheet b deleting its contents.

1.       In sales.xls worksheet point to the Copy of Sheet1 tab and hold down the left mouse button. The pointer is now an arrow with sheet attached to it.

2.        Drag the sheet pointer until it sits between Sheet2 and sheet3 of the Book2 workbook. Excel indicates with an arrowhead where it will place the copy of Sheet1 worksheet.

3.       Release the mouse button. The copy of sheet1 worksheet now appears in Book2.

5.5.4 Saving Workbooks

The final thing to be done is to be save the work you have done so far.

1.       Click on save button. At this moment the currently active workbook will get saved. If you have saved the workbook earlier, just at the stroke of a click on the Save Button, it gets re-saved again. In case it is unsaved, excel will ask for a new suggested name of Worksheet and destination directory, where it has to be saved.

Save As dialog box is now onscreen. It is showing Book2 as unsaved earlier.

2.       Provide a new name and path if you desire and click on OK. We have given it a name as Copy. Now make the other workbook active and save it with its new set if information.

Copyright © 2001 Selfonline-Education. All rights reserved.