May be you all know a lot about excel, I am writing this for those who are always curious and want to learn some shortcuts during their normal course of working to do their jobs quickly. I will post the simple solutions of day to day curies in this blog. If you have any question please feel free to ask...
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
No comments:
Post a Comment