Working with workbooks
Multiple worksheets enable you to do some useful and powerful data analysis. You can think of multiple worksheets as working with a three-dimensional file. Each sheet has a height and width. The depth dimension comes from the layers of the worksheets. The first or last sheet in the workbook summarizes the detailed data contained on the other sheets. Here you will work with a workbook that uses multiple worksheets.
You can change the order of sheets within a workbook by moving them, but you must be careful. Just as moving rows before or after the last reference in a cell range can cause formulas to be incorrect, the same is true when moving sheets. E.g. point to a sheet tab. Press and hold the mouse button. Drag the mouse pointer with the sheet icon until the black triangle is pointing between the other sheets. Then release the mouse button.
Copying a sheet within a workbook. Select the sheet. Hold down the Ctrl key and drag the sheet to the right, on top of sheet the other sheet. Release the Ctrl key and the mouse button.
In Excel, you cannot use the Cut, Copy, and Paste commands to move or copy sheets. You can, however, use the shortcut menu to insert and delete sheets. Right-click on the sheet tab you just created. Choose Delete and click on ok. you have just deleted the sheet. Now when you insert a sheet, the new sheet is inserted sheet and becomes the active sheet. Right-click on the Summary sheet tab and choose Insert. Click on Ok.
Linking Cells in Different Workbooks
You can link workbooks by writing a formula in one workbook that refers to a value in another workbook. Here you will build, save, and edit formulas that link workbook files. You’ll also use a summary workbook to establish and maintain links to cells in other workbook files. E.g. the files, open dialog box is displayed. Select Hanover.xls. press the Ctrl key and select Monder.xls, Rene.xls, and Summary.xls. Selecting the files is the first step in opening several workbooks at the same time. Click on Open. Choose window, Rene. The worksheet shows item code and price, along with quantity, sales, and commission. If you’d like, activate the workbooks for Monder and Hanover to observe their sales worksheets.
E.g. entering a linking formula that will contain external references to the three salespersons’ workbooks. Cell A5 is selected. Type the equal sign (=) to begin to enter the formula. Choose Window, Rene. Click on the Total Value. Observing the formula bar. An external reference to the Rene.xls workbook is contained in the formula. This formula links the Summary.xls and Rene.xls workbooks. The cell reference is absolute: you can change that by editing the formula manually. Type the plus sign (+) to continue the formula. Choose Window, Monder. Click on the total value. Type the plus sign (+) choose Window, Hanover. Click on total value. Then press Ctrl + Enter to complete the formula. When there is any change Totals will change in the summary workbook. The summary workbook is called the dependent workbook, since it contains the linking formula with external references. The workbooks to which the linking formula refers are called the source workbooks.
To ensure that source workbook formulas have been calculated and that document names are current, save the source workbooks before saving their dependent workbooks.
When you open a file that contains one or more linking formulas, you can us4e the Edit, Links command to open source workbooks, update the formula calculations, or change the source workbooks. E.g. open New summary.xls. The workbook contains links. Because you do not have all the source documents open, Excel asks if you want to update the linked formulas with the latest data from the source workbooks. Click on Yes. The New summary workbook is identical to the My Summary workbook you created. However, you can verify the source workbook links. Choose Edit, Links. The Links dialog box enables you to see the workbooks upon which the current workbook depends. You can open any or all of these files. Select Rene.Xls. Click on Open Source. close the Rene.xls workbook. Choose Edit, Links. Select Rene.xls. click on Change Source. The change Links dialog box enables you to select a new workbook to which to link New Summary. In the first list, select My Rene.xls. Click on Ok. Click on Ok again.
Using Comments
A comment is a text that contains information about a worksheet cell. Here you will create and control comments to documents your workbooks more effectively. Comment indicators are displayed automatically for cells that have comments attached. A comment indicator is a small triangle in the upper-right corner of the cell. They do not print when you print a worksheet. E.g. select a cell. From the shortcut menu for the cell, choose Insert Comment.
Social Plugin