How to Merge Sheets in Excel 2007

Save

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

References

Promoted By Zergnet

Comments

You May Also Like

Related Searches

Check It Out

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

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