University of Maryland--College Park has a total undergraduate enrollment of 28,472, with a gender distribution of 53 percent male students and 47 percent female students. At this school, 40 percent of the students live in college-owned, -operated or -affiliated housing and 60 percent of students live off campus.
Consolidate Spreadsheets. First, open Excel and open both of the files you're looking to merge. Make sure the column headers are the same. Now open a new spreadsheet, which will be the destination for your merged data. From this new spreadsheet, click on the Data tab and click on Consolidate..
All copies of a shared workbook should be located in the same folder as the shared workbook. Click the Microsoft Office Button , and then click Excel Options. In the Customize category, in the Choose commands from list, click All Commands. In the list, click Compare and Merge Workbooks, click Add, and then click OK. Open the copy of the shared workbook into which you want to merge the changes. On the Quick Access Toolbar, click Compare and Merge Workbooks. If prompted, save the workbook. In the Select Files to Merge into Current Workbook dialog box, click a copy of the workbook that contains the changes that you want to merge, and then click OK.