Question: how to copy data from one workbook to another in excel?
Answer: Copy a worksheet to another workbook Select all the data in the worksheet. Keyboard shortcut: Press CTRL+Spacebar and then press Shift+Spacebar. Copy all the data on the sheet by pressing CTRL+C. Open the workbook in which you want to paste the data, then click the + in the status bar to add a new blank worksheet.