Microsoft Office Tutorials and References
In Depth Information
Consolidate Data from Multiple Worksheets
Chapter 5: Analyzing Excel Data
Excel adds the range to
the All References list.
0 Repeat steps 7 to 9 to
add all of the
! If you have labels in the
top row of each range,
click to select Top Row.
@ If you have labels in the
left-column row of each
range, click to select Left
# Click OK.
Excel consolidates the
data from the source
ranges and displays the
summary in the
If the layout of the source data changes, then you will need to run the consolidation
If you consolidated by position, then before you can re-run the consolidation, you must
first adjust the layout of the consolidation worksheet to match the changes to the
source data. (You do not need to do this if you consolidated by category.)
No matter which consolidation method you used, before you run the consolidation
again, you must delete the existing source ranges. Click the Data tab and then click
Consolidation to display the Consolidate dialog box. For each source range, click the
range in the All References list and then click Delete.