Tuesday, February 28, 2012

How to Merge Sheets in Excel 2007


1. Click the Windows 'Start' button. Type 'excel' in the search text box. Press 'Enter' to open the Excel software.
2. Press 'Ctrl' and 'O.' In the dialog window that opens, double-click the XLSX file that contains multiple sheets you want to combine.
3. 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.
4. 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.'
5. Click 'OK' to combine the spreadsheets. Notice the original, first spreadsheet has all the combined data. Press 'Ctrl' and 'S' to save the changes.

Blogger news