Use Edit-Sheet-Move/Copy Sheet to create a copy of selected sheet and use the same data; it is used for following the order of worksheets in a document to create formulas that are linked between sheets.
Move or Copy Sheet
- Open the worksheet you want to move or copy.
- Click Edit-Sheet-Move/Copy Sheet.
- In the Move/Copy Sheet dialog box, select the location you want.
- If you want to copy the worksheet, select Copy and then click OK.
- A copy of the worksheet is moved or copied to the desired location.
Notes
Move/Copy Sheet with Mouse Drag
You can move or copy a worksheet by dragging it. Drag the worksheet you want to move and drop it to the location you want.
Copying a sheet with some objects is not supported
Copying of sheets containing some objects such as notes, shapes, pictures, charts, pivot tables, or tables is not supported. Use this function when copying sheets containing only data such as text and numbers.