Ask Your Question
0

how to copy worksheet to a new blank worksheet

asked 2018-05-04 19:31:54 +0200

Margmora gravatar image

How do I copy a worksheet with numbers, captions, and formulas to another blank worksheet?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
1

answered 2018-05-04 20:03:51 +0200

Lupp gravatar image

updated 2018-05-04 20:04:59 +0200

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)

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-05-04 19:31:54 +0200

Seen: 40 times

Last updated: May 04 '18