1. Computing
If you have related data spread out over a number of locations, it can be difficult to keep track of it as you flip back and forth between the different worksheets. One way to simplify such a situation is to create a summary sheet using the consolidate feature.

This feature allows you to combine the data from different worksheets or even different spreadsheets onto a single page.

In addition, when consolidating data, you have the option of creating a link between the new worksheet and the original data sources. When linked, any changes to the original data are transferred to the summary sheet as well.

To find out how to use the consolidate feature, watch the video on how to Merge Spreadsheets in Excel.

Related Videos
November 5, 2013 at 10:58 am
(1) Ray says:

Thanks for the info, but what I need to do is combine a bunch of worksheets in the same workbook. I have about 200 worksheets in one excel workbook that I want concatenated into one worksheet.

Any help appreciated

March 31, 2014 at 8:21 am
(2) Eddy says:

Hi Ray did you manage? I am in the same boat looking for a solution,

Leave a Comment

Line and paragraph breaks are automatic. Some HTML allowed: <a href="" title="">, <b>, <i>, <strike>

©2014 About.com. All rights reserved.