Friday, December 10, 2010

How to Drag (घसीटना) in Excel

Initially,  it is necessary to know regarding what is drag (घसीटना) while using Microsoft Excel and what is its use. Drag is used in excel with the help of mouse or keys for example if you have typed 1 and 2 in excel and now you want to drag (घसीटना) it up to 20 numbers.  There is no need to type 3,4,5,6,7,8,9 etc.  It can be easily dragged as shown in below picture.
No doubt that above function if too much easy but important for those who are not using it .   It makes work easy in Microsoft Excel.
Secondly , many times we see that drag function do not work in excel.  We feel that some file of Excel has been corrupted and we uninstall Microsoft Excel and re-install the same.  After that Drag function will work again normally.  I have also done like this but now found that this problem was occurred due to virus and can be solved without un-installing the Excel.
For  Microsoft Office  2003 or up to Microsoft Office 2003 users
         Tool >Option > Edit > Allow Cell Drag and Drop (As shown in below Picture) 

For  Microsoft Office  2007 or upper version of Microsoft Office 2007 users
Menu > Excel Options > Advanced > Enable fill handle and cell drag-and-drop

(in this way drag option will work again without removing Microsoft Office and Installing again)

Intense Debate Comments