Sometime back while working on excel 2010, it seems by mistake I disabled the option to use “cell drag and drop”. This feature allows you to drag the mouse and copy cells. If this option is disabled, your mouse pointer will never change to move pointer on selecting a particular cell.
Ok, here is what I mean. In the illustration shown below, mouse pointer is getting changed to move pointer as soon as I bring it to the edge of a cell.
There is some info available on the net for Excel 2003 and the earlier versions ie by going to Tools > Options > Edit and checking "Allow cell drag and drop", you can enable this option but there is no information regarding the same for Excel 2007 and Excel 2010. So how can you enable this option in 2010?
- Go to File > Options > Advanced > Enable file handle and cell drag-and-drop
- Check this box.
- Click OK and you’re done
I wish there was some “mapping file” available from Microsoft for mapping excel 2003 and earlier versions navigation to excel 2007/2010. It could save us a lot of time.
Want to get an update as soon as we publish new article? I recommend you to subscribe via RSS Feed. You can also subscribe by email and have new articles sent directly to your inbox. It's absolutely free!
If you work on a shared computer, you might want to password-protect your excel or word documents. How would you do it? There are a number of commercial tools available for this, but Microsoft provides a free, nice and elegant way.
The first time that I needed this feature, it took me a lot of time researching, so thought of sharing this tip with you all.
If you are using MS Office 2000:
- Open the document.
- Go to File > Save As. Click on Tools on top right side as shown.
- Click on General Options.
- The next screen will ask you for the password. Fill in your desired password.
- The next time onwards, whenever you open that file, the system will prompt for password.
If you are using higher versions of MS office:
Microsoft has made this process a bit simpler for higher versions. Simply go to Tools > Options > Security tab and fill in the desired password.
