Basic Consolidate in Excel by Using Position

Before starting to know about basic consolidate in excel by using position, we must have the knowledge of what does consolidate means, In this tutorial you will go to learn consolidate, its work and when we use consolidate in excel. I hope that will you really enjoy this.

What is consolidate in excel?

If you want to combine your data from several worksheet into a single worksheet, in this situation you use consolidate option. In simple consolidate combine your data multiple into one.

How many ways to consolidate data?

There are two ways to consolidate your data by category or by Position, But you will learn about by position in this tutorial.

Consolidate by position- when the each range of the data in the list format and there are no blanks row and column within the list. Make sure all data separate on your worksheet, don’t put the range on the data where you think to select the consolidate, be sure each range of the data in same layout.
Select the range of the data which you want to consolidate on master worksheet, then go to consolidate option and click on it below image shows that how to use consolidate option.

                              Click on consolidate option, consolidate window front on your screen, you see reference option select the range of the data and click on add option, same process on second sheet, Go to second sheet and select the range of the data in reference option and click on add option and when you go to third sheet where you put your data, On third sheet check the mark of top row, left column and create link to source data and click ok. Below image show that the explanation to given above description in image step to step.
Step 1

  Step 2

 Step 3

Through the video you can better understand to given all description about this tutorial.

If you have found any mistake or have any doubt related to above basic consolidate in excel by using position tutorial then comment below.


People Also Interested : How to make a pie chart in excel?  
People Also Interested : Basic consolidate in excel by using category and label.