The right way to Simply Transfer or Copy a Worksheet in Microsoft Excel


There could also be occasions while you wish to create a brand new Excel worksheet based mostly on an present worksheet. You possibly can simply copy a complete worksheet in Excel to a brand new worksheet in the identical file and even to a brand new, separate workbook utilizing the “Transfer” or “Copy” command. It’s one of many many nice options in Excel.

RELATED: 7 Useful Microsoft Excel Options You Might Have Missed

Transferring or Copying Worksheets in Excel

Choose the worksheet you wish to transfer or copy. Proper-click on the worksheet’s tab on the backside of the Excel window. Choose “Transfer or Copy” from the menu.

Choose "Move or Copy" in the menu.

You may as well choose the worksheet and click on the “Format” button within the “Cells” part on the “Dwelling” tab within the ribbon.

Then, choose “Transfer or Copy Sheet” within the “Set up Sheets” part of the drop-down menu.

Select "Move or Copy Sheet" in the menu.

The “Transfer or Copy” dialog field will open. Within the “To E book” drop-down checklist, choose the workbook you wish to transfer or copy the chosen worksheet to.

You possibly can choose the present workbook (the default) or one other present workbook. You may as well create a brand new e book to comprise the moved or copied worksheet.

Should you’re shifting or copying the worksheet to the present or one other present workbook, choose the worksheet you wish to come earlier than the one you’re shifting within the “Earlier than Sheet” checklist.

For instance, choose “(Transfer to Finish)” to insert the worksheet in spite of everything the prevailing worksheets within the workbook.

Choose the “Create a Copy” checkbox if you wish to copy the worksheet and depart the unique alone. Then, click on “OK.”

Move or copy the sheet to the same workbook.

Should you’re copying the chosen worksheet to the present or one other present worksheet, the brand new worksheet is labeled with a sequential quantity on the finish of the worksheet title to tell apart it from the unique.

A copied Excel worksheet.

To repeat or transfer the chosen worksheet to a brand new workbook, choose “(New E book)” from the “To E book” drop-down checklist on the “Transfer or Copy” dialog field.

Once more, choose the “Create a Copy” checkbox to repeat the worksheet as a substitute of shifting it. Then, click on “OK.”

Move or copy the worksheet to a new Excel workbook.

A brand new workbook is created and the chosen worksheet is moved or copied into the brand new file.

A worksheet copied in a new Excel workbook.

You may as well copy and transfer a worksheet manually by clicking and dragging the worksheet tab to the brand new location. If you wish to copy or transfer the worksheet to a brand new workbook, you’ll want to create the brand new workbook file first.

And that’s the way you rapidly transfer or copy information in your Excel spreadsheets.

Utilizing Google Sheets? You possibly can copy and transfer spreadsheets inside that platform too.

Supply hyperlink