where copying a worksheet from one workbook (a collection of multiple sheets)
- Go to your “source” workbook (the one with the data you want to copy).
- Open your “target” workbook (the one you want to copy to). This can be a new workbook or an existing workbook.
- In your source workbook, look toward the bottom left-hand corner and find the name of the sheet you want to copy. Unless you’ve changed the name of the worksheet, it should have a name like “Sheet1.”
- Right-click on the sheet you want to copy (if you’re on a Mac with a single-button mouse, you may need to hold down the Command key while clicking).
- Select “Move or Copy…” from the menu.
- From the list, select where you want to move or copy the sheet to. You’ll need to go to the dropdown at the top to see other open workbooks.
Alternatively, you can move the worksheet from one workbook to another by dragging it with your mouse. However, it might be safer to copy it, at least until your comfort level with Excel increases.
If you ever have extensive data validation to do and want to avoid botching a formula, try the copying method. It can be a quick and easy way to make a backup workbook