Question

How we can move the sheet to anotherexcel workbook in excel?

Answer 1

Answer:

Answer:Sometimes you may need to move or copy the whole worksheet to another Excel workbook. You can move or copy a worksheet to another Excel workbook by following below steps.Note that "Move" means copying the whole worksheet to another workbook and deletion of copied worksheet from original workbook. "Copy" means the duplication of whole worksheet in another workbook

Step 1 - Make sure both workbooks are open in Excel (the workbook from where the worksheet is copied and the workbook to where the worksheet is copied or moved).

Step 2 - Right-click on the worksheet Tab which you want to move or copy to another workbook and select "Move or Copy" from the menu, as shown in below image. Note that the name of current active workbook name is "source_workbook.xslx", which is displayed in Titlebar.

# AnswerWithQuality

#BAL