Compare two sheets in same workbook Open your Excel file, go to the View tab > Window group, and click the New Window. This will open the same Excel file in a different window. Enable View Side by Side mode by clicking the corresponding button on the ribbon.
Start by clicking your mouse in the “ Reference” field within the Function box. Then navigate to the first of the two worksheets containing data you want to consolidate. When you are on that sheet, use your mouse to highlight the desired cells. Click “ Add” in the Function box on your master worksheet.
To create a link to cells in an Excel table Start creating a formula that will include a value from cells in an Excel table. Click the sheet tab of the worksheet with the Excel table that contains the cells you want to include in the formula. Select the cell or cells to include in the formula. Press Enter.
Click the worksheet tab at the bottom of the screen that contains a range of precedent cells to which you want to link. A range is a block or group of adjacent cells. For example, assume you want to link a range of blank cells in “ Sheet1” to a range of precedent cells in “ Sheet2.” Click the “ Sheet2” tab.
To open the source of a linked value Open a workbook that contains a link to an external cell or cell range. On the Data tab of the ribbon, in the Connections group, click the Edit Links button. ... In the Edit Links dialog box, click the link you want to work with. Click the Open Source button.
Reference cells from other spreadsheets by adding the sheet name, followed by an exclamation point, before the cell reference. Use commas to separate up to 255 cell references in the Sum function. For example, "= SUM( Sheet2! A1, Sheet3! B2: B6)" adds the values in cell A1 of Sheet2 to the values in B3 through B6 of Sheet3.