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..
If you need to merge cells that already contain data, then it is a good idea to copy and paste that data to other cells on the spreadsheet, then move the data back after you have merged the cells. Step 1: Open your spreadsheet in Excel 2013. Step 2: Click the Home tab at the top of the window. Step 3: Use your mouse to highlight the cells that you want to merge. Step 4: Click the arrow to the right of Merge & Center in the Alignment section of the ribbon at the top of the window, then select the Merge Cells option. Note that there are several other merge options as well, so you can select one of those instead if it is more appropriate.