How to Merge Sheets in Excel 2007


Microsoft Excel workbooks contain multiple sheets, which separate your data into sections. You can merge your sheets using the "Append Tables" feature in Excel 2007. These feature adds the data from the second sheet to your first one, combining all the data into one, long list. You can combine one or several spreadsheets in your Excel workbook file.

  • Click the Windows "Start" button. Type "excel" in the search text box. Press "Enter" to open the Excel software.

  • Press "Ctrl" and "O." In the dialog window that opens, double-click the XLSX file that contains multiple sheets you want to combine.

  • Click the "DigDB" menu item at the top, then click the "Table" sub-menu item, then click "Append Tables in this File." A configuration window opens.

  • Click each sheet you want to combine, and click the "Add" button. If you want to combine all sheets together, select "All Sheets," and then click "Add."

  • Click "OK" to combine the spreadsheets. Notice the original, first spreadsheet has all the combined data. Press "Ctrl" and "S" to save the changes.

Related Searches


Promoted By Zergnet


You May Also Like

Related Searches

Check It Out

Geek Vs Geek: Robot battles, hoverboard drag race, and more

Is DIY in your DNA? Become part of our maker community.
Submit Your Work!