Moving Worksheet From One Workbook to another

If you're new here, you may want to subscribe to my RSS feed or Email alerts. Thanks for visiting!

Yesterday, I was completing some class work, and were to send a worksheet to my faculty. I tried copying the whole worksheet and pasting it in a new workbook, but i saw that some of the formatting was lost. I tried it several times, but the result was same. Then i decided to make of copy of that file, and delete the other raw data, and send the file. But as soon as i Right clicked on the sheet to delete that, i saw an option “Move or Copy…”. That’s it, i was looking for something like this. Here is how I used this option to move my worksheet from one workbook to a new one.

• Open your Workbook, and right click on the sheet you want to move or copy.
• A new window asks you to move within sheets or to a new workbook.
• If you want to move to an existing workbook, then open that workbook as well, and it will show in options.
• If you want to copy the worksheet check “Create a Copy”, and if you want to move, just leave it blank.

You have now moved or copied your worksheet to a new workbook. To Move a file, you can just drag and drop that worksheet to another workbook as well. Apart from that, to Copy that file, just hold the CTRL while drag and drop.

Related Posts:- Installing Windows in Unattended Mode
Lost Password for Your Word/Excel Documents?
Math Add in for Word 2007
Customize Quick Access Toolbar in Word 2007