How to Merge Workbooks in Excel

Video Transcript

"Hi, my name is Dave Andrews. Today I'm going to show you how to merge workbooks in Excel. Let's open up Excel by clicking on the start button. Let's go to all programs. Microsoft Office, let's just open up Excel. Now what we're going to do, is create a workbook that multiple people can edit. The purpose of this is, we're in an organization where multiple people are going to be working on a spreadsheet. And then we want to merge all of those people's changes into one document. Let's begin by typing in a little bit data into this workbook. Now let's save our workbook. I'm just going to call it Book1. In order to allow merging, we have to first share the workbook. Go to Tools menu. And click 'share workbook'. We will check right here, allow changed by more than one users at the same time. This also allows workbook merging. It's going to warn you that it's going to save and ask you, if you want to cancel. I don't. Said just saved our workbook. Let's type in a little more data. I'm going to save this as Book2. I'm going to close Book2. I'm going to reopen Book1. Now that second line of data that I just typed down here, is stored in Book2. And I want to merge them together. To do so, click on tools. And go to Compare and Merge Workbooks. We will select workbook2. And as you can see, it's loaded in the data from my other workbook. And merged in together. My name is Dave Andrews. And I've just showed you how to merge workbooks in Excel."