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.

References

Promoted By Zergnet

Comments

You May Also Like

  • How to Merge Workbooks in Excel 2003

    If several people are making changes to an Excel workbook, you may want to merge all the copies back into one master...

  • How to Merge Excel Worksheets Into a Workbook

    Microsoft Excel allows you to create multiple worksheets inside a workbook to group multiple data sets that are alike. However, sometimes you...

  • How to Merge XLS Files

    Microsoft Excel files are organized into a set of worksheets, each containing its own set of data. By default, a file has...

  • How to Combine 2007 Excel Files

    Microsoft Excel 2007 shared workbook files can be combined into one file using Excel's Compare and Merge Workbooks utility. This utility is...

  • How to Compare Sheets in Excel 2007

    Comparing Microsoft Excel worksheets is useful when you must analyze the similarities and differences of data. By using the "View Side by...

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!