lkpfocus.blogg.se

In this window, there is a drop-down called To book. Click on this drop-down.Once you select this option, it will show you the new window.Right-click on the sheet you want to move and select Move or Copy.In the workbook Worksheet 2, I have a sheet name called Data Sheet, and I want to move this worksheet to another workbook called Worksheet 1. I have opened both the worksheets at this point in time. My two workbook names are Worksheet 1 and Worksheet 2. For this, we need a minimum of two workbooks to be opened. If you want to move the entire worksheet to a new workbook, you can apply this method. Method #3 – Move Sheet to Another workbook The new sheet will be the same as the existing worksheet with (2) in front of it. It will create a copy of the worksheet for you.In the new window, select Sheet 1 & check the box, create a copy, and click on OK. Once you click on Move or Copy, it will show you the new window.Right-click on Sheet 1 and select Move or Copy.I will take the same workbook here as well. If you want to create a copy or a replica of the existing worksheet in the same workbook, we can apply this method. Method #2 – Copy Sheet within the same workbook Once you click on Move or Copy, it will show you a new window.