How to enable cell drag in MS Excel 2010

Today when I opened my Excel sheet for editing, I found that the cell drag option is not working. For those who are not aware of this feature, the cell drag feature allows you to copy a cell content or its formula to all other cells in the same row by dragging it. It is a very useful feature and is active by default in MS Excel.

To enable this feature again just follow the steps given below. Enable cell drag in MS Excel 2010

  • Open MS Excel and click on File.
  • Under left side pane select Options , below Help.
  • In the Excel Options window, click on Advanced.
  • There check the box beside Enable fill handle and cell drag-and-drop and you are done.

The cell drag feature should work now in your Excel.