How to Copy Data From One Spreadsheet to Another in Excel 2010. ... How to Merge Excel Worksheets Into a Workbook. Over the course ... hold down the "Ctrl" key and drag the data to the appropriate ...