Microsoft Office Tutorials and References
In Depth Information
5
Click and drag to
select the location of
your data or type the
cell range.
6
Click Add.
7
Repeat Steps 5 and 6
as necessary.
8
Click OK.
5
6
7
5
8
Excel consolidates your data.
l
Did You Know?
To include data from another workbook in your
worksheet, open the other workbook. In the
Consolidate dialog box in your original workbook,
place your cursor in the Reference field. Click the
View tab, click Switch Windows, and select the other
workbook. Click and drag to specify the data you
want to consolidate. Click Add. Click OK. Excel
consolidates the data.
Did You Know?
If you click Create Links to Source Data ( changes
to ) in the Consolidate dialog box, Excel updates
your consolidated data each time you make a change
to the data on which you base your consolidation.
Chapter 3: Copy, Format, and More
79
 
Search JabSto ::




Custom Search