Next, in the Reference box, click the Collapse button to shrink the panel and select the data in the worksheet.Ĭlick the worksheet that contains the data you want to consolidate, select the data, and then click the Expand Dialog button on the right to return to the Consolidate dialog.
Here is an example in which three worksheet ranges have been chosen: In the Function box, click the summary function that you want Excel to use to consolidate the data. Note: To avoid overwriting existing data in the master worksheet, ensure that you leave enough cells to the right and below this cell for the consolidated data.Ĭlick Data > Consolidate (in the Data Tools group).
0 kommentar(er)
