You can copy and paste the sheet:
–Into the current document.
–Into another document that is currently open.
The following rules apply when copying:
–When copying to another document, only links, notes, tables, and functions whose arguments are located on the current sheet are saved.
–It is not permitted to copy sheets into documents with a protected structure or open in the view mode.
–If the document has protected structure or is open in the view mode, copying sheets within this document is not allowed. Sheets can only be copied to another document.
–If a tab color was selected for the original sheet, the copy sheet will inherit this color.
To copy a sheet, follow these steps:
1.Right-click the sheet tab.
2.Run the Copy to command from the context menu.
3.In the Copy sheet window, specify the conditions for copying:
•Copy to file: The document to which you want to copy the sheet. The list displays all currently open documents. The current document is selected by default.
•Place before sheet: The name of the sheet before which you want to place the copied sheet. Hidden sheets are not displayed in the list. If you want to place the sheet after all sheets, select To the end of document.
4.Click Copy.
The created copy of the sheet will open in the specified location of the current or another document. By default, the copy will be named in the format <original_sheet_name>-<copy_number>, for example, Data-1. If necessary, you can rename the sheet.