How to copy an entire worksheet in Excel

When working in Microsoft Excel or other spreadsheet programs, it's good to make multiple copies of a workbook or worksheet. A few reasons to make these copies are:

• If you need to create several revisions of the workbook/worksheet, make copies in case you need to revert to a previous version.
• If you're sending a workbook/worksheet for review, make a copy so you have the original to compare any changes.
• If you're worried about someone making unauthorized changes to your workbook/worksheet, send yourself a copy to let you know if anything was changed.
• If your file accidentally gets deleted, you have a backup.

There are several ways to copy the information from a workbook or worksheet to a new or existing workbook. Below, we explain a few of them.

How to copy information from one worksheet to another in the same workbook

1. Open the workbook.
2. Click the worksheet containing the information you want to copy. For this example, we chose Sheet1.

3. Press Ctrl+A to select the entire worksheet, then press Ctrl+C to copy the information.
4. Click the worksheet where you want to paste the information. For this example, we chose Sheet2.

5. Press Ctrl+V to paste the previously-copied information.

How to copy information from one worksheet to a different workbook

1. Open the workbook containing information you want to copy.
2. Click the worksheet containing the information you want to copy. For this example, we chose Sheet1.

3. Press Ctrl+A to select the entire worksheet, then press Ctrl+C to copy the information.
4. Open the spreadsheet containing the workbook and worksheet where you want to save the information. You can also create a new spreadsheet and worksheet.
5. Press Ctrl+V to paste the previously copied information.

How to copy an entire workbook

There are two ways to accomplish this task which are essentially making a copy of an existing workbook.

How to copy the entire workbook in the folder

1. Locate the folder containing your workbook. For example, we saved our workbook to the desktop.
2. Right-click the file and select Copy, or click the file and press Ctrl+C.

3. Right-click an empty spot on the desktop (or folder) and select Paste, or press Ctrl+V.
4. The document is saved with the previous name and adds "- Copy" to the end of the file name. You can right-click the new file and rename it if desired.

How to copy the entire workbook with the existing workbook open

1. Open the workbook.
2. In the Excel menu, click File.

3. Click Save As.

3. Choose the location where you want to save the new workbook (A).
4. Type a file name for the new workbook (B).
5. Click Save (C).

6. You now have two copies of the same workbook. If changes are made to the new workbook, they are only saved to the new workbook, not both.