Q. I know how to link data from a cell in one worksheet to another worksheet, but how can I transfer a formula? A. To transfer data, enter them in sheet ...

You don’t need to manually re-enter Excel spreadsheet data in another workbook. Learn how to copy a worksheet to another workbook here.

Choose the worksheet you want to copy the data to, and then select where you want the data to appear. Press "Enter" or click "Paste" in the Clipboard group to copy the cells to the new location.