Thursday 12 May 2016

How to move / copy excel sheet from one workbook to another workbook Step by step demonstration

1. Open two Excel workbooks at a time

 

2.    Press "Alt+h+o+m "  

 

This will give following window.

 

 

3.   Press "Alt+t"    (Press both keys simultaneously.  

 Following window will appear.

 4.    Select destination workbook, i.e select the workbook where you want to move sheet. In our example it is Book2, so we have selected book2 in the figure shown above.


5.   Press "Alt+b"  (for placement of sheet )    This step is optional

 

 6.        Press enter key.




  • it's done.  
  •  

     

     To  copy excel sheet from one workbook to another workbook

  • 7. After step 2 press "Alt+c "(It will copy the sheet instead of moving .

     

     

     

     

     

     

     

    No comments:

    Post a Comment