{"id":12150,"date":"2012-07-01T11:59:42","date_gmt":"2012-07-01T11:59:42","guid":{"rendered":"http:\/\/www.learnexcelmacro.com\/?p=2088"},"modified":"2017-07-20T11:36:16","modified_gmt":"2017-07-20T11:36:16","slug":"cell-drag-and-drop-option-in-excel","status":"publish","type":"post","link":"https:\/\/vmlogger.com\/excel\/2012\/07\/cell-drag-and-drop-option-in-excel\/","title":{"rendered":"Allow Cell Drag and Drop Option in Excel 2003, 2007 and 2010"},"content":{"rendered":"
Hi Friends,<\/p>\n
Before I go and explain you how to enable or disable drag and drop option in Excel, let me explain you what is Drag and Drop Option in Excel.<\/p>\n
When you select a Cell in Excel and roll your mouse to the Right-Bottom<\/strong> Corner, one Plus Sign ( +<\/strong> ) will be appearing. On Clicking on that you can drag towards Column or Row in any Direction like Left, Right, Above or down. After dragging you can copy the Cells data in all the Cells till you dragged.<\/p>\n Huuuhh… without this working with Excel seems difficult because you are not able to drag a Series or Formula and many more things. Then you start looking for option to make this function enabled. Here is the step-by-step solution for that. It differs in Excel 2003 and 2007 or 2010. I will show you, how to Enable\/Disable this property in Excel 2003 and 2007. In Excel 2007 and 2010, it is same.<\/p>\n [one_full spacing=”yes” last=”yes” center_content=”no” hide_on_mobile=”no” background_color=”#FEEFB3″ background_image=”” background_repeat=”no-repeat” background_position=”left top” link=”” hover_type=”none” border_position=”all” border_size=”1px” border_color=”#f4b327″ border_style=”dashed” padding=”10px” margin_top=”” margin_bottom=”” animation_type=”0″ animation_direction=”down” animation_speed=”0.1″ animation_offset=”” class=”” id=””] Follow the below Steps:
\nWhile working on Excel, you suddenly find that you are unable to Drag and Drop a Cell. You DO NOT see the little dot at the Right-Bottom corner of your selected cell or range, clicking on which you see a plus sign to hold and drag it in all directions (Up, Down, Left and Right). Refer the above picture (gif)<\/p>\n
\nNote: <\/strong>Cell drag and drop option is applicable for Excel as an application. This means, if you disable it in any of your Excel workbook, it will get disabled for Excel application in your computer. It means any workbook you open, you will find it disabled. Similarly, enabling it in any workbook will enable it for all the workbooks you open thereafter[\/one_full] <\/p>\nHow to Enable or Disable Cell Drag and Drop Option in Excel 2003<\/h1>\n
\nStep 1. <\/strong> Go to Tools –> Options <\/strong><\/p>\n