When copying a sheet within the file, you can use the "Duplicate" command. When copying a sheet to a new file or an existing file, you need the "Copy to" command, which is the same as "Move and Copy" from Microsoft Excel.
Step 1: Open the workbook and right-click the tab name;
Step 2: Click the "Copy to" from the dialog box;
Step 3: Select "New spreadsheet" if you want the sheet as a single file, otherwise to select "Existing spreadsheet";
Step 4: You will get a message when the new file is ready;
Step 5: Please note that the newly created document has the name of "Untitled spreadsheet", please change the name by following how to name or rename a Google spreadsheet.
