How to copy Excel Worksheet into Excel Workbooks

If you are using Microsoft Excel regularly for your office and business purposes, one time or other time you will find it necessary to copy an existing worksheet into another workbook. It is very simple to do, let us see here how to do it.

move-excelsheet-workbook

How to copy Excel Worksheet into Excel Workbooks

You can easily copy the Excel Worksheet into the Excel Workbooks by simply dragging and dropping, which is enough for the basic Excel work. But in case if you are working with the large number of workbooks, then this tutorial can help you to keep the things neat and well organized.

  • First open the workbook with the sheet which you would like to copy and right click on the Sheet’s tab located at the bottom. From the context menu select Move or Copy.
  • Make sure that you have opened the workbook which you want to copy the sheet into. Now select the workbook which you want to move the sheet to. If the workbook which you want to copy the sheet isn’t open, it doesn’t display on the list.
  • It is also possible to copy or move the worksheet in the same workbook or create the new book with those worksheets. This will be handy when your workbooks become out of control with much info and all you need to do is get the basics sheets together.

That’s it, it is very simple to copy or move the Excel Worksheets into any other Excel Workbooks.

You may also like...