How to Merge Cells in Excel

If you are using Excel for expense tracking, sales data comparison and other finance related stuff, you will probably come into a situation when two or multiple Excel spreadsheets should be rejoined and analyzed. Whether you have multiple offices or several people working on the same thing and using different spreadsheets, you will eventually need to learn how to merge cells in Excel. The cells you need to combine can be in the same workbook but different worksheets or in the totally different workbooks. Either way, you can merge spreadsheets and compare results you need.

How to Merge Cells in Excel  Placed in Different Workbooks

If you just want to have worksheets from different Excel files merged into one document, you can achieve that in 3 easy steps. Here is how to do it:

 

  1. Open Excel documents you want to merge.
  2. Right mouse click on the worksheet you want to merge with another one and click on the Move or Copy.

how to merge cells in excel

  1. On the drop-down menu Move selected sheets to book, select the appropriate document and click OK.

move worksheet

Note: The data you have moved to another Excel spreadsheet will be permanently deleted from the worksheet where was initially created. If you still want to keep a copy of that data, make sure you tick the Create a copy box.

By following these steps, you can merge data from one Excel spreadsheet to another but the data from merged spreadsheets will still be in different sheets. If you want to merge data from two different sheets into one for better data comparison, just keep reading.

How to merge cells in Excel that are in the same workbook?

The thing with joining two worksheets into one is that you cannot just add data from one worksheet to another, like you did in the first case. What you need to do is to create a master worksheet that will be empty. There will be placed the data from two or more worksheets if you follow these guidelines:

  1. Select the upper-left cell of the area in the master worksheet, where you want that consolidated data to show up.
  2. Go back to one of your worksheets and select the data you want to merge. In the tab Data, click on Consolidate (Data tools tab).

consolidate

  1. The window will come up like shown on the image below. From the Function drop-down list, choose the summary function that you want Excel to use to merge worksheets. The default function is SUM but you can also use other functions, according to your needs.
  2. Click the Browse button to find your workbook and the file path will be shown in Reference
  3. Go to another worksheet and select the data you want to merge. The Reference box will show up and you just need to go back to the first worksheet when the Consolidate dialog will reappear. Click Add You can repeat that action for all ranges you want to add to your merged worksheet.
  1. Press OK, and Excel will merge the worksheets for you.

Note: Make sure that data has the same layout and format and that there is no blank space within the rows.

Types of Excel Charts Used in the Classroom

classroom

Although there are many education technology tools that teachers use, and a vast number of them is tailored for any imaginable occasion, most teachers still don’t want to leave MS Office behind. It is widely known that PowerPoint and Word are the most popular programs among teachers because they can use them for research papers, essays, lesson presentations and handouts. However, a widespread use of Excel cannot be ignored. Some people think that Excel is only for accountants and auditors but the truth is, even teachers can use it. For instance, Excel charts can be very well employed into daily activities of one teacher. There are different types of Excel charts and each of them has different purpose in the classroom.

excel charts

Anchor Chart

Anchor chart is not a default Excel chart you can add in your spreadsheet but there are tons of Excel templates of anchor charts in Excel. Anchor charts are actually a powerful learning tool that help teachers not to lose track of the lesson and to help students remember the most important things. Anchor charts are usually printed out and displayed in the classroom for future revision and they can be used for all subjects.

Treemap Chart

These kind of charts can be used by students to present their family teachers or they can help language teachers with vocabulary lessons. Generally, they can help to any kind of writing.

Pie Chart

These charts are one of the most popular because of their visual look. They are usually colorful and represent the percentage. In elementary classroom it is especially convenient to use the pie charts when learning kids math basics and fractions.

Flow Chart

There is no default flow chart you can just insert into Excel spreadsheet but you can learn how to create a flow chart in Excel here. Flow charts are explanatory charts that give step-by-step guide to the students. Teachers can use them to further explain complex processes in physics, biology, history etc. Flow charts improve students’ organization skills and the learning process.

Bonus chart for busy teachers: Learn how to create bullet charts in Excel. Bullet charts are also necessary for teachers but not available in Excel. In other words, you need to make them by yourself.