Copying/Moving a Cell(s) Between Sheets/Workbooks

Follow by Email

In this article, you’ll learn how to copy and move a cell(s) between sheets/workbooks in Microsoft Excel.

We need to move or copy options for various purposes, but usually we move our sheet when we prepare any report on the basis of data and we just want to send only report to management. But, yes, as per our requirement, we can use it for any purpose.

We can see “Move and Copy” option in the Home tab:-

Home tab > Cells group > Click on Format > Move or Copy

image 1


Let’s take an example and understand:-

We have a workbook in which we have 3 worksheets. In this workbook, we have Dashboard sheet, Calculation sheet and Data sheet, from which we want to move or copy only dashboard sheet.

image 2


Follow below given steps:-

  • Right click with the mouse on the dashboard sheet
  • Pop-up will appear

image 3


  • Click on Move or Copy… option
  • Move or Copy dialog box will appear

image 4


  • Check the option of “create a copy”

image 5


  • Click on drop down list of To book:

image 6


  • From the list, select the workbook in which you want to move the sheet
  • Click on OK
  • New workbook will be created

image 7


In this way, we can move or copy the sheet between workbooks in Microsoft Excel.


image 48

If you liked our blogs, share it with your friends on Facebook. And you can follow us on Twitter and Facebook, too.

We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. Write us at [email protected]


Please follow and like us:

Leave a Reply

Your email address will not be published. Required fields are marked *

two + = 8

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>