How do I copy a worksheet with numbers, captions, and formulas to another blank worksheet?
Open both the documents.
A
-1- Select the sheet from the source document.
-2- Click Move or Copy Sheet... from the context menu of the source sheet’s tab.
-3- Enable Copy.
-4- Select the new document from the dropdown list.
-5- OK.
-6- Delete the empty sheet from the new document if wanted.
B
-1- Edit > Selct All for the source sheet.
-2- Edit > Copy (or Ctrl+C)
-3- Select cell A1 in the new (empty) sheet.
-4- Edit > Paste (or Ctrl+V)