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